Ars Technica

SQL Server 2000 T-SQL: Temp tables/derived tables - some basic help please

I need to select some data (surprise) from several tables in a linked database which is running SQL Server 2000.<BR><BR>Now the resulting data set will be about 10,000 records taken from ~ 8 ...
Visual Studio Magazine

Speed Up Stored Procedures with Table Valued Parameters

Peter revisits an earlier tip on how to use stored procedures to speed up your code. This version makes your stored procedures simpler … though you may have to write a little more code to make the ...
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 ...
Simon Fraser University

What Are PROC SQL Tables?

You create PROC SQL tables from SAS data files, from SAS data views, from relational DBMS tables using the LIBNAME statement, or from relational DBMS tables using the SQL Procedure Pass-Through ...