用变量循环插入记录,开发时需要测试记录,用这个方法很有用,记录下来方便以后备查,大家可以参考修改为其它数据库的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