SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2008 Forums
 Transact-SQL (2008)
 create temp table syntex
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

chetanb3
Yak Posting Veteran

India
52 Posts

Posted - 05/15/2013 :  01:55:55  Show Profile  Reply with Quote
I am wondring why the below syntex for create table or temp table works. It should give syntex error nut it works on 2008

create table #temp
(
id int,
)

visakh16
Very Important crosS Applying yaK Herder

India
52249 Posts

Posted - 05/15/2013 :  02:12:39  Show Profile  Reply with Quote
Similar discussion here

http://beyondrelational.com/modules/2/blogs/70/posts/18552/question-of-the-month-december-2012-why-is-last-comma-ignored-in-create-table-statement.aspx

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
https://www.facebook.com/VmBlogs
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.03 seconds. Powered By: Snitz Forums 2000