Microsoft SQL Server 7.0 Programming Unleashed
Certified professionals offer the benefits of their experiences in a variety of SQL Server settings as well as useful tips and workarounds to common problems. Overview of Major Topics: Part I. Advanced Programming Techniques Part II. SQL Server - Essential Programming Solutions Part III. Migrating to SQL Server: Data Conversion and Integration Part IV. Programming Internal and External Connections Part V: Programming Real-World Implementations Part VI: Reference The authors also provide shortcut programs to solve common problems and ways to make code work more efficiently and with less traffic between the client and the server. This book offers much more than the closest competition, which offers only Microsoft-based solutions in an homogeneously Microsoft environment.
What people are saying - Write a review
We haven't found any reviews in the usual places.
IN THIS PART
BEYoMD THE BASICs of DATA MANIPULATION LANGUAGE
Using Subqueries and Inline Views
41 other sections not shown
ADODB application au_id au_lname BEGIN SELECT changes CHAPTER client clustered index column command components configuration connection create crosstable cursor data source data type data warehouse database object DBCC DCOM DECLARE default DELETE dialog Displays driver dynamic execution Enterprise Manager error example EXEC FETCH Fewuniques Figure foreign keys function implementation INSERT integer interface join lock login method Microsoft SQL Server Microsoft Transaction Server NULL º º objConn ODBC OLE DB OLTP Optimizer option output parameter performance PowerBuilder programming recordset replication resultset retrieve role RTRIM script SELECT statement shown in Listing Smallint specified SQL Server 7.0 SQL-DMO sqlval stored procedure string Sybase syntax T-SQL task tinyint title_id titles Transact-SQL transaction trigger update varchar variable Visual Basic Windows NT Wizard