Difference between revisions of "Microsoft SQL Server"

Revision as of 08:51, 25 March 2016

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