Skip to content
← SQL Prompt

How can we improve SQL Prompt?

SQL Prompt: Code Analysis

Categories

JUMP TO ANOTHER FORUM

(thinking…)

Highlight Implicit Conversions due to Data Type mismatch

After spending some time refreshing my memory on implicit conversions, and the potentially disasterous affects on performance, the thought hit me...

Wouldn't it be great if SQL Prompt could hightlight potential implicit conversions when I write JOINS or WHERE statements?

I'm not sure how easy this would be to implement but I know everyone at Red Gate is very intelligent and highly creative so you'll find a way. :-)

72 votes

We're glad you're here

Please sign in to leave feedback
Signed in as (Sign out)
Close
Close

We’ll send you updates on this idea

Jason Coombes shared this idea  ·   ·  Report…  ·  Admin →
How important is this to you?

We're glad you're here

Please sign in to leave feedback
Signed in as (Sign out)
Close
Close

We're glad you're here

Please sign in to leave feedback
Signed in as (Sign out)
Close
Close
Submitting...
An error occurred while saving the comment
  • Oliveri Florian commented  ·   ·  Report

    9 years later, this feature is not implemented... It will avoid performance issues and bad database design...

  • Karthik commented  ·   ·  Report

    This will be a great feature if RedGate can incorporate it...

  • Darek commented  ·   ·  Report

    Great suggestion! All for it!

  • Anonymous commented  ·   ·  Report

    Yes this would be very helpful. Just diagnosed a performance issues because of this and wondered, why doesn't SQL Prompt warn about this! I looked into it didn't find the feature but found this.