hecrus

MySQL DeleteItem

Oct 18th, 2020
501
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. CREATE PROCEDURE [dbo].[crud_tst-mysql_deleteItem]
  2.     @itemID int,
  3.     @username nvarchar(32)
  4. AS
  5. begin
  6.     -- удаление строки таблицы
  7.     SET NOCOUNT off ;  
  8.     exec('delete from remotelyCreatedTable where id='+ @itemID) at mysql1  
  9.    
  10.     select '' Msg, 1 Result
  11. end
RAW Paste Data