|
| |||||||
| Quotations Quotations |
 |
| | LinkBack | Thread Tools | Display Modes |
05-15-2008, 07:07 PM
| |||
| |||
| I named an SQL table "order" but there is already an 'order' command. How do I show that it's a table name?
I already tried putting quotations around it, but it didn't work. I don't really know the difference between double quotations and single quotations either.
     |
|
05-15-2008, 08:34 PM
| |||
| |||
| I named an SQL table "order" but there is already an 'order' command. How do I show that it's a table name?
"order" is a reserved word and can't be used for field names.Rename it to OrderNum or Order#, for example.To learn about the use of single and double quotes, in SQL, click on the Help Tab.
|
|
05-15-2008, 10:00 PM
| |||
| |||
| I named an SQL table "order" but there is already an 'order' command. How do I show that it's a table name?
In SQL Server you can use square brackets for this, for example:create table [order]...select ... from [order]...
|
Linear Mode
