SQLServerCentral.com Content tagged T-SQL, Dynamic SQL

Best practice recommendations for writing Dynamic SQL

Thu, 13 Jun 2013 06:00:00 UT

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

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.

Script Table or View structure

Tue, 02 Feb 2010 07:00:00 UT

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

Methods For Converting a Stored Procedure

Fri, 08 Apr 2011 06:00:00 UT

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.