Eurodata Computing Logo Technical Tips



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.
Site designed and maintained by Eurodata Computing
© Eurodata Computing 2000-13    Last updated : April 2013
Valid XHTML 1.0 Transitional Valid CSS!