sql server 2008 - how to carry over the sequence number from one table to another? -


i want create 2 tables, , want create common sequence id both tables. sequnce id should not duplicated in both tables. trying create using identity, dont know how carry on maximum id table 1 table 2.

i using ms sql server 2008.

i want 2 tables similar below,

table 1:

seq_id    value1 value2  1           x     y  2               b 

table 2:

seq_id    value1 value2    3             j    4        k      l 

doesn't sequence object work ? think best solution in case, need try it.

regards!


Comments

Popular posts from this blog

Android : Making Listview full screen -

javascript - Parse JSON from the body of the POST -

javascript - Chrome Extension: Interacting with iframe embedded within popup -