|
Tip : |
2 |
Technology : |
SQL Server |
Title : |
Using Keywords in SELECT Statements
|
|
If the name of a column in a SQL Server table is also a keyword then put the column name into square brackets to avoid SQL Server generating an error
e.g.
SELECT [Key] FROM MyTable
‘Key’ is a keyword but it is permissible (though bad practice) to use it as a column name.
|
Need further technical assistance ? Click here for more technical information.
Tech Tip Index
This article is provided 'as is' and no responsibility can be accepted for any errors.
No part of this article may be used or reproduced in any fashion without the prior consent of Eurodata Computing Ltd.
For syndication enquiries please contact us.
|
|