Advertisement
Guest User

Untitled

a guest
Jan 19th, 2017
87
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.42 KB | None | 0 0
  1. USE [ConferenceFinal]
  2. GO
  3.  
  4. /****** Object: StoredProcedure [dbo].[updateConferenceDay] Script Date: 19.01.2017 23:56:20 ******/
  5. SET ANSI_NULLS ON
  6. GO
  7.  
  8. SET QUOTED_IDENTIFIER ON
  9. GO
  10.  
  11. CREATE PROC [dbo].[updateConferenceDay]
  12. @id int,
  13. @description varchar(5000) = NULL
  14. AS
  15. SET NOCOUNT ON
  16. SET XACT_ABORT ON
  17.  
  18. BEGIN TRAN
  19.  
  20. UPDATE [dbo].[ConferenceDay]
  21. SET [description] = @description
  22. WHERE [id] = @id
  23.  
  24. COMMIT
  25.  
  26. GO
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement