How to put consecutive numbers into table for SQL not one by one

Question

Using below codes makes a table with one column as:

CREATE TABLE abc (a VARCHAR(8));
INSERT INTO abc VALUES(1),(2),(3),(4),(5),(6),(7)

But how we can use a method with using (1),(2),(3),(4),(5),(6),(7) , I mean something like 1:7 only?

Perhaps you can explain your question a little more clearly. ie a) You are using (1),(2) etc, and b) what do you mean 1:7? — , Oct 14 '13 at 21:16
Why MySQL @Fresh? This is valid SQL Server (for instance) syntax as well... — Ben, Oct 14 '13 at 21:16

score 4 · Answer 1 · edited May 23 '17 at 11:50

4

Did anyone say recursion??

with rec as (
    select 1 i
    union all
    select i+1 from rec where i < 7
)
select * from rec

edited May 23 '17 at 11:50

Community

1
1

answered Oct 14 '13 at 21:24

Adriano Carneiro

57,693
12
90
123

score 0 · Answer 2 · answered Oct 14 '13 at 21:23

If I am not wrong you are looking for a way to insert set of INT values in column in single batch. for example "insert 100 Identities in columnA." there is no predefined SQL SERVER function for that. but you can work around using any system table that you sure will have sufficient number rows you are looking for.

    SELECT rownum
    FROM
    (
        SELECT name,ROW_NUMBER() OVER (ORDER BY name) rownum
        FROM sysobjects so
    )q
    WHERE rownum <= 7

How to put consecutive numbers into table for SQL not one by one

2 Answers2