ODBC Server Reference Manual

Contents
HP NonStop ODBC Server Reference Manual—429151-002
vii
4. Transact-SQL Language (continued)
4. Transact-SQL Language (continued)
GROUP BY Clause 4-87
HAVING Clause 4-88
ORDER BY Clause 4-88
COMPUTE BY Clause 4-89
FOR BROWSE Clause 4-89
NonStop ODBC Server Compared With SQL Server 4-89
NonStop ODBC Server Compared With NonStop SQL/MP 4-90
SET 4-92
Examples 4-94
NonStop ODBC Server Compared With SQL Server 4-94
NonStop ODBC Server Compared With NonStop SQL/MP 4-94
TRUNCATE TABLE 4-95
Examples 4-95
NonStop ODBC Server Compared With SQL Server 4-95
NonStop ODBC Server Compared With NonStop SQL/MP 4-95
UPDATE 4-96
Examples 4-97
NonStop ODBC Server Compared With SQL Server 4-97
NonStop ODBC Server Compared With NonStop SQL/MP 4-98
UPDATE STATISTICS 4-98
Examples 4-98
NonStop ODBC Server Compared With SQL Server 4-99
NonStop ODBC Server Compared With NonStop SQL/MP 4-99
USE 4-99
Examples 4-99
NonStop ODBC Server Compared With SQL Server 4-100
NonStop ODBC Server Compared With NonStop SQL/MP 4-100
5. Stored Procedures
Introduction to Stored Procedures 5-1
Overview of Stored Procedures 5-2
How Stored Procedure Execution Works 5-2
Installing and Using Stored Procedures 5-3
Execution of Stored Procedures 5-4
Invoking Stored Procedures in CORE SQL 5-4
Invoking Stored Procedures in Transact-SQL 5-5
Configuration Options 5-6
Development of Stored Procedures 5-6