USE TransactSQLTest
GO
DECLARE @DataInt INT
DECLARE @DataText VARCHAR(32)
DECLARE @ColumnName VARCHAR(10)
DECLARE @TempINT1 INT
DECLARE @TempINT2 INT
DECLARE @Number INT
SET @DataInt = 0
WHILE @DataInt < 300
BEGIN
DECLARE @SQLRUN VARCHAR(200)
SET @DataText=CONVERT(VARCHAR(32),@DataInt)
SET @Number = 1
WHILE @Number<1022
BEGIN
SELECT @ColumnName=CONVERT(VARCHAR(10),@Number)
SET @ColumnName = 'YC'+@ColumnName
SET @SQLRUN = 'INSERT INTO dbo.Test_SaveTime (' + @ColumnName+') VALUES (1000)'
EXEC(@SQLRUN)
SET @TempINT1 = @Number
SET @Number = @TempINT1 +1
END SET @TempINT1 = @DataInt
SET @DataInt = @DataInt +1
END
GO
DECLARE @DataInt INT
DECLARE @DataText VARCHAR(32)
DECLARE @ColumnName VARCHAR(10)
DECLARE @TempINT1 INT
DECLARE @TempINT2 INT
DECLARE @Number INT
SET @DataInt = 0
WHILE @DataInt < 300
BEGIN
DECLARE @SQLRUN VARCHAR(200)
SET @DataText=CONVERT(VARCHAR(32),@DataInt)
SET @Number = 1
WHILE @Number<1022
BEGIN
SELECT @ColumnName=CONVERT(VARCHAR(10),@Number)
SET @ColumnName = 'YC'+@ColumnName
SET @SQLRUN = 'INSERT INTO dbo.Test_SaveTime (' + @ColumnName+') VALUES (1000)'
EXEC(@SQLRUN)
SET @TempINT1 = @Number
SET @Number = @TempINT1 +1
END SET @TempINT1 = @DataInt
SET @DataInt = @DataInt +1
END
select * from B
没个字段都是INT型的
这是我的一个例子程序,主要想看看运行的时间!!
尤其是在这个例子中的应用?