#表名:tablename
#字段:account_id ,question ,answer ,lang
#start
CREATE PROCEDURE add_tablename_7
ASDECLARE @account_id INTEGER
DECLARE @question VARCHAR
DECLARE @answer VARCHAR
DECLARE @lang INTEGER
DECLARE @index INTEGER
DECLARE @count INTEGER
SET @account_id= 3913827
SET @question='question'
SET @answer='answer'
SET @lang=1
SET @count=1001
SET @index=1
WHILE @index<@count
BEGIN
INSERT INTO tablename(account_id,question,answer,lang)
VALUES (@account_id,@question,@answer,@lang)
SET @index=@index+1
END
GO
#exec
exec add_tablename_7
INTEGER 不支持java long型,会溢出