wht's the differece between sqlserver05 and sqlserver2000
Answer Posted / jerry joseph
.NET Runtime integration
SQL Server 2005 is integrated with .NET Runtime
Email sending capability
You can send emails from SQL Server 2005 which you couldnt
do with SQL Servr 2000
TRY CATCH error handling
In SQL Server 2005 we have TRY CATCH for better error
handling. We had only @@ERROR in SQL Server 2000 which was
very primitive
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
How to send email from database?
Explain the difference between primary keys and foreign keys?
What are the differences in Clustering in SQL Server 2005 and 2008 or 2008 R2?
What are cascading parameters in ssrs reports?
How efficient you are in oracle and SQL server?
What is factless fact table? : sql server analysis services, ssas
How can you manage sql azure security?
Can you change the data type of a column in a table after the table has been created? If so, which command would you use?
How to get a list of columns using the "sp_help" stored procedure in ms sql server?
What is index, cluster index and nonclustered index?
Explain the disadvantages of cursors?
How do you maintain database integrity where deletions from one table will automatically cause deletions in another table?
Define outer join in sql server joins?
What is the difference between nvl and nvl2?
What is the meaning of sql server?