[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

book that covers sql server dynamic sql

Posted on 2014-01-24
1
Medium Priority
?
323 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 2000 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

Configuration Guide and Best Practices

Read the guide to learn how to orchestrate Data ONTAP, create application-consistent backups and enable fast recovery from NetApp storage snapshots. Version 9.5 also contains performance and scalability enhancements to meet the needs of the largest enterprise environments.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Ever wondered why sometimes your SQL Server is slow or unresponsive with connections spiking up but by the time you go in, all is well? The following article will show you how to install and configure a SQL job that will send you email alerts includ…
One of the most important things in an application is the query performance. This article intends to give you good tips to improve the performance of your queries.
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.
Viewers will learn how to use the INSERT statement to insert data into their tables. It will also introduce the NULL statement, to show them what happens when no value is giving for any given column.
Suggested Courses

831 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