Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 Transact-SQL (2000)
 Insert with no values

Author  Topic 

iminore
Posting Yak Master

141 Posts

Posted - 2007-02-22 : 07:56:13
I have a table with just an identity column and a date with a default. However I get a syntax error when running:

insert into table

Any ideas?

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2007-02-22 : 07:57:38
insert YourTableNameHere default values


Peter Larsson
Helsingborg, Sweden
Go to Top of Page

iminore
Posting Yak Master

141 Posts

Posted - 2007-02-22 : 08:09:10
You're right. And I see it now in BOL.
Many thanks.
Go to Top of Page
   

- Advertisement -