Learn IT - Books tags transact

SQL Server 2005 T-SQL Recipes: A Problem-Solution Approach

Apress, 2005

When it comes to performing your daily SQL Server tasks, technical documentation tends to
tell you more than you need to know.

Let’s say that you’re in a hurry, and you want to add a unique constraint to a table before
someone inserts a duplicate value into it. Where do you look?

One obvious choice is SQL...

Beginning SQL Server 2008 for Developers: From Novice to Professional

Apress, 2008

SQL Server 2008 is a first–rate database management system. It offers more capability than any previous release of SQL Server. More than just a classic relational database management system, SQL Server 2008 includes exciting and powerful features that make it useful for everything from large corporate data warehouses to ad hoc departmental...

SQL Server 2008 Query Performance Tuning Distilled (Expert's Voice in SQL Server)

Apress, 2009

SQL Server 2008 Query Performance Tuning Distilled presents a direct trouble–shooting methodology for identifying poorly performing stored procedures and queries, isolating the causes of that poor performance, and fixing the underlying problems. Each chapter is dedicated to one of the top causes of poorly performing queries and shows...

Advanced Transact-SQL for SQL Server 2000

Apress, 2000

This book is aimed at Information Technology professionals who are working with Microsoft SQL Server or
who intend to use it as a development platform. Many books are written on the broad aspects of SQL Server
or just on its administration. This book focuses on programming, with particular emphasis on the features of
SQL Server 2000....

Microsoft SQL Server 2005 Stored Procedure Programming in T-SQL & .NET

McGraw-Hill, 2006

Create and Use Stored Procedures for Optimal Database Performance

Develop complex stored procedures to retrieve, manipulate, update, and delete data. Microsoft SQL Server 2005 Stored Procedure Programming in T-SQL & .NET identifies and describes the key concepts, techniques, and best practices you need to master in...

Transact-SQL Programming: Covers Microsoft SQL Server 6.5 /7.0 and Sybase Adaptive Server 11.5

O'Reilly, 1999

Transact-SQL is a procedural language used on both Microsoft SQL Server and Sybase SQL Server systems. It is a full-featured programming language that dramatically extends the power of SQL (Structured Query Language).The language provides programmers with a broad range of features, including:

A rich set of...

Beginning SQL Server 2005 Administration

Wrox Press, 2006

For the first time, SQL Server 2005 provides features that can support large-scale enterprise databases. With this powerful new release, you may find yourself being called upon to perform duties that are no longer strictly "administrative," duties that have become much more complicated and difficult. With that in mind, a team of...

Beginning T-SQL with Microsoft SQL Server 2005 and 2008 (Wrox Programmer to Programmer)

Wrox Press, 2008

Welcome to the world of Transact - Structured Query Language programming with SQL Server 2005 and 2008. Transact - SQL, or T - SQL, is Microsoft Corporation ’ s powerful implementation of the ANSI standard SQL database query language, which was designed to retrieve, manipulate, and add data to relational database management systems...

What's New in SQL Server 2012

Packt Publishing, 2012

Unleash the new features of SQL Server 2012

Overview

Upgrade your skills to the latest version of SQL Server

Discover the new dimensional model in Analysis Services

Utilize data alerts and render reports to the latest versions of Excel and Word

MCAD/MCSE/MCDBA Self-Paced Training Kit: Microsoft SQL Server 2000 Database Design and Implementation, Second Edition (Exam 70-229)

Microsoft Press, 2003

Learn how to deliver powerful database solutions using SQL Server 2000 Enterprise Edition—and prepare for the Microsoft Certified Professional (MCP) exam—with this official Microsoft study guide. Work at your own pace through the lessons and hands-on exercises. And use the special exam-prep section and testing tool to measure what...

Writing Stored Procedures with Microsoft SQL Server: The Authoritative Solution

Sams Publishing, 2000

This book was written so that you can learn how to create stored procedures. I'm
sure that you have created a few stored procedures already. The first stored
procedures I created were simple queries that I encapsulated so that I didn't have to
reload or retype them every time I wanted to run them. After a while, I learned how...

Microsoft Access Projects with Microsoft SQL Server

Microsoft Press, 2002

The definitive guide to building enterprise solutions with Access Projects and SQL Server

Professional developers who use Microsoft® Access, the popular desktop database program, often confront limits to working with large amounts of data. This hands-on guide demonstrates in detail how to build...

Result Page: 5 4 3 2 1