passing variable to identity function

[delfy]

here is an example of what i am trying to do
declare @max_key

select @max_key = max(key) from parts

declare @parts_history table(
parts_history_key int identity(1,@parts_history)
)

why can't i use a variable in the identity function above

 

[vongrunt]

This is T-SQL limitation.

No big deal... create it as identity(1, 1) and then use parts_history_key + @max_key whenever you need "correct" value in SELECT statements.

------
[small]select stuff(stuff(replicate('<P> <B> ', 14), 109, 0, '<.'), 112, 0, '/')[/small]