i want to copy table data to another table using for loop in store procedure

Question

1.00/5 (1 vote)

See more:

Help with the Query fast

i want to perform this 'for loop' in stored procedure

for (int i=0;i<4;i++)
i want to copy table data to another table using for loop in stored procedure
By using #temp

Posted 1-Feb-16 19:45pm

Member 12301708

Updated 1-Feb-16 20:42pm

v2

Add a Solution

Comments

dan!sh 2-Feb-16 1:49am

You do not need to write loop. There are other ways. Search the web.

3 solutions

Solution 1

You do not need a loop to copy a table.

If its a new table, you can use Select * Into - SQL SELECT INTO Statement[^].

For an existing table, try something like insert into ABC_1 select * from ABC

Posted 1-Feb-16 19:52pm

Abhinav S

Comments

Member 12301708 2-Feb-16 1:57am

i want to copy data row by row

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)

_Asif_ · Accepted Answer · 2016-02-01T21:48:00

Solution 2

As other said you dont need to have a loop for such insertions, but anyway in complex scenarios we may require this kind of approach. this should get you going. sql - Inserting a multiple records in a table with while loop - Stack Overflow[^]

Posted 1-Feb-16 21:48pm

_Asif_

Dushant Reddy · Accepted Answer · 2016-02-02T18:56:00

Solution 3

User Cursor for your scenario :

DECLARE Select_ CURSOR FOR
select Col1,Col2 from ABC

OPEN Select_
declare @Col1 varchar(15),@Col2 varchar(15)

FETCH NEXT FROM Select_ into @Col1 ,@Col2
WHILE @@FETCH_STATUS = 0
BEGIN
insert into XYZ (Col1,Col2)
FETCH NEXT FROM Select_ into @Col1 ,@Col2
END

CLOSE Select_
DEALLOCATE Select_

Posted 2-Feb-16 18:56pm

Dushant Reddy

Comments

Member 12301708 4-Feb-16 1:14am

Thank you dushi0607