DECLARE @id INT,@i INT
SET @id=0
SET @i=1
WHILE @i<11 --10000为你要执行插入的次数
BEGIN
--------------------------------------------------------------------------
--INSERT 语句
INSERT INTO tt ( id, name) --xx为表名
VALUES ( 'GY3201603170001__gyxxfzr__001__13__'+CAST(@i as VARCHAR), '123' )
------------------------------------------------------------------------------
SET @i=@i+1
END
SET @id=0
SET @i=1
WHILE @i<11 --10000为你要执行插入的次数
BEGIN
--------------------------------------------------------------------------
--INSERT 语句
INSERT INTO tt ( id, name) --xx为表名
VALUES ( 'GY3201603170001__gyxxfzr__001__13__'+CAST(@i as VARCHAR), '123' )
------------------------------------------------------------------------------
SET @i=@i+1
END