How can we help you today? How can we help you today?

Auto adding WITH for table hints

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
0

Comments

1 comment

Sort by
  • Manfred.Castro
    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
    0

Add comment

Please sign in to leave a comment.