Interested to Buy Any Domain ? << Click Here >> for more details...
Difference between sql server 2000 and sql server 2005?
- 11 Answers
- 53117 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
How to return the date part only from a sql server datetime datatype?
what are the core components of SSRS?
What are the limitations in ssrs on sql server express edition?
What are the system database in sql server 2005?
What is data source in connection string?
as a part of your job, what are the dbcc commands that you commonly use for database maintenance? : Sql server database administration
What is the architecture of ms sql reporting service?
What is stored in the mssqlsystemresource database? : sql server database administration
what is a sub-report?
What is blocking?
How except clause is differs from not in clause?
what is normalization? Explain different levels of normalization? : Sql server database administration
Describe and explain about SQL native client?
How many replicas are maintained for each sql azure db?
What is the difference between ddl and dml?
