try
CREATE PROCEDURE INSERT_TWO (
@COUNT1 INT,
@COUNT2 INT
)
AS
BEGIN
DECLARE @OLDCOUNT INT
SET @OLDCOUNT = @COUNT2
WHILE @COUNT1 > 0
BEGIN
WHILE @COUNT2 > 0
BEGIN
INSERT TABLE1 (c1)
VALUES ('test')
SELECT @COUNT2 = @COUNT2 - 1
END
SET @COUNT2 = @OLDCOUNT
SELECT @COUNT1 = @COUNT1 - 1
END
END
GOEXEC INSERT_TWO 3,4
CREATE PROCEDURE INSERT_TWO (
@COUNT1 INT,
@COUNT2 INT
)
AS
BEGIN
DECLARE @OLDCOUNT INT
SET @OLDCOUNT = @COUNT2
WHILE @COUNT1 > 0
BEGIN
WHILE @COUNT2 > 0
BEGIN
INSERT TABLE1 (c1)
VALUES ('test')
SELECT @COUNT2 = @COUNT2 - 1
END
SET @COUNT2 = @OLDCOUNT
SELECT @COUNT1 = @COUNT1 - 1
END
END
GOEXEC INSERT_TWO 3,4
解决方案 »
- Ubuntu 10.1安装Sql5.5.21的问题
- sql 2000 远程访问问题?
- 求 sql
- 新手:帮忙看看这个E-R图有问题没
- Command line option syntax error. Type Command /? for Help
- 『急』求一SQL语句!!!! !
- 我从一台电脑上A备份了一数据库的备份文件,将它拷贝到了另一台装数据库的电脑上B,我在B电脑上也新建了同一名的数据库,然后恢复数据库
- sqlserver 应用系统(asp.net)发现某些操作很慢.
- 百分!求会话中测试锁效果的例子,欢迎讨论。。。。。。
- 数据库绝症,救命嘎!!!!!
- 关于image数据类型,有没有“直接”插入数据库的办法,而不通过用VB或别的程序
- 关于update
@COUNT1 INT,
@COUNT2 INT
)
AS
BEGIN
declare @i int
select @i=@count2
WHILE @COUNT1 > 0
BEGIN WHILE @COUNT2 > 0
BEGIN
INSERT TABLE1 (c1) VALUES ('test')
SELECT @COUNT2 = @COUNT2 - 1
END
SELECT @COUNT1 = @COUNT1 - 1
select @count2=@i
END
END
GO