Questions Linux Laravel Mysql Ubuntu Git Menu

HTML CSS JAVASCRIPT SQL PYTHON PHP BOOTSTRAP JAVA JQUERY R React Kotlin

Why should I upgrade from SQL2000 to SQL2005?

Tags:

sql-server-2005

sql-server-2000

upgrade

I'm looking for the single biggest reason you are glad that you've already made the jump from SQL2000 to SQL2005.

like image

421

asked Sep 26 '08 17:09

Rocket Squirrel

2 Answers

Recursion without creating temporary tables.
Native Exception support (Try/Catch instead of if @Error goto)

like image

132

answered Sep 25 '22 00:09

FlySwat

Because:

Microsoft would like to remind customers that support for SQL Server 2000 Service Pack 3a (SP3a) will end on July 10, 2007.

like image

42

answered Sep 23 '22 00:09

Esteban Araya

Sign in to Comment

Related questions
                            
                                Update WHERE NOT EXISTS problem
                            
                                SQL Server PIVOT perhaps?
                            
                                Setting and resetting the DATEFORMAT in SQLServer 2005
                            
                                How to pass parameter values to a T-SQL query
                            
                                SQL: how to select single record for multiple id's on the basis of max datetime?
                            
                                identifying values which would be truncated in an insert query
                            
                                SQL Server, select a record every 'x' amount of records
                            
                                Converting datetime format to 12 hour
                            
                                Programmatically detach SQL Server database to copy mdf file
                            
                                SQL Server won't use my index
                            
                                How to solve 'invalid object name' in SQL Server?
                            
                                C# SqlCommand - cannot use parameters for column names, how to resolve?
                            
                                Composite primary keys and influence on natural/surrogate keys usage [closed]
                            
                                How to convert the system date format to dd/mm/yy in SQL Server 2008 R2?
                            
                                SQL Performance-wise, what's better: an IF...ELSE clause, or WHERE LIKE clause?
                            
                                Best way to change clustered index (PK) in SQL 2005
                            
                                tsql script to find tables not being used by stored procedures, views, functions, etc?
                            
                                Having TRANSACTION In All Queries
                            
                                SELECT DISTINCT and ORDER BY
                            
                                Changing SQL Server named instance to default instance

Donate For Us

If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!

Donate Us With