hecrus

CRUD dict

Oct 10th, 2020
622
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. CREATE procedure [dbo].[crud_humans_statusID_dict]
  2.     @tableCode nvarchar(32),
  3.     @col nvarchar(32),
  4.     @username nvarchar(32)
  5. as
  6. begin
  7.     -- источник данных для списка значений (Value, Text)
  8.     select 0 Value, 'Не выбрано' Text
  9.     union  
  10.     select id Value, name Text
  11.     from hr_statuses
  12. end
RAW Paste Data