Advertisement
Guest User

Untitled

a guest
Mar 5th, 2015
185
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.62 KB | None | 0 0
  1. CREATE PROCEDURE sp_test
  2. @a varchar(4) = NULL,
  3. @b varchar(4) = NULL
  4. AS
  5. UPDATE testtable
  6. SET a = CASE @a
  7. WHEN NULL THEN var1
  8. WHEN 'NULL' THEN NULL
  9. ELSE @a
  10. END,
  11. SET b = CASE @b
  12. WHEN NULL THEN b
  13. WHEN 'NULL' THEN NULL
  14. ELSE @b
  15. END
  16. GO
  17.  
  18. CREATE PROCEDURE sp_test
  19. @a varchar(4) = NULL,
  20. @b varchar(4) = NULL
  21. AS
  22. UPDATE testtable
  23. SET a = CASE
  24. WHEN @a IS NULL THEN var1
  25. WHEN @a = 'NULL' THEN NULL
  26. ELSE @a
  27. END,
  28. SET b = CASE
  29. WHEN @b IS NULL THEN b
  30. WHEN @b = 'NULL' THEN NULL
  31. ELSE @b
  32. END
  33. GO
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement