Help with SQL query in C#

Question

I'm trying to rename the columns. The syntax should be the column name between double quotes incase of two words, like this:

SELECT p_Name "Product Name" from items

So I'm trying to do it in C# code like this:

string sqlqry1 = "SELECT p_Name \"Prodcut Name\" from items";

But I get an error:

Syntax error (missing operator) in query expression 'p_Name "Prodcut Name"'.

It seems am having somthing wrong with the quotes, but I can't figure out.

I'm surprised people jump in to answer without knowing what database server it is — Philippe Leybaert
– Philippe Leybaert, Commented Mar 20, 2010 at 15:47

Larry Lustig · Accepted Answer · 2010-03-20 15:45:06Z

3

You don't specify what database you're using. Different DBMSes use different quoting systems for identifiers (like column names). Try:

 SELECT p_Name AS [Product Name] FROM items

or

 SELECT p_Name AS `Product Name` FROM items

which are two common systems. Also, use the AS specifier even though some DBMSes allow you to leave it out.

(PS: In the second example, the quote character is the backtick, generally on the same key as the tilde (~) on US keyboards).

answered Mar 20, 2010 at 15:45

Larry Lustig

51.2k16 gold badges119 silver badges173 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Larry Lustig Over a year ago

Always a pleasure to be of help.

DanSogaard Over a year ago

@gbn: I tried the first statement and its working without any errors: SELECT p_Name AS [Product Name] FROM items

Darin Dimitrov · Accepted Answer · 2010-03-20 15:43:54Z

1

You are missing an as:

string sqlqry1 = "SELECT p_Name as \"Prodcut Name\" from items";

answered Mar 20, 2010 at 15:43

Darin Dimitrov

1.0m275 gold badges3.3k silver badges3k bronze badges

5 Comments

gbn Over a year ago

Rubbish. it's optional. See msdn.microsoft.com/en-us/library/ms176104.aspx it says ...[ [ AS ] column_alias ]...

Larry Lustig Over a year ago

@gbn: Why are you citing microsoft docs when the OP did not specify what database he is using?

gbn Over a year ago

@Larry Lustig: care to bet? Does every DBMS require AS too?

Larry Lustig Over a year ago

Not "every" DBMS, but some do. Why introduce possible complications while debugging?

Philippe Leybaert Over a year ago

@gbn: you're right. I don't know any database server that requires "as". DB2, MySql, Sqlite, SqlServer, Oracle, ... They all don't care

Collectives™ on Stack Overflow

Help with SQL query in C#

2 Answers 2

2 Comments

5 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

5 Comments

Your Answer

Sign up or log in

Post as a guest

Related