Blogs from Wise Owl on Dynamic SQL in SQL

Showing blogs 1-3 (out of 3)

Pivoting Data in SQL Server

Posted by Andrew Gould on 09 June 2014

Using the Pivot operator in SQL Server allows you to create basic pivot tables from your query results. This blog teaches you how to create simple, static pivots, crosstab-style tables and exciting, dynamic pivot tables.

Tags:   SQL | Dynamic SQL    |    SQL | CTEs, subqueries    |    T-SQL | Other

Dynamic SQL

Posted by Andrew Gould on 22 April 2013

Dynamic SQL is a technique for building valid SQL statements from separate pieces of text. You can use this technique to create remarkably flexible and useful queries, as long as you're aware of the potential danger of SQL injection attacks.

Tags:   SQL | Dynamic SQL    |    T-SQL | SQL Tutorial

Dynamic SQL - No, No, No!

Posted by David Wakefield on 02 July 2012

Dynamic SQL should only be used as a last resort. This article gives you a tip for avoiding the use of dynamic SQL in WHERE clauses

Tags:   SQL | Selecting data    |    SQL | WHERE criteria    |    SQL | Dynamic SQL    |    T-SQL | Other
This page has 0 threads Add post