Transact-SQL

Abstract: From the Publisher: - Expert tips and real code examples teach advanced database programmers to write more efficient and better-performing code that takes full advantage of Transact SQL - Provides hundreds of solutions to common problems encountered by SQL Server programmers - Both authors write regularly for SQL Server Magazine and Pinnacle Publishing 's Microsoft SQL Server Professional newsletter In Advanced Transact-SQL for SQL Server 2000, Itzik Ben-Gan and Thomas Moreau explore the powerful capabilities of Transact-SQL. Ben-Gan and Moreau offer solutions to common problems encountered using all versions of SQL Server with a focus on the latest version, SQL Server 2000. The authors offer practical solutions to the everyday problems programmers face and provide significant content on the advanced areas in T-SQL such as joins, subqueries, stored procedures, triggers, user-defined functions (UDFs), indexed views, cascading actions, federated views, hierarchical structures, cursors and more. Author Biography: Itzik Ben-Gan is a senior SQL Server instructor and consultant with ten years of experience in networking, development, databases and data warehousing. He is a popular columnist and contributing editor for SQL Server Magazine, and is a Microsoft SQL Server MVP. Dr. Tom Moreau is President of Brockman Moreau Consulting, Inc. He has been programming since 1971 and has over sixteen years of professional experience in Information Technology. Moreau has been using SQL Server since 1993. He writes regularly for Pinnacle's Microsoft SQL Server Professional newsletter.

Abstract: From the Publisher: Take complete command of Microsoft SQL Server 7 with the latest version of Transact-SQL query language - from constructing powerful Transact-SQL queries to interacting with SQL tables and records through the DB-Library, the ODBC API, and the new COM-based ActiveX Data Objects (ADO). Learn to use Open Data Services (ODS) to write extended stored procedures. Loaded with sample queries, scripts, extended stored procedures, and triggers you can use right away, Transact-SQL demonstrates all the SQL tools and techniques you need to build SQL, Server enterprise database applications.

Abstract: We consider the Cartesian decomposition of relational data sets, i.e. the problem of finding two or several data sets such that their unordered Cartesian product equals the source set. In terms of relational databases, this means reversing the SQL CROSS JOIN operator. We describe a polytime algorithm for computing a Cartesian decomposition based on factorization of boolean polynomials. We provide an implementation of the algorithm in Transact SQL and discuss some generalizations of the Cartesian decomposition.

Abstract: SQL Server 2008 TransactSQL Recipes: A ProblemSolution Approach is an examplebased guide to the TransactSQL language that is at the core of SQL Server 2008. Learn to create databases, insert and update data, generate reports, secure your data, and more. Author Joseph Sack takes common TransactSQL tasks and breaks them down into a problem/solution format that is quick and easy to read so that you can get the job done fast when the pressure is on. Focused on solutions: Look up what you need to do. Learn how to do it. Do it. Current: Newly updated for SQL Server 2008. Comprehensive: Covers 30 different TransactSQL problem domains. What youll learn Create databases, tables, and indexes. Query and manipulate data. Store and manage XML inside the database. Move business logic into the database. Encrypt data and capture changes for compliance purposes. Implement FullText Search. Interface with Service Broker. And more! Who is this book for? Developers who use Microsoft SQL Server 2008 as their backend database. Database administrators who create, manage, and secure those databases.