Transact-SQL - Softcover

Amo, William C.

 
9780764580482: Transact-SQL

Synopsis

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.

"synopsis" may belong to another edition of this title.

About the Author

About the Author William C. Amo has been developing databases and database systems for over 20 years. He specializes in client/server system and component development using Windows NT servers hosting Microsoft SQL servers. He is a coauthor of IDG Books Worldwide's Access 97 Secrets??.

From the Back Cover

Transact-SQL Unleash the Capabilities of SQL Server 7 with Transact -SQL 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. Working Solutions for Everyday Programming Challenges

  • Master the Transact-SQL for SQL Server 7.0 query language — from commands and syntax to new features for enterprise development
  • Write custom SQL Server 7.0 stored procedures and triggers
  • Find out how to program with the ODBC 3.5 API and DB-Library
  • Learn how to use ActiveX Data Objects to access SQL Server
  • Import and export data sources using the new Data Transformation Services
  • Access remote data sources from within stored procedures using distributed queries
Transact-SQL language references included! Complete sample database on CD-ROM! www.idgbooks.com

"About this title" may belong to another edition of this title.