Diffrences between sql server 2000 vs 2005
Answers were Sorted based on User's Feedback
Answer / 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 |
What are sparse columns?
How to delete database objects with "drop" statements in ms sql server?
How to download and install microsoft .net framework version 2.0?
How do I get to sql server configuration manager?
Difference between DELETE and TRUNCATE?
What is the use of MOVE keyword in restore command
What is stored procedure in SQL..??
What are the type of joins? When do we use Outer and Self joins?
explain query execution plan
What the difference between UNION and UNIONALL?
Why use view instead of a table?
What is an sql server agent?
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)