Auto adding WITH for table hints
marclallen
Posts: 53 Bronze 3
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
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
Comments
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.
Product Support
Red Gate Software