Hello Guys:
I want to create this table, but want the IDENTITY to start at a number say
(1000). How do I create it and get the IDENTITY to start at a predifned
number? I tried IDENTITY(1000) and this didn't work.
CREATE TABLE #tempSamples (
i_SamplesNewID int IDENTITY NOT NULL ,
i_SamplesOldID int NOT NULL ,
fk_Item int NULL ,
s_Caption Varchar (8000) NULL
) ON [PRIMARY]
Thanks
Andy
---------------------------------------------------------------------
Home : http://groups.yahoo.com/group/active-server-pages
---------------------------------------------------------------------
Post : [email protected]
Subscribe : [EMAIL PROTECTED]
Unsubscribe: [EMAIL PROTECTED]
---------------------------------------------------------------------
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/active-server-pages/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
