SQLServerCentral.com Articles tagged Dynamic SQL

Basics of XML and SQL Server, Part 3: Transform and Shred XML in SSIS

Wed, 21 Mar 2012 06:00:00 UT

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.

Use Dynamic SQL to Improve Query Performance

Fri, 17 Feb 2012 07:00:00 UT

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

Methods For Converting a Stored Procedure

Fri, 08 Apr 2011 06:00:00 UT

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.

Using Dynamic SQL in Stored Procedures

Tue, 22 Mar 2011 06:00:00 UT

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.

‘Disturbing Development’
Grant Fritchey & the DBA Team present the latest installment of the Top 5 hard-earned lessons of a DBA – read it now

Using Certificates to Sign Stored Procedures

Mon, 21 Jun 2010 06:00:00 UT

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

Use Dynamic SQL to Improve Query Performance

Fri, 17 Feb 2012 07:00:00 UT

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

Methods For Converting a Stored Procedure

Fri, 08 Apr 2011 06:00:00 UT

How To Avoid Msg 106

Tue, 09 Dec 2008 07:00:00 UT

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

Finding Values With Numerous Columns

Tue, 02 Dec 2008 07:00:00 UT

Techniques for finding values in a denormalized table.

Using the CASE expression instead of dynamic SQL

Thu, 20 Mar 2008 06:00:00 UT

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?

The curse and blessings of dynamic SQL

Tue, 18 Mar 2008 06:00:00 UT

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