Advertisement
hecrus

Untitled

Feb 14th, 2022
418
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.44 KB | None | 0 0
  1. CREATE OR ALTER PROCEDURE [dbo].[fm_example_checkItem]
  2. @username nvarchar(256),
  3. @itemID int,
  4. @parameters ExtendedDictionaryParameter readonly
  5.  
  6. AS
  7. BEGIN
  8. -- GAG
  9. select 1 Result, '' Msg
  10. return
  11.  
  12. -- check form parameters...
  13. /*
  14. example_data1
  15. */
  16. declare @id int
  17.  
  18. if(@id >0)
  19. begin
  20. select 0 Result, 'Already exists (ID='+cast(@id as nvarchar)+')' Msg
  21. end else
  22. begin
  23. select 1 Result, '' Msg
  24. end
  25. END
  26.  
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement