Microsoft KB Archive/65408

INF: SQL Server Examples Using Built-In System Functions

PSS ID Number: Q65408 Article last modified on 07-31-1995

4.20

OS/2

= SUMMARY =

The file SQLSYSFN in the Software/Data Library contains SQL Server examples of using built-in system functions.

SQLSYSFN.EXE can be found in the Microsoft Software Library on GEnie, CompuServe, and Microsoft Partner Network (MSPN) by searching on the word SQLSYSFN.EXE, the Q number of this article, or S12693.SQLSYSFN.EXE is a compressed, self-extracting file. After you download the file, run it to extract the file(s) it contains.

= MORE INFORMATION =

The following is a list of the examples included in SQLSYSFN:


 * 1) Using OBJECT_ID and OBJECT_NAME to simplify the writing of queries against SQL Server catalog tables
 * 2) Using CONVERT, SUBSTRING, CONCATENATE, and so forth, in a view definition to convert data to the desired format
 * 3) BITMASK THETA JOIN
 * 4) Using expressions in the Select List Parts 1 and 2
 * 5) Numbering rows
 * 6) Simulating a cursor (in version 4.2, cursors render this example obsolete)

Additional reference words: 4.20 Transact-SQL softlib KBCategory: kbother kbfile KBSubcategory: SSrvServer

=
================================================================

Copyright Microsoft Corporation 1995.