 |
SoftTree Technologies
Technical Support Forums
|
|
Author |
Message |
dankob
Joined: 07 Apr 2009 Posts: 1 Country: United States |
|
Code Snippet - NOLOCK |
|
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 |
|
 |
SysOp
Site Admin
Joined: 26 Nov 2006 Posts: 7948
|
|
|
|
Code snippets cannot add variable aliases. Other than that you can have a snippet like the following
 |
 |
SELECT *
FROM $OBJECT$ a (NOLOCK) |
or what is likely more practical
 |
 |
SELECT *
FROM $OBJECT$ a (NOLOCK)
WHERE |
|
|
Tue Apr 07, 2009 8:27 am |
|
 |
|
|
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
|
|
|