Difference between sql server 2000 and sql server 2005?
Answer Posted / rajneesh hajela
datatype:
2000
1. new datatype 2005
varchar(8000 character) varchar(Max)(2^31 Character)
2.
nvarchar(4000 character) nvarchar(max)(2^30 character)
3.
varbinary(8000 byte) nvarbinary (2^31 byte)
4. xml --> stored xml data
---------------------
SSIS (SQLSERVER Integration service)
-----------
try/ catch
------------
Pivot,Unpivot
--------
2000
select top 10 *
2005
select top(10) *
-----------
Rajneesh Hajela
Is This Answer Correct ? | 23 Yes | 8 No |
Post New Answer View All Answers
What is @@rowcount in sql?
Where can you add custom error messages to sql server?
Tell me what is a linked server?
What are the authentication modes in sql server? How can it be changed?
What are the difference between clustered and a non-clustered index?
What command is used to delete a table from the database in the sql server and how?
Is resultset an interface?
How will you optimize a stored procedure optimization?
Do you know sql server 2008 introduces automatic auditing?
What is a mutating table error and how can you get around it?
How do I connect to sql server database?
What is a not null constraint?
what is a schema in sql server 2005? : Sql server database administration
Can you explain about buffer cash and log cache in sql server?
What is the difference between SQL notification and SQL invalidation?