|
|
|
|
Title: SQL
Published by : Pentasoft
Price : $4
Book Description
Useful for any developer who works with Microsoft SQL Server databases,Our SQL delivers
the goods on several key technologies, as well as a thorough introduction to working
with SQL Server and its related tools. It's an essential resource for anyone who
wants to take advantage of the performance and reusability of server-side stored
procedures on the Microsoft platform..
This book covers a number of absolutely essential APIs that will be needed by any
programmer who works with Microsoft databases. First, the author presents a good
introduction to ActiveX Data Objects (ADO), the recommended standard for programming
with databases.The text's principle strength has to be its comprehensive tour of Microsoft Transact-SQL
(T-SQL), starting with simple SELECT and action queries, to different types of joins
between relational tables.
What's best here is the author's step-by-step tutorial
for each SQL statement, along with an example written using client-side SQL (where
the SQL is written in ADO on the client), as well as the same code executed as a
stored procedure on the server. (Here ADO is used to invoke server-side T-SQL.)
This approach not only provides an excellent introduction to SQL itself, it also
furnishes what you need to use stored procedures effectively. Server-side database
programming used to be the stuff of experts only, but this book shows how anyone
can do it using today's Visual Basic.
Back
|
|
|
|