c# query with space in Sqlt table

Question

Is there someone who can help me?

I have to do a query in a database which was created by someone else. The problem I encounter is that the name of the table contains three spaces.

Example of the query: "SELECT * FROM Item Journal Line".

It does not work anyway, I've tried by surrounding the tablename with [], `, ´´, '',´ but nothing is working.

Any suggestion on how to address this table in my query? I've searched on the web but I did not find anything which could help me. I'm working in c# with SharpDevelop.

I don't see double-quotes listed: `String sqlString = @"SELECT * FROM ""Item Journal Line""";` — DonBoitnott, Jun 13 '13 at 12:11
http://stackoverflow.com/questions/6498251/query-a-table-that-has-spaces-in-its-name-ms-access-c-sharp-vs2008 (If using Access) — Dave, Jun 13 '13 at 12:17
Congrats to the developer create table with such name. When you say does not working what do you mean. Are you getting exception or does not return values? — kostas ch., Jun 13 '13 at 12:18
@Serge what do you want to say by DBMS? the code seems to be good because when i try with an other table without space in the name i do not have any problem... — pidel, Jun 13 '13 at 12:18
Dave Rook i think your r abslutely right. It work and on sql — kostas ch., Jun 13 '13 at 12:19
@kostas ch -> i'm in accord with you... else i have an exception — pidel, Jun 13 '13 at 12:20
@pidel, he means what database management system are you using? MS SQL Server? MySql? Access? — valverij, Jun 13 '13 at 12:20
I have just create a table with the name and in my select command select dd from [test test test] it plays very well. — kostas ch., Jun 13 '13 at 12:21
@pidel If it's SQL server database, it should work with `SELECT * FROM [Item Journal Line]`. had you missed something ? — Agent007, Jun 13 '13 at 12:28

Mzf · Accepted Answer · 2013-06-13T12:51:05.463

3

If you table name is test table

In MSSQL (which i guess this is what you are using) run

select * from "test table"

To create this string in C# use Escape Sequences, and escape " with\"

string queryStr = "select * from  \"test table\" " ;

edited Jun 13 '13 at 12:51

answered Jun 13 '13 at 12:28

Mzf

5,210
2
24
37

Steve · Answer 2 · 2013-06-13T12:45:44.480

The sanctioned way to access a Sql Server database table containing spaces or other reserved characters is through the use of square brackets. But you should not include the dbo part in that otherwise the search will fail because there is no table with dbo as first 3 characters.

string strConnection = "server=***;" + "database=***;" + "uid=***;" + "pwd=***;"; 
string query = "SELECT * FROM [Item Journal Line]";
using(SqlConnection myConnection = new SqlConnection(strConnection))
using(SqlCommand command= new SqlCommand(query, myConnection))
{ 
     myConnection.Open(); 
     SqlDataReader reader = command.ExecuteReader() 
}

However, if your really have tables with so weird names, consider to create a view with more easier names to work with

score 1 · Answer 3 · answered Jun 13 '13 at 12:41

1

In Postgresql

 String query= "select * from appsetup.""fsd sdfsd sdfds"""

pass this query in `command`

answered Jun 13 '13 at 12:41

Sathish

4,419
4
30
59

score 0 · Answer 4 · edited May 23 '17 at 11:49

Dave Rook said it in your comments.

The answer to the question you asked is over here: Query a table that has spaces in its name

        string sqlQuery = "SELECT * from [Item Journal Line]";

Did this solve your problem? Maybe someone added a space or something evil in the name of your table.

        string sqlQuery = "SELECT * from [Item Journal Line /n]";

If this isn't solving your problem it could be something else besides what you have asked, can you post the error message or tell us if the problem is resolved?

c# query with space in Sqlt table

4 Answers4