wht's the differece between sqlserver05 and sqlserver2000
Answers were Sorted based on User's Feedback
Answer / 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
|Is This Answer Correct ?||2 Yes||0 No|
Answer / monal
SQL 2005: Database Snapshot, SNAPSHOT Isolation
Level, .NET, CLR, Online Backup, Online Index Building
|Is This Answer Correct ?||0 Yes||0 No|
Answer / velmurugan,uk
There are many differences interms of
5.Design and Deployment application,
and so on...
|Is This Answer Correct ?||0 Yes||1 No|
How can count the string ? for ex: If i have string like 'bhaskar' then i need like b:1 h:1 a:2 s:1 k:1 r:1 please give any idea on that
What is page in sql server?
What are the pros and cons of creating extended stored procedures?
What is the difference between clustered and non-clustered indexes in ms sql server?
What are the advantages of passing name-value pairs as parameters?
What is create statement?
What does it mean to normalize data?
what is raid and what are different types of raid configurations? : Sql server database administration
What is ms sql server triggers?
How do I setup a local sql server database?
Explain nested trigger in sql?
How to assign null values to variables or columns?