I've been trying to get the following script to work for a couple of
days and I am not sure what I'm doing wrong. Can somebody please
correct what I'm doing. I'm trying to change an existing field to an
IDENTITY field, but I'm getting syntax errors. It's got to be simple,
but somewhere I'm missing something.
Thanks in advance,
create table tbltest
(fldID int, fldname nvarchar(64))
alter table tbltest
alter column fldID int identity (1,1)
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!...