Posts
Sort by recent activity
How to create a snippet that uses table metadata?
I would like to write the following sql via a snippet: SELECT TOP 10 * FROM dbo.Documents d ORDER BY 1 DESC So to do this, I have a snippet: SELECT TOP 10 * FROM $CURSOR$ ORDER BY 1 DESCHowever, I ...
How to get SQL Prompt to add (NOLOCK) when inserting a join?
Consider the following snippet:When I select CustomerPerson from the dropdown, is there a way to get SQL Prompt to add it with (NOLOCK) statement? I've looked through options and haven't found any...
Ants Performance Profiler 10 says Trial Expired.
I downloaded Ants Performance Profiler 10 to try it out. However, it gives me this error.