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)
 identity column

Author  Topic 

zakeer
Starting Member

20 Posts

Posted - 2008-03-18 : 08:03:22
Hi frnds

I have a table with two columns eid , ename . eid set identity(1,1).
After inserting 10 rows how can we insert a user defined eid ?

need help

Thanks & Regards
Zakeer

elancaster
A very urgent SQL Yakette

1208 Posts

Posted - 2008-03-18 : 08:10:11
IDENTITY_INSERT ...you can find it in Books Online

Em
Go to Top of Page

zakeer
Starting Member

20 Posts

Posted - 2008-03-18 : 08:25:53
Thanks my dear friend
Go to Top of Page
   

- Advertisement -