Write safe dynamic SQL with typed value parameters, validated object names, and allowed sort columns, then test hostile input.
SQL SERVER – Significance of Table Input Parameter to Stored Procedure
Pass a whole table into a stored procedure instead of forming and parsing XML. Here is why a table input parameter to stored procedure saves round trips.
Cursor Options That Matter: LOCAL, FAST_FORWARD and STATIC
Test SQL Server cursor options, including LOCAL FAST_FORWARD and STATIC, on one loop while measuring time and tempdb cost.
Renaming a Column Safely Everywhere It Is Used
Renaming a column safely requires finding SQL and application references, applying sp_rename, refreshing modules, and testing every consumer.
SQL SERVER – Replace a Column Name in Multiple Stored Procedure All Together
A beginner on a development server asked how to replace a column name in Multiple Stored Procedure code all together. Here is the quick way I suggest.
SQL SERVER – Find Column Used in Stored Procedure – Search Stored Procedure for Column Name – Part 2
Readers improved my script to find column used in stored procedure. Imran Mohammed shares newer scripts to search stored procedure for column name.
SQL SERVER – Find Column Used in Stored Procedure – Search Stored Procedure for Column Name
Want to drop a column? First find column used in stored procedure code. I share the T-SQL script that searches every stored procedure for a column name.