Refactors and formats SQL code.
Moderators: Chris Auckland, David Atkinson, Anu Deshpande, Luke Jefferson
I would like to be able to refactor with locking hints...
UPDATE mytable WITH (ROWLOCK)
SELECT ID FROM mytable WITH (NOLOCK)
This would be a good extra refactoring and take the count up from only 11 refactors
I'm aware that some folk don't agree that locking hints are needed, but I'm using this tool in a work envirionment and the use of hints is mandated.
Also converting x.id = y.id to inner join syntax as a refactor
- Posts: 5
- Joined: Wed Apr 07, 2010 12:14 am
Thanks for your forum post. I have logged an enhancement request (SSR-881) for locking hints.
- Posts: 6670
- Joined: Mon Aug 23, 2004 10:48 am
Return to SQL Refactor 1
Who is online
Users browsing this forum: No registered users and 0 guests