Summary
SQL is a powerful data-access and data-modification language. SQL Server's enhanced version of SQL, Transact-SQL, further expands the powers and capabilities of your SQL queries by providing features such as functions, variables, and commands to control execution flow. The Transact-SQL commands also are the basic building blocks for creating even more powerful SQL Server database components such as views, stored procedures, triggers, and user-defined functions.
The next four chapters, “Creating and Managing Views in SQL Server,” “Creating and Managing Stored Procedures in SQL Server,” “Creating and Managing Triggers,” and “User-Defined Functions” describe how to create these objects using Transact-SQL. Chapter 31 shows you how to group ...
Get Microsoft® SQL Server™ 2000 Unleashed, Second Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
