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)
 insert data into a table

Author  Topic 

rajeshskpm
Starting Member

10 Posts

Posted - 2009-05-06 : 07:44:52
hi
I created a table employee(id ,name,designation,address) where id is primary key...
i am connecting this with a windows form in order to insert data.ie windows form contain following field name ,designation ,address.
and these values we can insert ...but how to insert id value automatically( id is a PRIMARY KEY). CAN U WRITE A QUERY FOR THAT?


rajesh

sakets_2000
Master Smack Fu Yak Hacker

1472 Posts

Posted - 2009-05-06 : 07:46:14
you might want to define it as an identity column. Look for identity column in BOL.
Go to Top of Page
   

- Advertisement -