How to use a variable as the seed to an identity column while creating tables. ask question. use fully dynamic sql and embed the seed value in the string containing the create table statement programmatically set identity seed in a table variable. 926. find all tables containing column with specified name - ms sql server. Ever tried to reseed an identity column in a table variable? no? let�s give it a go� let�s declare a simple table variable, @country, and insert a few rows.. Ident_seed (transact-sql) 03/14/2017; 2 minutes to read is an expression that specifies the table or view to check for a identity seed value. table_or_view can be a character string constant enclosed in quotation marks, a variable, a function, or a column name. table_or_view is char, nchar, varchar, or nvarchar..
One thing to note with this is that the value in the 3rd parameter (in this case the @maxid variable) denotes the current identity value - in other words the last identity value that was generated on the table.. Dbcc checkident doesn't work with a table variable. this works fine: set nocount on create table #tbl (rowid int identity, descr varchar(10) ) insert into #tbl select 'a' union select 'b' union. Identity column-- seed/increment value oct 1, 1998. i have created a table that generates a sequential id and a stored procedure that will return that id..
