9787115184702 (1 résultats)

paperback. Etat : New. Ship out in 2 business day, And Fast shipping, Free Tracking number will be provided after the shipment.Pages Number: 524 Publisher: People's Post Pub. Date :2008-08-01 first edition this book a comprehensive and systematic introduction to the SQL Server application development and management of technology. involving the installation and configuration of SQL Server. date processing. character handling. collation. number processing. data and summary statistics. page processing. tree data processing. data import and export operations. data backup and restore. user-defined data types. database security. application examples system tables. indexes. transactions and locks . SQL Server application troubleshooting and so on. This book not only combines the author using SQL Server 2000 process encounter a variety of common problems and application cases. the authors also summarize the community for several years in CSDN SQL Server version number of issues addressed. the demand for real projects. involving different types of applications. multi-angle to guide the reader to learn relevant knowledge. For various problems. the book provides detailed steps and Solutions. has a strong practical and operational. This book applies to have mastered the basics of SQL Server. but the lack of practical experience of the reader. for beginners it is an essential entry-and advanced guide book. Contents: Chapter 1 Installing and Configuring SQL Server1.1SQL Server version 1.2 and version choose to install SQL Server 1.3 FAQ 1.4 how to understand how an instance of an unattended installation 1.5Desktop Engine1.5.1MSDE 2000 Overview 1.5.2 for MSDE 20001.5. 3 Install MSDE 20001.5.4 management MSDE 20001.5.5 of concurrent users and database capacity 1.6SQL Server Service Pack1.6.1 determine the installed version of SQL Server 1.6.2SQL Server Service Pack 4 introduced 1.6.3SQL Server Service Pack 4 content 1.6.4 Installing SQL Server Service Pack 4 Service Frequently Asked Questions 1.7SQL Server 1.8 service account running SQL Server 1.9 affect the memory configuration settings 1.9.1 1.9.2 Data Storage Chapter 2 outlines the type of date Date processing 2.1 2.2 2.2 date handling functions .1 date information for changes in function 2.2.2 Date 2.2.3 Date difference calculation function. the function of other date-handling functions 2.2.4 2.3 Date option 2.3.1default language options 2.3.2SET DATEFIRST2.3.3SET DATEFORMAT2.3.4 SET LANGUAGE2.4 date format and date format projection processing processing 2.4.2 2.4.1 Date 2.4.3 Date of addition and subtraction processing date projected date of processing instance handle 2.5 2.5.2 2.5.1 birthday processing work day dealing with 2.5.3 Date of processing time calculation 2.6 Troubleshooting 2.6.1 Date 2.6.2 dealing with common errors common approach to the low efficiency of dates 2.6.3 Dates and Numbers Chapter 3. the type of character handling 3.1 Overview 3.2 Character string spin cycle 3.2.1 3.2.2 Interception Act dynamic T-SQL statements auxiliary table method method 3.2.3 3.2.4 3.2.5 spin-off spin-off data to digital data 3.2.6 column split strings into text data 3.3 3.3 3.3.1 Consolidation Act cursor .2 SELECT statements into a temporary table consolidation method 3.3.3 3.3.4 3.4 Fixed-line consolidation treatment of other string segments intercept 3.4.2 requires 3.4.1 update 3.4.3IP address and sub-3.5 string splitting and string consolidation 3.5.2 Applications 3.5.1 string comparison string intersection and set split string 3.5.3 and 3.5.4 to borrow statistical laws of string-free train trips 3.5.5 Sorting query string in a dynamic T-3.6 SQL statements in the application of dynamic T-SQL statements 3.6.1 3.6.2 Overview of the query string in the number of dynamic parameters of stored procedures using 3.6.3 3.6.4 Dynamic T-SQL statements in FAQ 3.7text deal with ntext fields 3.7.1text 3.7.2 and ntext data storage and management of text and ntext data 3.7.3text and merge replication ntext field and image f.