Difference between sql server 2000 and sql server 2005?
- 11 Answers
- 50043 Views
- Aditi Tech, eInfochips, GE, HCL, IBM, Masim Infotech, NIIT, Satyam, Systems Domain, I also Faced
- E-Mail Answers
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 the command used to recompile the stored procedure at run time?
How to create new table with "create table" statements?
What is resource db in sql server?
How do you create an execution plan?
When a primary key constraint is included in a table, what other constraints does this imply?
What are the new features of sql server 2012 reporting service?
What is transaction server distributed transaction?
Why are sql functions used?
What is the log shipping?
How to convert character strings into numeric values?
What does it mean to invest in the index?
What is sql server used for?
How to assign null values to variables or columns?
What is data modeling and Reterminal integrity?
Does any body please help me what question's have asked for SSRS in the interview?
