Auto adding WITH for table hints

Provides intelligent code completion for SQL Server editors.

Moderators: JonathanWatts, David Atkinson, Anu Deshpande, Paul Stephenson, Michelle Taylor, Mike Upton, justin.caldicott, Aaron Law

Auto adding WITH for table hints

Postby marclallen » Tue Jul 23, 2013 9:08 pm

I've been looking for a solution to help me migrate from an SQL 2000 database to something to run in SQL 2012. One of the key pain points is that the WITH keyword on table hints is now required.

I was hoping that SQL Prompt, during reformatting, would be able to detect and add that in.

However, I didn't see any way to do that.

Can it do this? Or do you have another suggestion as to how to accomplish that?

Thanks,

Marc
marclallen
 
Posts: 41
Joined: Mon Jun 11, 2007 3:13 pm

Postby Manfred.Castro » Wed Jul 24, 2013 10:42 pm

Unfortunately the tool does not currently have this capability and I do not have any suggestions on how to best accomplish this.
If you wish you can request this feature for this tool.
You can direct feature requests to our uservoice forums.
http://redgate.uservoice.com/forums/944 ... uggestions
These forums are actively monitored by our development team and allow our users to reuest features and vote on them.
If a feature receives a significant amount of votes or is deemed to have merit development may include the feature in a future release.
Manfred Castro
Product Support
Red Gate Software
Manfred.Castro
 
Posts: 209
Joined: Mon Apr 23, 2012 2:49 pm


Return to SQL Prompt 5

Who is online

Users browsing this forum: No registered users and 1 guest