PROC SQL views can both read and update the data that they reference. PROC SQL supports more types of WHERE clauses than are available in DATA step processing and has a CONNECT TO component that ...

You establish a connection to send Transact-SQL statements to SYBASE or to retrieve SYBASE data. You can connect multiple times to one or more servers. After you establish a connection, it remains in ...

Learn how Data Transformation Services (DTS) can help you import, export, and/or transform data from various sources to single or multiple locations in Microsoft SQL Server 2000.