SQL Server 2000/ SQL 7.2 ??? [Archive]

antares686

July 21st, 2003, 05:25 AM

It is 7.0 but you may have a Service Pack on there.

As for documentation, there used to be a side-by-side on the MS SQL (http://www.microsoft.com/sql) site but I cannot find. But here are some of the majors.

-------------------------------------------------------------------------------

User Defined Functions added in 2000 (These are very usefull)

New datatypes add in 2000 including BIGINT (lots more identity values) and TABLE (a good replacement for small temp tables).

DTS got a host of new features including FTP in SQL 2000.

Ability to set collation on the database and the table column seperately from the server.

Ability to set sort order for a column in an index added in 2000 (this is nice especially for clustered indexes and provides a bit more control).

The query engine got a few adjustments that streamline some of the choices made by the egine. There is however a gotcha here in that som implicit datatype conversion (when the egine must match datatypes to be able to compare) no longer work. It is always better to be explicit by using a CAST or CONVERT to match them like you want and this will not be an issue.

Triggers support more options for relation time such as AFTER and INSTEAD OF.

You can also setup Foreign Key constraints to do CASCADE UPDATEs and CASCADE DELETEs where before you had to write a trigger.

You can set capatibility levels on databases to 6.5 or lower, 7 and 8 (2000). This means syntaxes and behaior for the most part are the same for those databases the same as they would be on those servers. So syntax available in 2000 will not work in a 6.5 compatible database. This is nice in that you no longer have to have SQL 6.5 installed to run a database there you can move to 2000 and when you are ready switch to 2000 compatible. Thsi make nice since user connections don't have to change in many cases.

XML output support added in SQL 2000.

Enhancements to the amount of RAM a server instance can handle. And a bit of OLAP (now called Analysis Services) enhancement but I don't have anything or time where I can play with this.

There are enhancements to QA such as debugging and Object browser (this allows you to browse a servers objects and drag and drop names).

Profiler got a several new monitor items.

I know I missed some stuff but these are the things I know affected me most.

Here is the info on 2000 Product Overview (http://www.microsoft.com/sql/evaluation/overview/default.asp)