Note this is not “Best Practices when USING Dynamic SQL”. These are just good habits I’ve come up with over...  Read more...

This script reports table columns that allow NULL values but that currently have no NULL values, making them candidates for adding a NOT NULL constraint.  Read more...

The script finds dependencies of Dynamic SQL based on a table containing T-SQL Queries, DB's and Linked Servers in which it can be executed.  Read more...

This SSIS package performs multiple XSL transformations on an XML document, then shreds the transformed document and inserts its data into a SQL Server table.  Read more...

This article by Jonathan Roberts demonstrates how to use dynamic SQL and overcome its downsides.  Read more...

An interesting use of T-SQL to run a stored procedure as part of a SELECT statement to get a result set to be used and combined with other tables. From Eli Leiba, learn how you can build a stored procedure into your queries.  Read more...

Dynamic SQL allows stored procedures to “write” or dynamically generate their SQL statements. The most common use case for dynamic SQL is stored procedures with optional parameters in the WHERE clause. These are typically called from reports or screens that have multiple, optional search criteria. This article describes how to write these types of stored procedures so they execute well and resist SQL injection attacks.   Read more...

How to sign stored procedures with certificates, this is useful if the procedures use dynamic SQL.  Read more...

This article by Jonathan Roberts demonstrates how to use dynamic SQL and overcome its downsides.  Read more...

This code will let you script a Table or Views structure for source control.   Read more...

An interesting use of T-SQL to run a stored procedure as part of a SELECT statement to get a result set to be used and combined with other tables. From Eli Leiba, learn how you can build a stored procedure into your queries.  Read more...

This Script has been build to list all the tables in a database without using a cursor.   Read more...

i have recently had the need to search the every database on the server for a particular string. i came up with this... it has lots of room for improvement but it works  Read more...

When you have too many tables in a view, what can you do? New author Henrik Staun Poulsen brings us a solution that we   Read more...

Techniques for finding values in a denormalized table.  Read more...

This is related to my other autogenerate code. this is just an example of how to use it.   Read more...

This script was designed to 'pivot' data that couldnt easily be pivoted in any other way. i used temporary tables to eventually achieve the result i was looking for :)  Read more...

I have a lot of SQL update queries where I need to make IF/ELSE types of decisions. I am using a cursor in some cases but looping through thousands of rows for update takes a long time. I also use some dynamic SQL to handle some query parameter decision making. Is there a better alternative?  Read more...

How you use dynamic SQL, when you should - and when you should not.   Read more...