CREATE TABLE TEST_3(A INT ,B INT)
GO
drop PROCEDURE sp_test1
go
CREATE PROCEDURE sp_test1 (@NUM INT,@COUNT INT)
AS
BEGIN
DECLARE @A INT
SELECT @A=0
DECLARE @STR VARCHAR(800)
LOOP:
IF @A < @COUNT
BEGIN
INSERT INTO TEST_3 VALUES (@A,@NUM)
SELECT @A=@A+1
GOTO LOOP
END
END
goEXEC SP_TEST1 4,8
SELECT * FROM TEST_3
GO
drop PROCEDURE sp_test1
go
CREATE PROCEDURE sp_test1 (@NUM INT,@COUNT INT)
AS
BEGIN
DECLARE @A INT
SELECT @A=0
DECLARE @STR VARCHAR(800)
LOOP:
IF @A < @COUNT
BEGIN
INSERT INTO TEST_3 VALUES (@A,@NUM)
SELECT @A=@A+1
GOTO LOOP
END
END
goEXEC SP_TEST1 4,8
SELECT * FROM TEST_3
replace 字段1 with recno()
endscan