WorkAkkaunt

Добавления в таблицу

Jun 26th, 2019
153
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
T-SQL 0.62 KB | None | 0 0
  1. DECLARE @OPERATOR uniqueidentifier
  2. DECLARE @TIME_START datetime
  3. DECLARE @TIME_FINISH datetime
  4. DECLARE @STATE int
  5.  
  6. SET @TIME_START = '2018-04-06 11:01:00.000'
  7. SET @TIME_FINISH = '2018-04-06 11:31:00.000'
  8. SET @OPERATOR = '5EC13849-09B6-41DB-B0DA-9E36ACE5E461'
  9. SET @STATE = 8
  10.  
  11. INSERT INTO [oktell_cc_temp].[dbo].[Operator_States_Test]
  12.     (IdOperator, [State], DateTimeStart, DateStart, TimeStart, DateTimeStop, LenTime)
  13. VALUES(
  14.     @OPERATOR
  15.     ,@STATE
  16.     ,@TIME_START
  17.     ,CAST(CAST(@TIME_START AS date) AS datetime)
  18.     ,CAST(CAST(@TIME_START AS time) AS datetime)
  19.     ,@TIME_FINISH
  20.     ,DATEDIFF(second, @TIME_START, @TIME_FINISH)
  21. )
Advertisement
Add Comment
Please, Sign In to add comment