Eurodata Computing Logo Technical Tips
 
BorderTL
BorderTR




Software



Links

BorderBL
BorderBR
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!