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 you would rewrite the sql query to return the customerid sorted numerically?
Is sql different from sql server?
What is database dimension? : sql server analysis services, ssas
How to drop an existing stored procedure in ms sql server?
How to optimize stored procedures in sql server?
In what sequence sql statement is processed?
How to sort query output in descending order in ms sql server?
What stored procedure would you use to view lock information?
How do you run a trace?
what are the critical issues you have resloved in your company
how you can deploy an ssrs report?
Can you explain the disadvantages/limitation of the cursor?
How to choose all records from the table?
How will you make an attribute not process? : sql server analysis services, ssas
Is a null value equal to anything? Can a space in a column be considered a null value? Why or why not?