Solved

book that covers sql server dynamic sql

Posted on 2014-01-24
1
292 Views
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?
0
Comment
Question by:maqskywalker
1 Comment
 
LVL 17

Accepted Solution

by:
bigeven2002 earned 500 total points
ID: 39808210
Hello,

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 -
http://www.amazon.com/gp/product/1939666007/ref=as_li_qf_sp_asin_il_tl?ie=UTF8&camp=1789&creative=9325&creativeASIN=1939666007&linkCode=as2&tag=pinalspersona-20

Link to article describing the chapter in the book above -
http://blog.sqlauthority.com/2013/03/28/sql-server-executing-dynamic-sql-sql-queries-2012-joes-2-pros-volume-4-query-programming-objects-for-sql-server-2012/

Here is another from Safari books site that covers 2008 T-SQL but has a page on Dynamic SQL here -
http://my.safaribooksonline.com/book/databases/microsoft-sql-server/9780735626010/programmable-objects/dynamic_sql

Hope this helps.
0

Featured Post

Find Ransomware Secrets With All-Source Analysis

Ransomware has become a major concern for organizations; its prevalence has grown due to past successes achieved by threat actors. While each ransomware variant is different, we’ve seen some common tactics and trends used among the authors of the malware.

Join & Write a Comment

Introduction SQL Server Integration Services can read XML files, that’s known by every BI developer.  (If you didn’t, don’t worry, I’m aiming this article at newcomers as well.) But how far can you go?  When does the XML Source component become …
In this article I will describe the Backup & Restore method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.
Via a live example, show how to shrink a transaction log file down to a reasonable size.

707 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

Need Help in Real-Time?

Connect with top rated Experts

14 Experts available now in Live!

Get 1:1 Help Now