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

How to create a new login name in ms sql server?

1024

---

What does dml stand for?

925

---

What security features are available for stored procedure?

1004

---

How many types of built in functions are there in sql server 2012?

893

---

What is rs.exe utility?

154

---

How to get the number of affected rows?

976

---

What are information schema views?

941

---

Why should we go for stored procedures? Why not direct queries?

1055

---

How exceptions can be handled in sql server programming?

978

---

Can you explain what are various ways to enhance the ssrs report?

971

---

How to change the name of a database user?

931

---

How to use linked server?

1129

---

What are the difference between “where” and “having” clause in sql server?

1029

---

What are the features of Embedded SQL

1104

---

Explain filtered indexes?

960

---