Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- USE baseSOD
- SET DATEFORMAT ymd
- TRUNCATE TABLE baseSOD.dbo.SendPayment_test
- GO
- SET IDENTITY_INSERT dbo.SendPayment_test ON
- GO
- INSERT INTO dbo.sendPayment_test (table_ID, SystemId, PaymentId, CardNumber, Summ, AgentTime, Status, Accept, ChangeStatusTime)
- VALUES (1, 2, 207, 3001, 470, '2019-06-03 03:45:35.030', 51, CONVERT(BIT, 'False'), '2019-03-14 01:26:05.850')
- GO
- INSERT INTO dbo.sendPayment_test (table_ID, SystemId, PaymentId, CardNumber, Summ, AgentTime, Status, Accept, ChangeStatusTime)
- VALUES (2, 1, 311, 3001, 204, '2019-03-12 11:34:14.140', 51, CONVERT(BIT, 'False'), '2019-03-14 01:26:05.850')
- GO
- INSERT INTO dbo.sendPayment_test (table_ID, SystemId, PaymentId, CardNumber, Summ, AgentTime, Status, Accept, ChangeStatusTime)
- VALUES (4, 1, 168, 3001, 465, '2019-08-03 07:19:33.640', 0, CONVERT(BIT, 'False'), '2019-11-03 04:58:47.823')
- GO
- INSERT INTO dbo.sendPayment_test (table_ID, SystemId, PaymentId, CardNumber, Summ, AgentTime, Status, Accept, ChangeStatusTime)
- VALUES (18, 3, 212, 3001, 204, '2019-03-09 19:11:38.920', 0, CONVERT(BIT, 'False'), '2019-03-13 19:01:49.007')
- GO
- INSERT INTO dbo.sendPayment_test (table_ID, SystemId, PaymentId, CardNumber, Summ, AgentTime, Status, Accept, ChangeStatusTime)
- VALUES (10, 1, 388, 3002, 473, '2019-01-19 13:15:17.660', 61, CONVERT(BIT, 'False'), '2019-01-24 13:37:34.427')
- GO
- INSERT INTO dbo.sendPayment_test (table_ID, SystemId, PaymentId, CardNumber, Summ, AgentTime, Status, Accept, ChangeStatusTime)
- VALUES (21, 3, 556, 3002, 377, '2019-10-02 02:05:50.390', 61, CONVERT(BIT, 'False'), '2019-12-02 09:13:31.353')
- GO
- INSERT INTO dbo.sendPayment_test (table_ID, SystemId, PaymentId, CardNumber, Summ, AgentTime, Status, Accept, ChangeStatusTime)
- VALUES (26, 2, 807, 3002, 201, '2019-12-01 00:18:36.080', 61, CONVERT(BIT, 'False'), '2019-12-01 05:16:28.507')
- GO
- INSERT INTO dbo.sendPayment_test (table_ID, SystemId, PaymentId, CardNumber, Summ, AgentTime, Status, Accept, ChangeStatusTime)
- VALUES (6, 2, 386, 3004, 348, '2019-06-03 13:37:58.150', 51, CONVERT(BIT, 'False'), '2019-02-05 09:53:44.220')
- GO
- INSERT INTO dbo.sendPayment_test (table_ID, SystemId, PaymentId, CardNumber, Summ, AgentTime, Status, Accept, ChangeStatusTime)
- VALUES (7, 2, 887, 3004, 265, '2018-12-26 22:36:10.340', 51, CONVERT(BIT, 'False'), '2018-12-31 18:46:09.977')
- GO
- INSERT INTO dbo.sendPayment_test (table_ID, SystemId, PaymentId, CardNumber, Summ, AgentTime, Status, Accept, ChangeStatusTime)
- VALUES (8, 3, 813, 3004, 317, '2019-09-03 08:42:25.300', 61, CONVERT(BIT, 'False'), '2019-11-03 18:14:47.257')
- GO
- INSERT INTO dbo.sendPayment_test (table_ID, SystemId, PaymentId, CardNumber, Summ, AgentTime, Status, Accept, ChangeStatusTime)
- VALUES (11, 3, 915, 3004, 329, '2019-02-03 02:02:16.740', 61, CONVERT(BIT, 'False'), '2019-08-03 22:02:23.720')
- GO
- INSERT INTO dbo.sendPayment_test (table_ID, SystemId, PaymentId, CardNumber, Summ, AgentTime, Status, Accept, ChangeStatusTime)
- VALUES (12, 1, 618, 3004, 187, '2019-04-02 08:55:46.040', 51, CONVERT(BIT, 'False'), '2019-01-02 22:05:36.927')
- GO
- INSERT INTO dbo.sendPayment_test (table_ID, SystemId, PaymentId, CardNumber, Summ, AgentTime, Status, Accept, ChangeStatusTime)
- VALUES (15, 2, 826, 3004, 121, '2019-09-03 19:56:58.990', 51, CONVERT(BIT, 'False'), '2019-03-20 16:17:11.060')
- GO
- INSERT INTO dbo.sendPayment_test (table_ID, SystemId, PaymentId, CardNumber, Summ, AgentTime, Status, Accept, ChangeStatusTime)
- VALUES (16, 2, 619, 3004, 308, '2019-01-30 13:48:58.660', 51, CONVERT(BIT, 'False'), '2019-02-03 09:15:26.593')
- GO
- INSERT INTO dbo.sendPayment_test (table_ID, SystemId, PaymentId, CardNumber, Summ, AgentTime, Status, Accept, ChangeStatusTime)
- VALUES (17, 3, 892, 3004, 123, '2019-01-12 20:12:48.770', 41, CONVERT(BIT, 'False'), '2019-01-15 06:20:35.220')
- GO
- INSERT INTO dbo.sendPayment_test (table_ID, SystemId, PaymentId, CardNumber, Summ, AgentTime, Status, Accept, ChangeStatusTime)
- VALUES (22, 3, 992, 3004, 355, '2019-01-29 14:58:06.040', 51, CONVERT(BIT, 'False'), '2019-02-02 06:30:55.720')
- GO
- INSERT INTO dbo.sendPayment_test (table_ID, SystemId, PaymentId, CardNumber, Summ, AgentTime, Status, Accept, ChangeStatusTime)
- VALUES (25, 2, 812, 3004, 409, '2019-02-26 18:01:31.500', 41, CONVERT(BIT, 'False'), '2019-03-05 00:00:33.077')
- GO
- INSERT INTO dbo.sendPayment_test (table_ID, SystemId, PaymentId, CardNumber, Summ, AgentTime, Status, Accept, ChangeStatusTime)
- VALUES (27, 1, 758, 3004, 474, '2019-01-13 10:18:33.650', 0, CONVERT(BIT, 'False'), '2019-01-18 12:00:14.343')
- GO
- INSERT INTO dbo.sendPayment_test (table_ID, SystemId, PaymentId, CardNumber, Summ, AgentTime, Status, Accept, ChangeStatusTime)
- VALUES (28, 1, 330, 3004, 316, '2019-03-15 03:30:41.170', 41, CONVERT(BIT, 'False'), '2019-03-20 19:41:01.227')
- GO
- INSERT INTO dbo.sendPayment_test (table_ID, SystemId, PaymentId, CardNumber, Summ, AgentTime, Status, Accept, ChangeStatusTime)
- VALUES (30, 2, 609, 3004, 215, '2019-05-03 21:38:28.540', 61, CONVERT(BIT, 'False'), '2019-06-03 02:00:55.417')
- GO
- INSERT INTO dbo.sendPayment_test (table_ID, SystemId, PaymentId, CardNumber, Summ, AgentTime, Status, Accept, ChangeStatusTime)
- VALUES (3, 1, 836, 3012, 470, '2019-01-19 01:16:53.940', 0, CONVERT(BIT, 'False'), '2019-01-21 17:38:11.327')
- GO
- INSERT INTO dbo.sendPayment_test (table_ID, SystemId, PaymentId, CardNumber, Summ, AgentTime, Status, Accept, ChangeStatusTime)
- VALUES (5, 1, 753, 3012, 401, '2018-12-25 10:51:00.910', 41, CONVERT(BIT, 'False'), '2018-12-29 18:17:32.820')
- GO
- INSERT INTO dbo.sendPayment_test (table_ID, SystemId, PaymentId, CardNumber, Summ, AgentTime, Status, Accept, ChangeStatusTime)
- VALUES (9, 1, 867, 3012, 237, '2019-01-20 00:39:23.060', 51, CONVERT(BIT, 'False'), '2019-01-24 20:33:59.937')
- GO
- INSERT INTO dbo.sendPayment_test (table_ID, SystemId, PaymentId, CardNumber, Summ, AgentTime, Status, Accept, ChangeStatusTime)
- VALUES (13, 3, 195, 3012, 295, '2019-01-18 13:13:33.600', 41, CONVERT(BIT, 'False'), '2019-01-20 18:04:34.650')
- GO
- INSERT INTO dbo.sendPayment_test (table_ID, SystemId, PaymentId, CardNumber, Summ, AgentTime, Status, Accept, ChangeStatusTime)
- VALUES (14, 2, 396, 3012, 361, '2019-03-18 18:44:47.800', 0, CONVERT(BIT, 'False'), '2019-03-22 14:41:05.817')
- GO
- INSERT INTO dbo.sendPayment_test (table_ID, SystemId, PaymentId, CardNumber, Summ, AgentTime, Status, Accept, ChangeStatusTime)
- VALUES (19, 3, 672, 3012, 304, '2019-01-31 11:12:32.580', 41, CONVERT(BIT, 'False'), '2019-02-04 03:06:20.803')
- GO
- INSERT INTO dbo.sendPayment_test (table_ID, SystemId, PaymentId, CardNumber, Summ, AgentTime, Status, Accept, ChangeStatusTime)
- VALUES (20, 3, 911, 3012, 325, '2019-02-08 23:00:56.470', 41, CONVERT(BIT, 'False'), '2019-02-13 06:36:31.717')
- GO
- INSERT INTO dbo.sendPayment_test (table_ID, SystemId, PaymentId, CardNumber, Summ, AgentTime, Status, Accept, ChangeStatusTime)
- VALUES (23, 3, 532, 3012, 163, '2019-03-10 21:52:10.010', 0, CONVERT(BIT, 'False'), '2019-03-14 12:48:37.807')
- GO
- INSERT INTO dbo.sendPayment_test (table_ID, SystemId, PaymentId, CardNumber, Summ, AgentTime, Status, Accept, ChangeStatusTime)
- VALUES (24, 2, 965, 3012, 132, '2019-01-15 00:00:24.220', 61, CONVERT(BIT, 'False'), '2019-01-15 20:53:12.213')
- GO
- INSERT INTO dbo.sendPayment_test (table_ID, SystemId, PaymentId, CardNumber, Summ, AgentTime, Status, Accept, ChangeStatusTime)
- VALUES (29, 3, 117, 3012, 497, '2018-12-30 08:47:45.210', 0, CONVERT(BIT, 'False'), '2019-01-05 10:17:40.027')
- GO
- SET IDENTITY_INSERT dbo.SendPayment_test OFF
- GO
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement