MS-SQL_gen_data

MS-SQL_gen_data_example.sql

USE exchangedb;
IF NOT EXISTS (select * from sysobjects where name='esb_out_a_report')
  CREATE TABLE dbo.esb_out_a_report
(
  MESSAGE_ID            int,
  OPERATION_CODE        int,
  MESSAGE_DT            datetime,
  ENTITY_ID             varchar(750),
  RECEIVER_ID           int,
  MAINTENANCE_FLG       tinyint,
  BUSINESS_DATA_INT     int,
  BUSINESS_DATA_VARCHAR varchar(750),
  BUSINESS_DATA_DATE    datetime
)
GO

INSERT INTO dbo.esb_out_a_report(message_id,
                                 operation_code,
                                 message_dt,
                                 entity_id,
                                 receiver_id,
                                 maintenance_flg,
                                 business_data_int,
                                 business_data_varchar,
                                 business_data_date)
VALUES (1, 584, CURRENT_TIMESTAMP, 'id #1', null, 1, 2147483647, 'ac5adfda289bb8f03e0764f3435c2814', GETDATE()),
       (2, 295, GETDATE(), 'id #2', null, 2, 2147483647, 'ac5adfda289bb8f03e0764f3435c2814', GETDATE()),
       (3, 491, GETDATE(), 'id #3', null, 3, 2147483647, 'ac5adfda289bb8f03e0764f3435c2814', GETDATE()),
       (4, 514, GETDATE(), 'id #4', null, 4, 2147483647, 'ac5adfda289bb8f03e0764f3435c2814', GETDATE()),
       (5, 247, GETDATE(), 'id #5', null, 5, 2147483647, 'ac5adfda289bb8f03e0764f3435c2814', GETDATE()),
       (6, 43, GETDATE(), 'id #6', null, 6, 2147483647, 'ac5adfda289bb8f03e0764f3435c2814', GETDATE()),
       (7, 136, GETDATE(), 'id #7', null, 7, 2147483647, 'ac5adfda289bb8f03e0764f3435c2814', GETDATE()),
       (8, 546, GETDATE(), 'id #8', null, 8, 2147483647, 'ac5adfda289bb8f03e0764f3435c2814', GETDATE()),
       (9, 429, GETDATE(), 'id #9', null, 9, 2147483647, 'ac5adfda289bb8f03e0764f3435c2814', GETDATE()),
       (10, 120, GETDATE(), 'id #10', null, 10, 2147483647, 'ac5adfda289bb8f03e0764f3435c2814', GETDATE())