Diffrences between sql server 2000 vs 2005
- 2 Answers
- 4551 Views
- Thomson Reuters, I also Faced
- E-Mail Answers
Answer Posted / sakthi
for error handling in 2005 we use try catch, new functions
like pivot and unpivot, datatype nvarchar(max), varchar
(max), char(max) to handle xml in 2005 we have special
datatype caller XML.
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
How do you handle datasets larger than 50 gb?
What is the difference between ddl,dml and dcl commands?
How to drop existing indexes in ms sql server?
What are the restraints imposed on the table design by a merge replication?
What are the disadvantages of using the stored procedures?
What is parameterized reports in ssrs ?
What are the new features in SQL Server 2005 when compared to SQL Server 2000?
What happens if ntwdblib.dll is missing on your machine?
What is the report builder?
What are the lambda triggers?
What is inner join in sql server joins?
How adventureworkslt tables are related?
What programming language would you use to create embedded functions in ssrs?
Explain transaction server distributed transaction?
you have couple of stored procedures that depend on a table you dropped the table and recreated it what do you have to do to reestablish those stored procedure dependencies?
