Inserting the Date time into a comment
kjcmcsd
Posts: 2
Hi all!
I am using a kludge to insert a date time into a comment with a SQL Prompt snippet (I know ... who comments?
)
Is there a built-in function to get the date time like $CURSOR$ places the cursor?
My snippet is 'cb'
--YourLoginName mailto: YourLoginName @YourEmailDomain.com
--
--$CURSOR$SELECT CONVERT(VARCHAR, GETDATE())
After you insert the code – highlight the select statement and run it.
The results can be drag dropped from the results pane and up to the blank line after your name
Leaving the commented line in will not hurt the final SP or Query.
Thanks in advance,
Kenn
I am using a kludge to insert a date time into a comment with a SQL Prompt snippet (I know ... who comments?
)Is there a built-in function to get the date time like $CURSOR$ places the cursor?
My snippet is 'cb'
--YourLoginName mailto: YourLoginName @YourEmailDomain.com
--
--$CURSOR$SELECT CONVERT(VARCHAR, GETDATE())
After you insert the code – highlight the select statement and run it.
The results can be drag dropped from the results pane and up to the blank line after your name
Leaving the commented line in will not hurt the final SP or Query.
Thanks in advance,
Kenn
Comments