Inside Microsoft SQL Server 2008 T-SQL Programming: T-SQL Programming
- ISBN-10
- 0735646473
- ISBN-13
- 9780735646476
- Category
- Computers
- Pages
- 832
- Language
- English
- Published
- 2009-09-23
- Publisher
- Microsoft Press
- Authors
- Greg Low, Dejan Sarka, Itzik Ben-Gan
Description
Get a detailed look at the internal architecture of T-SQL with this comprehensive programming reference. Database developers and administrators get best practices, expert techniques, and code samples to master the intricacies of this programming language—solving complex problems with real-world solutions. Discover how to: Work with T-SQL and CLR user-defined functions, stored procedures, and triggers. Handle transactions, concurrency, and error handling. Efficiently use temporary objects, including temporary tables, table variables, and table expressions. Evaluate when to use set-based programming techniques and when to use cursors. Work with dynamic SQL in an efficient and secure manner. Treat date- and time-related data in a robust manner. Develop CLR user-defined types and learn about temporal support in the relational model. Use XML and XQuery and implement a dynamic schema solution. Work with spatial data using the new geometry and geography types and spatial indexes. Track access and changes to data using extended events, SQL Server Audit, change tracking, and change data capture. Use Service Broker for controlled asynchronous processing in database applications. All the book’s code samples will be available for download from the companion Web site.
Get the book
Similar books
-
Inside Microsoft SQL Server 2008: T-SQL Programming
By Itzik Ben-GanGet a detailed look at the internal architecture of T-SQL with this comprehensive programming reference. Database developers and administrators get best practices, expert techniques, and code samples to master the...
-
Microsoft SQL Server 2012 T-SQL Fundamentals
By Itzik Ben-GanGain a solid understanding of T-SQL—and write better queries Master the fundamentals of Transact-SQL—and develop your own code for querying and modifying data in Microsoft SQL Server 2012.
-
Inside Microsoft SQL Server 2008 T-SQL Querying: T-SQL Querying
By Dejan Sarka, Itzik Ben-Gan, Lubor KollarTackle the toughest set-based querying and query tuning problems—guided by an author team with in-depth, inside knowledge of T-SQL.
-
Microsoft SQL Server 2008 T-SQL Fundamentals
By Itzik Ben-GanMaster the foundations of T-SQL with the right balance of conceptual and practical content.
-
Inside Microsoft SQL Server 2008: T-SQL Querying
By Itzik Ben-GanTackle the toughest set-based querying and query tuning problems--guided by an author team with in-depth, inside knowledge of T-SQL. Deepen your understanding of architecture and internals--and gain practical approaches and...
-
T-SQL Querying
By Adam Machanic, Dejan Sarka, Itzik Ben-GanWrite faster, more efficient T-SQL code: Move from procedural programming to the language of sets and logic Master an efficient top-down tuning methodology Assess algorithmic complexity to predict performance Compare data aggregation ...
-
Beginning T-SQL with Microsoft SQL Server 2005 and 2008
By Paul Turley, Dan Wood... varchar(25) NULL ,FirstName varchar(25) NULL ,Position varchar(25)NULL); INSERT SlateGravel VALUES ('Flintstone', ... is stored in a casesensitive collation searching for “flint%” will not return strings beginning with “Flint.
-
Programming Microsoft SQL Server 2008
By Andrew Brust, Leonard G. Lobel, Stephen ForteThis is a must-read for Microsoft .NET and SQL Server developers who work with data access—at the database, business logic, or presentation levels.
-
Professional Microsoft SQL Server 2008 Programming
By Robert VieiraThis book assumes that you have some experience with SQL Server and are at an intermediate to advanced level. The orientation of the book is highly developer focused.
-
Microsoft SQL Server 2008 Step by Step
By Mike HotekTeach yourself SQL Server 2008—one step at a time.