Simon Fraser University

Using a Pass-Through Query in a Subquery

Note: This example uses a Version 6 view descriptor with the Pass-Through Facility to access DBMS data. Beginning in Version 7, you can associate a libref directly with your DBMS data and use the ...
Simon Fraser University

CREATE TABLE Statement

is the name for the constraint being specified. The first form of the CREATE TABLE statement creates tables that automatically map SQL data types to those supported by the SAS System. Use this form ...
Network World

ORDER BY in a View is not allowed – or is it?

One of the restrictions of SQL Server 2005 (and now in 2008) is that you cannot include an ORDER BY within a view. This presumably is to remove the possibility of a “double sort” where the view ...