Create Table Syntax

[tapks]

HI!

In SQL Server 7.0 I can create a table with wrong syntax i.e.

create table Test (id int, descr varchar(10),)

Can anybody tells me whether this whether it is a feature in SQL Server or so.

Pl help.

Tap_Ks

 

[ClaireHCM]

Correct it to

create table Test (id int, descr varchar(10))

 

[tapks]

Thats ok. I want to know that whether it is bug of MS SQL server or not. Did Anybody face this before ?

Pl let me know.

 

[tlbroadbent]

Bug or feature? It is allowed in SQL Server 7 and 2000. SQL must treat the missing parameter as NULL.

If you want to get the best answer for your question read faq183-874 and faq183-3179.
Terry L. Broadbent - DBA
SQL Server Page:

http://tlbroadbent.home.attbi.com/sql/sql_articles.htm