登入選單
返回Google圖書搜尋
Beginning Transact-SQL with SQL Server 2000 and 2005
註釋Beginning Transact-SQL Programming teaches beginners who have not yet programmed with Transact-SQL. Some familiarity with relational databases and basic SQL is expected, and some programming experience is helpful. The primary audience is database developers; secondary markets include database administrators (DBAs) and business analysts.The book begins with an overview of SQL Server query operations and tools used with Transact-SQL. After a quick review of basic query language commands and syntax, the author quickly moves to show how to design and build applications of increasing complexity. He covers such important tasks as:· Introducing Transact-SQL and Data Management Systems· SQL Server Fundamentals· Tools for Accessing SQL Server· Introducing Transact-SQL Language· Data Retrieval· SQL Functions· Aggregation and Grouping· Multi-Table Queries· Data Transactions· Advanced Queries and Scripting· Full-Text Index Queries· Creating and Managing Database Objects· Transact-SQL Programming Objects· Transact-SQL in Applications and Reporting