how to insert numbers in sequence in sql table using sql query

Question

1.00/5 (3 votes)

See more:

Hi Experts,

I have a table with name SerialNoInfo, In this table I want to Insert Numbers from 0001 to 10000 into Column(Serialno) by using sql query.

for example as:

0001
0002
0003
0004
0005
0006
.
.
.
.
.
.
.
10000

Please help me.
Thanks.

Posted 25-Aug-14 2:06am

Member239258

Add a Solution

Comments

Thanks7872 25-Aug-14 8:10am

Your previous question was closed because it doesn't make any sense. Posting it over and over again won't help you. Stop it or it will be considered Abuse.

Magic Wonder 25-Aug-14 8:25am

A..gain Report it abuse and down vote the solution.

Thanks7872 25-Aug-14 8:55am

I always downvote some thing which doesn't make any sense.

King Fisher 25-Aug-14 8:15am

do you have any values in your Table upto 10000 Rows?

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

OriginalGriff · Answer 1 · 2014-08-25T02:21:00

Try:

SQL

DECLARE @Start int
DECLARE @End int
Select @Start=1, @End=10000
 
;WITH Sequence( Number ) AS
(
    SELECT @start AS Number
    UNION ALL
    SELECT Number + 1
        FROM Sequence
        WHERE Number < @End
)
INSERT INTO Table_2 (Val)
SELECT * FROM Sequence Option (MaxRecursion 10000)

member33 · Answer 2 · 2014-08-25T08:39:00

Solution 2

If you access to master table

With out the loop

SQL

INSERT INTO Table_2 (Val)
SELECT distinct number
        FROM master..spt_values
        where number between 1 and 1000

Posted 25-Aug-14 8:39am

member33