Skip to content
← SQL Prompt

How can we improve SQL Prompt?

SQL Prompt: Format SQL

Categories

JUMP TO ANOTHER FORUM

(thinking…)

warn against data truncation

I would be nice if SQL-prompt could warn against posible data truncation.
Like assigning a int value to a tinyint field/variable or assigning a varchar(30) to a varchar(3).
I want it both at an global analysis (like find invalid objects) and in the current scrip edit (while modifying a trigger / procedure / function).

13 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

Benny Bech 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
  • Anonymous commented  ·   ·  Report

    since we have now a warning against UPDATE / DELETE without WHERE it would be the perfect time to add a check against TRUNCATE too