SoftTree Technologies SoftTree Technologies
Technical Support Forums
RegisterSearchFAQMemberlistUsergroupsLog in
Code Snippet - NOLOCK

 
Reply to topic    SoftTree Technologies Forum Index » SQL Assistant View previous topic
View next topic
Code Snippet - NOLOCK
Author Message
dankob



Joined: 07 Apr 2009
Posts: 1
Country: United States

Post Code Snippet - NOLOCK Reply with quote
I would like the Code Snippet or Code Formatting to add "(NOLOCK)" after the alias is provided like below:

SELECT *
FROM FOO fo (NOLOCK)

Any help would be greatly appreciated.
Tue Apr 07, 2009 7:39 am View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 7849

Post Reply with quote
Code snippets cannot add variable aliases. Other than that you can have a snippet like the following

Code:
SELECT *
FROM $OBJECT$ a (NOLOCK)


or what is likely more practical

Code:
SELECT *
FROM $OBJECT$ a (NOLOCK)
WHERE

Tue Apr 07, 2009 8:27 am View user's profile Send private message
Display posts from previous:    
Reply to topic    SoftTree Technologies Forum Index » SQL Assistant All times are GMT - 4 Hours
Page 1 of 1

 
Jump to: 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


 

 

Powered by phpBB © 2001, 2005 phpBB Group
Design by Freestyle XL / Flowers Online.