Advertisement
Ruslan_Rayanov

Calendar DeleteItem

Oct 18th, 2020
242
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
T-SQL 0.39 KB | None | 0 0
  1. CREATE PROCEDURE [dbo].[crud_tst-calendar_deleteItem]
  2.     @itemID int,
  3.     @username nvarchar(32)
  4. AS
  5. begin
  6.     SET NOCOUNT off ;  
  7.     -- удаление элемента
  8.     delete from as_events where id = @itemID and username=@username
  9.    
  10.     if (@@ROWCOUNT > 0) begin
  11.         select '' Msg, 1 Result
  12.     end else begin
  13.         select 'Не получилось удалить событие' Msg, 0 Result
  14.     end
  15. end
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement