Click here to Skip to main content
Click here to Skip to main content

SQL SERVER – Bad Practice of Using Keywords as an Object Name – Avoid Using Keywords as an Object

, 10 Dec 2011
Rate this:
Please Sign up or sign in to vote.
Avoid Using Keywords as an Object

Madhivanan is a SQL Server MVP and very talented SQL expert. Here is one of the nuggets he shared on Just Learned.

He shared a tip where there were two interesting points to learn:

  1. Do not use keywords as an object name
  2. [Read DHall's excellent comment below]

He has given an excellent example of how GO can be executed as stored procedure. Here is the extension of the tip. Create a small table and now just hit EXEC GO; and you will notice that there is a row in the table.

Create Stored Procedure:

CREATE PROCEDURE GO
AS
SELECT 1 AS NUMBER

Create Table:

CREATE TABLE T1 (ID INT)

Now execute the following code:

INSERT INTO T1(ID)
EXEC GO;

Now when selecting from table, it will give us the following result:

SELECT *
FROM T1

Now see the following resultset:

So without inserting any data we inserted the data, well indeed good puzzle but very bad practical practice. Everybody should be aware of this gotcha and avoid it. Thanks Madhivanan for teaching this interesting lesson.

Republishing here with authorization of Just Learned.

Reference: Pinal Dave (http://blog.SQLAuthority.com)


Filed under: CodeProject, Pinal Dave, PostADay, SQL, SQL Authority, SQL Query, SQL Scripts, SQL Server, SQL Stored Procedure, SQL Tips and Tricks, SQLServer, T SQL, Technology

License

This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

About the Author

pinaldave
Founder http://blog.SQLAuthority.com
India India
Pinal Dave is a Microsoft Technology Evangelist (Database and BI). He has written over 2200 articles on the subject on his blog at http://blog.sqlauthority.com. Along with 8+ years of hands on experience he holds a Masters of Science degree and a number of certifications, including MCTS, MCDBA and MCAD (.NET). He is co-author of two SQL Server books - SQL Server Programming, SQL Wait Stats and SQL Server Interview Questions and Answers. Prior to joining Microsoft he was awarded Microsoft MVP award for three continuous years for his contribution in community.
Follow on   Twitter

Comments and Discussions

 
GeneralMy vote of 5 PinmemberHeaven20209-Nov-12 5:06 
GeneralNot so black & white PinmemberMika Wendelius10-Dec-11 8:21 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.

| Advertise | Privacy | Mobile
Web02 | 2.8.140721.1 | Last Updated 10 Dec 2011
Article Copyright 2011 by pinaldave
Everything else Copyright © CodeProject, 1999-2014
Terms of Service
Layout: fixed | fluid