Post reply

Script for insert in a loop

  • October 30, 2008 at 2:23 pm

    #125685

    Hi,

    I want to insert data from one table to other continuously in loop.

    how can I do this?

    Thank You

  • October 30, 2008 at 3:25 pm

    #892099

    why would you want to loop it? why not batch load it?

    if you really want to loop it declare a variable as int, set it to 1 and do a while @MyVar < "number of iterations"

    ie

    declare @MyVar int

    set @MyVar =1

    while @MyVar < 10000

    begin

    set @MyVar = @MyVar + 1

    end

  • October 30, 2008 at 3:37 pm

    #892102

    Thank you

    Iam testing the restore scenarios to get the data upto point in time. So for that I need to generate the log in one database by inserting data from one table to other. Then I can take full, diff and log backups and crash the database at one point and try to restore all the backups to see to what point we got the data back.

    So to generate this type scenario what is the best method...plz advice me

    Thanks again

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply