Simon Fraser University

PROC SQL and the ANSI Standard

PROC SQL follows most of the guidelines set by the American National Standards Institute (ANSI) in its implementation of SQL. However, it is not fully compliant with the current ANSI Standard for SQL.
Simon Fraser University

PROC SQL Pass-Through Views

A Version 6 PROC SQL Pass-Through view does not need to be updated to be used in Version 7 or Version 8. The conversion of PROC SQL Pass-Through views is automatic and does not require you to use the ...
Ars Technica

SQL Server - What is optimal RAID configuration? And SQL multi-proc licensing?

Looking to run SQL 2000 as a platform for an ERP app on a new box. Dual P4, 2GB RAM, up to 6 SCSI drives in any of a variety of RAID configurations.<BR><BR>The research I've done and the ERP vendor ...
Ars Technica

concurrent sql commands in T-SQL under SQL Server in a stored proc?

Yes a sproc can return multiple resultsets and you can even work with them in ADO, though it is somewhat esoteric.
Redmond Magazine

T-SQL Smarts: Executing Sp_executesql

In this third in a series on working smarter with T-SQL, let's give the built-in sp_executesql stored proc a go. In my previous posts, I've described some methods for generating and executing T-SQL ...