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)
 problem constraints

Author  Topic 

rammohan
Posting Yak Master

212 Posts

Posted - 2006-10-04 : 05:16:29
hi,
here i am trying to create a table in which i want give a property autonumber(i.e increments simultaneously for each new row) to a field.pls tell me the procedure for this in sql server2005


doubt2:
i had created a table before with one primary key column. next i want to add a new column to the table and it also be a primary key.
what is the procedure to add a primary key constraint column in a table if that table has already a primary key. i want multiple columns must contain primary key constraints.

thanx in advance,
rammohan

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2006-10-04 : 05:20:32
This is the second time we tell you to NOT CROSS POST!
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=72968


Peter Larsson
Helsingborg, Sweden
Go to Top of Page
   

- Advertisement -