Ruslan_Rayanov

Widget GetItem

Oct 18th, 2020
492
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
T-SQL 0.44 KB | None | 0 0
  1. CREATE PROCEDURE [dbo].[fm_tst-statistic_getItem]
  2.     @itemID int,   
  3.     @username nvarchar(256),
  4.     @parameters ExtendedDictionaryParameter readonly
  5.  
  6. AS
  7. BEGIN
  8.     declare @langID int
  9.     select @langID = try_cast(Value as int) from @parameters where [Key] = 'langID'
  10.  
  11.    
  12.    
  13.     select 1 period, 1 edt_period
  14.    
  15.    
  16.     select 'period' changeTriggerFieldOnLoad,  iif(@langID=1, 'Work stat', 'Статистика работы') Title
  17.    
  18.    
  19. END
  20.  
Add Comment
Please, Sign In to add comment