Microsoft SQL Server
From TekiWiki
This whole wiki has now moved to http://www.springboardsolutions.com/wiki
Go to this page Microsoft SQL Server
| Line 1: | Line 1: | ||
Microsoft SQL Server is Microsoft's Relational Database Server. | 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]] | [[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]] | ||
