Microsoft SQL Server 2000 Programming by ExampleQue Publishing, 2001 - 771 Seiten SQL Server 2000 Programming by Example provides clear and concise examples of basic programming techniques used in SQL Server 2000 primarily using Transact-SQL. Even if you're a complete novice to SQL Server 2000 programming, you will benefit by reading through the book's logical process. SQL Server 2000 is introduced and explored, database structure is designed and built, and finally a variety of programming techniques are studied and reviewed. If you are already familiar with SQL Server 2000 programming, you may use the book as a quick reference guide that provides plenty of pertinent examples. |
Inhalt
Introduction | 1 |
Relational Database Management Systems and SQL Server | 7 |
Elements of TransactSQL | 59 |
Working with Tables and Views | 91 |
Querying and Modifying Data | 121 |
The WHERE Clause | 130 |
Data Aggregation and the GROUP BY Clause | 136 |
The TOP N Clause | 143 |
Programming Triggers | 329 |
UserDefined Functions UDF | 389 |
Using Complex Queries and Statements | 463 |
Using Cursors | 507 |
Transactions and Locks | 553 |
Concurrency Problems | 574 |
Transferring Data to and from SQL Server | 617 |
Setting Up Linked Servers | 665 |
JOINS | 159 |
CROSS JOINS | 178 |
Indexes | 187 |
Solve Join Operations | 193 |
Enforcing Data Integrity | 239 |
Programming Stored Procedures | 295 |
A Using SQL Server Instances | 703 |
B Using SQL Query Analyzer | 721 |
| 749 | |
| 750 | |
| 764 | |
Häufige Begriffe und Wortgruppen
affected ALTER TABLE batch bytes Categories CategoryID CategoryName CAUTION Chapter CHECK constraint clause clustered index column CompanyName connect to SQL ContactName cost CREATE TABLE cursor CustomerID Customers data type database role DB S GRANT dbo.Customers user table DECLARE defined DELETE DTS package Eastern EmployeeID Employees Enterprise Manager EXAMPLE Listing EXEC Figure firstname FOREIGN KEY GRANT 56 Index Seek INNER JOIN INSERT int NOT NULL JOIN operation keyword lastname linked server locks login Microsoft SQL Server MyProducts NewOrders Node nonclustered index Northwind SELECT NULL NULL nvarchar ODBC OLE DB option Order Details OrderID OUTER JOIN parameter password permissions PRIMARY KEY PRINT CHAR(10 ProductName Products query plan RegionID result set retrieve returns row(s script SELECT statement specify SQL Query Analyzer SQL Server 2000 subquery syntax system stored procedure table no yes temporary tables Transact-SQL transaction UNIQUE UnitPrice UPDATE user-defined functions variable Windows Wizard Π Π Π