Try this:
Code:DECLARE @x INTEGER DECLARE @y INTEGER SELECT @x= 100, @y = 10 BEGIN WHILE x <> 110 INSERT INTO tab_for_nulls(rollno, marks) VALUES(@x, @y) Set @x = @x+1 END END;
|
Results 1 to 4 of 4
Threaded View
|
Click Here to Expand Forum to Full Width |