Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CREATE PROCEDURE [dbo].[crud_kanbanOrders_updateField]
- @itemID int,
- @field nvarchar(64),
- @value nvarchar(max),
- @username nvarchar(64)
- AS
- BEGIN
- if(@field = 'statusID') begin
- update tst_orders
- set statusID = cast(@value as int)
- where id = @itemID
- end else begin
- select 'Невалидный код свойства' Msg, 0 Result
- return
- end
- select '' Msg, 1 Result
- END
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement