SQL Server循环插入记录
用变量循环插入记录,开发时需要测试记录,用这个方法很有用,记录下来方便以后备查,大家可以参考修改为其它数据库的SQL.
http://hi.baidu.com/isbx/blog/item/d63237d35dd2ae083bf3cf94.html
+展开
-SQL
DECLARE @recordNmber int
set @recordNmber = 0
--SELECT COUNT(*) FROM tbl_guide_strategy
WHILE (@recordNmber) < $30
BEGIN
set @recordNmber = @recordNmber + 1
INSERT INTO [tbl_guide_strategy] ([name], [guide_type], [guid_model], [strategy_type], [time_scope], [available_time], [sensitive], [start_send_time], [end_send_time], [status], [msisdn], [description], [gen_datetime], [last_modi_datetime])
VALUES (@recordNmber, '0', '这是内容', '1', 7200, 82983, 0, '010000', '100000', '1', '139*', NULL, '20070426 16:51:27.437', NULL)
END
set @recordNmber = 0
--SELECT COUNT(*) FROM tbl_guide_strategy
WHILE (@recordNmber) < $30
BEGIN
set @recordNmber = @recordNmber + 1
INSERT INTO [tbl_guide_strategy] ([name], [guide_type], [guid_model], [strategy_type], [time_scope], [available_time], [sensitive], [start_send_time], [end_send_time], [status], [msisdn], [description], [gen_datetime], [last_modi_datetime])
VALUES (@recordNmber, '0', '这是内容', '1', 7200, 82983, 0, '010000', '100000', '1', '139*', NULL, '20070426 16:51:27.437', NULL)
END
http://hi.baidu.com/isbx/blog/item/d63237d35dd2ae083bf3cf94.html
加支付宝好友偷能量挖...