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 2005 Forums
 Transact-SQL (2005)
 I want to insert in identity...

Author  Topic 

asifbhura
Posting Yak Master

165 Posts

Posted - 2010-02-06 : 05:57:17
Hi,
I have one table which is having only one column and it is identity column,

how can i insert records it this column

means it is connected with other table when I insert in other table at the same time in this table one records must be inserted

I tried like

INSERT INTO rec_count() VALUES()

but it gives error
Regards,
ASIF

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2010-02-06 : 05:59:52
you cant insert explicitly to identity column unless you set identity insert to on. but can i ask purpose of this table with single column? that too with identity property set
Go to Top of Page
   

- Advertisement -