Content deleted Content added
→SQL Server 2000: T-SQL language enhancements |
|||
Line 141:
* an [[OLAP]] and [[data mining]] server ([[Microsoft Analysis Services|Analysis Services]])
* several messaging technologies, specifically Service Broker and Notification Services
SQL Server 2000 also introduced many T-SQL language enhancements, such as table variables, user-defined functions, indexed views, INSTEAD OF triggers, cascading referential constraints and some basic XML support.<ref>http://www.informit.com/articles/article.aspx?p=25735</ref><ref>http://sqlmag.com/t-sql/sql-server-2000s-coolest-features</ref>
=== SQL Server 2005 ===
|