To run your SQL Pass-Through views for the MS SQL Server, you are encouraged, but not required, to create a data source name. You can use the ODBC administrator to create it. Refer to Data Source ...

PROC SQL allows you to specify the ORDER BY clause in the CREATE VIEW statement. Every time a view is accessed, its data are sorted and displayed as specified by the ORDER BY clause. This sorting on ...

But, if a view is just a stored query definition in the database with no data of its own until it is run, how can you create an index TechRepublic’s SQL Server newsletter, delivered each Tuesday ...