Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- ALTER PROCEDURE [dbo].[my_sp]
- @currentDate datetime = GETDATE()
- ALTER Procedure [dbo].[my_sp]
- @currentDate datetime = null
- AS
- IF @currentDate is null
- SET @currentDate = getdate()
- Set @currentDate = Coalesce(@currentDate , GetDate())
Add Comment
Please, Sign In to add comment