Suppose I have a table named test with two fields(sl int,age int).
I want to insert 10 records all at a time.The records are in an incremental manner.I like to insert 1,2,3,4,5,6,7,8,9,10 for sl column and
22,23,24,25,26,27,28,29,30,31 for age column.But the procedure should follow C protype using for (j=1;j<10,j++) clause.
Is it possible to insert in SQL SERVER following c protype?
What is the fastest way for inserting multiple sequencial data?
Subhasish

There is no such construct as a FOR loop in TSQL. And TSQL is not C, by a long shot.

Best you can do is a WHILE loop in a stored procedure. In the loop, increment a local variable to use as a counter and BREAK out of the loop (or RETURN) when the termination value has been reached.

If you are generating values within the procedure, you will only be able to INSERT one row at a time, once for each loop iteration.

Jeff Mason
Custom Apps, Inc.
www.custom-apps.com

this is the answer

DECLARE @CNT INT
DECLARE @Q NVARCHAR(1000)

SET @CNT = 100
WHILE(@CNT < 1000)
BEGIN
    SET @Q = 'Insert into infostorageCompanies
    Values(' + CAST (@CNT AS NVARCHAR) + ',' + '''testCompany_9''' + ',' + '''''' + ',' + '''''' + ')'
    PRINT @Q
    EXEC sp_executesql @Q
    SET @CNT = @CNT + 100
END

moment