book that covers sql server dynamic sql

Posted on 2014-01-24
Medium Priority
Last Modified: 2014-01-25
Does anyone know the name of a book with coverage of Sql Server dynamic SQL.

I found a couple articles on the internet but I was wondering if there is a book that goes over it?
Question by:maqskywalker
1 Comment
LVL 17

Accepted Solution

bigeven2002 earned 2000 total points
ID: 39808210

I found a book that contains a chapter covering Dynamic SQL but it is focused on SQL server 2012, but may still apply to 2008.

Link to Book -

Link to article describing the chapter in the book above -

Here is another from Safari books site that covers 2008 T-SQL but has a page on Dynamic SQL here -

Hope this helps.

Featured Post

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

An alternative to the "For XML" way of pivoting and concatenating result sets into strings, and an easy introduction to "common table expressions" (CTEs). Being someone who is always looking for alternatives to "work your data", I came across this …
In this article, we will show how to detach and attach a database and then show how to repair a corrupt database and attach it, If it has some errors. We will show how to detach and attach using SSMS or using T-SQL sentences.
Using examples as well as descriptions, and references to Books Online, show the different Recovery Models available in SQL Server and explain, as well as show how full, differential and transaction log backups are performed
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function

600 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question