What are the challenges you face when working across database platforms? Take the survey
Options

Inserting the Date time into a comment

kjcmcsdkjcmcsd Posts: 2
edited January 8, 2008 10:33AM in SQL Prompt Previous Versions
Hi all!

I am using a kludge to insert a date time into a comment with a SQL Prompt snippet (I know ... who comments? :wink: )

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

Sign In or Register to comment.