| |
|
SQL Server 2000 Stored Procedure Programming
|
| |
 
|
Write scalable, high-performance SQL Server applications using stored pr...
Editora: McGraw Hill
ISBN: 0072125667
Autor: Dejan Sunderic
Páginas: 732
Formato: 18,5 x 23 (impresso)
|
|
Preço: |
0,00
|
|
Sinopse: Write scalable, high-performance SQL Server applications using stored procedures. SQL Server 2000 Stored Procedure Programming shows you how to use Transact-SQL to design, debug, and manage Stored Procedures Programming shows you how to use Transact-SQL to design, debug, and manage custom stored procedures, functions, and triggers. You’ll learn to manage SQL Server resources using new feature of Enterprise Manager, Query Analyzer, Visual Basic, and Visual Studio, implement robust error handling, and establish the professional habits you need to become and expert SQL Server developer. This guide contains simple explanations for developers who are just starting to work with stored procedures and advanced recommendations and techniques for experienced DBAs. SQL Server experts provide concise explanations, design recommendations, many examples, and a real-world case study. If you-re looking for in-depth details on SQL Server stored procedures, look inside.
Design user-defined, system, temporary, global temporary, extended, remote, and nested stored procedures;
Adopt tips and tricks using identity, timestamp, sql_variant, uniqueidentifier, optimistic locking, dynamically constructed queries, temporary talbes, and cursors;
Write code interact with COM, mail, executables, the Registry, jobs, and security;
Manage application security;
Locate and fix semantic errors using TSQL Debugger in Query Analyzes, Visual Basic, or Visual Studio, and using manual debugging techniques;
Create user-defined, table-valued, and in-line functions;
Design instead-of triggers and after triggers;
Manage transactions and locks;
Develop dynamic, Web-based applications using SQL Server’s XML capabilities. |
|
Compartilhe:
|
| |
|
|
| |
|
| |
Outros livros relacionados!
|
.
|
