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
 SQL Server Development (2000)
 how to insert identity values

Author  Topic 

Jagadish25
Starting Member

3 Posts

Posted - 2005-10-03 : 15:06:46
hi to the group,
i am small problem,
i am having two columns 1 is col1 which is a primary key and col2 any think .now i want to insert the data into second column at that time the first column must get the values in identity (like 1,2,3,4 etc)
with out using identity(sql server)/generated always(db2)
can any one knows please explain it

Kristen
Test

22859 Posts

Posted - 2005-10-03 : 15:42:05
Duplicate of http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=56002
Go to Top of Page
   

- Advertisement -