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 2: | Line 2: | ||
Originally based on the Sybase database server, but Microsoft have developed it almost beyond recognition. | 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]] | [[Direct Reports]] | ||
| + | |||
| + | The following script creates a set of useful temporary functions: | ||
[[Useful Functions]] | [[Useful Functions]] | ||
