Difference between sql server 2000 and sql server 2005?
- 11 Answers
- 51257 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 main purpose of having conversation group?
What is difference between rownum and rowid?
What is Command line parameters in PLSQL.?
How do I partition a table in sql server?
What is a domain constraint give an example?
Does a sql server 2005 select statement require a from?
How do I find query history in sql server?
How to connect a database with sql express.?
What are blobs, tables, and Queues? Is SQL is the standard way to query blobs, tables, and queues?
What is a trigger and its types?
How to transfer an existing table from one schema to another schema in ms sql server?
What is temporary table in sql server? Why we use temp table?
What is a data collection table?
What are sql server procedures?
How do you rename a table in sql server?
