I need to add a sequence of numbers using SQL into a existing table. I need help with making the sql query (not a stored procedure) which can do this.
I have a range of numbers (basically i am adding on to an existing range of numbers in the table) and I need to add the range say between 1000 and 2000 (in to column rangedvalue) in a table with the following columns:
primkey (pk) | rangedvalue | always0 | isAlwaysNull
1 1000 0 NULL
2 1001 0 NULL
3 1002 0 NULL
4 1003 0 NULL
n nseq 0 NULL
You can use my column names for the query.
Many thanks in advance for your support.