Competition: What’s your favorite Redgate tool? Enter now.
bug in SQL prompt
Smart Rename not changing join condition
I've recreated a mock below, the column OldField was changed to NewField, but the join condition is not changed causing the script to fail, this code segment resides inside a stored procedure.
...FROM dbo.Table1 t1
SELECT SUM(t2.[Value]) [Sum],
GROUP BY t2.NewField
ON ext1.OldField = t1.NewField
Find Invalid Objects failing to spot some cases
- not spotting incorrect procedure param list when invoked using exec
- not spotting mismatching columns when doing an INSERT INTO EXEC, as in stored procedure with select statement hasving 4 columns while the table the user is trying to insert into has 3 columns (or same number of columns but incompatible types)INSERT INTO table
EXEC dbo.usp_dosomething @param1 = 1,
@param2 = 2,
@etc = 3,
1 · Share on Twitter