Microsoft SQL Server

From TekiWiki
Revision as of 09:51, 25 March 2016 by WikiSysop (Talk | contribs) (1 revision imported)

Jump to: navigation, search

Microsoft SQL Server is Microsoft's Relational Database Server.

Originally based on the Sybase database server, but Microsoft have developed it almost beyond recognition.

A compact neat way to add a sequence number to a table:

Number Rows in a Table

An example of a recursive query to find direct and indirect reports of an employee in a PeopleSoft database:

Direct Reports

The following script creates a set of useful temporary functions:

Useful Functions