code_junkie

SQL function as default parameter value

Nov 13th, 2011
164
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.24 KB | None | 0 0
  1. ALTER PROCEDURE [dbo].[my_sp]
  2. @currentDate datetime = GETDATE()
  3.  
  4. ALTER Procedure [dbo].[my_sp]
  5. @currentDate datetime = null
  6. AS
  7. IF @currentDate is null
  8. SET @currentDate = getdate()
  9.  
  10. Set @currentDate = Coalesce(@currentDate , GetDate())
Add Comment
Please, Sign In to add comment