BY TOPIC
SQL SERVER BLOGS
SQL BLOGS
- General (9)
- Tables and columns (11)
- Selecting data (6)
- WHERE criteria (5)
- Calculations (7)
- Joins (3)
- Grouping (2)
- Views (2)
- Stored procedures (5)
- SQL programming (5)
- Programming tables (3)
- CTEs, subqueries (6)
- Errors, debugging (2)
- Functions (3)
- Dynamic SQL (3)
- Transactions (3)
- Cursors (1)
- Triggers (1)
BLOGS BY AUTHOR
BLOGS BY YEAR
Blogs from Wise Owl on Dynamic SQL in SQL
Showing blogs 1-3 (out of 3)
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.
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.
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