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)
 Inserting values into a column

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2001-03-06 : 21:05:33
victor writes "I am using sql server6.5 as my database engine and windows nt
as the operating system.
I am trying to alter a particular column within an already
developed database by making it an identitiy column.This has
not been succesfull.
This database is a student database which was developed by a
third party with columns representing student id student name
etc. There is a column which has no values in it , which is the
column i am trying to insert values into. This values are
barcode representing each student in the library. The column
has a varchar datatype and i need to make it an identity column
so it will increase for each code entered.I also need to put
a check constraint on this column so as to validate a set
of already defined way of calculation. How best can i archieve
this."
   

- Advertisement -