Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- Id | DateTime | State
- 1 | 2018-07-16 10:00:00 | 0
- 2 | 2018-07-16 10:15:34 | 1
- 3 | 2018-07-16 10:21:12 | 0
- 4 | 2018-07-16 10:32:45 | 1
- 5 | 2018-07-16 10:44:05 | 0
- DateTime | State
- 2018-07-16 10:00:00 | 0
- 2018-07-16 10:15:34 | 1
- 2018-07-16 10:21:11 | 1 <<<
- 2018-07-16 10:21:12 | 0
- 2018-07-16 10:32:45 | 1
- 2018-07-16 10:44:04 | 1 <<<
- 2018-07-16 10:44:05 | 0
- CREATE TABLE [dbo].[SwitchSeries](
- [Id] [int] NOT NULL,
- [DateTime] [datetime2](7) NOT NULL,
- [State] [tinyint] NOT NULL
- )
- INSERT INTO SwitchSeries VALUES
- (1, '2018-07-16 10:00:00', 0),
- (2, '2018-07-16 10:15:34', 1),
- (3, '2018-07-16 10:21:12', 0),
- (4, '2018-07-16 10:32:45', 1),
- (5, '2018-07-16 10:44:05', 0)
Add Comment
Please, Sign In to add comment