Advertisement
hecrus

Human Form DepID dict

Oct 10th, 2020
1,512
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
T-SQL 0.53 KB | None | 0 0
  1. CREATE PROCEDURE [dbo].[fm_human_depID_dict]
  2.    @username nvarchar(256),
  3.    @itemID nvarchar(128)
  4.    -- @fields DictionaryParameter READONLY --- если нужно сделать зависимые столбцы (в коллекции передаются состояние всех столбцов)
  5.    -- @q nvarchar(256) ='' -- для select-search запросов.
  6. AS
  7. BEGIN  
  8.     select ' Не выбрано ' Text, 0 Value, 0 Selected
  9.     union
  10.     select name  Text, id Value, 0 Selected from hr_departments
  11.     order by Text  
  12. END
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement