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

What is the difference between upgrade and migration in sql server?

1102

---

Difference between 2NF &3NF ?

1091

---

You notice that the transaction log on one of your databases is over 4gb the size of the data file is 2mb what could cause this situation, and how can you fix it?

1127

---

What are the various editions of sql server 2017 that are available in the market?

895

---

What does <> symbol mean?

985

---

How many joins in sql server?

968

---

What are the underflow and overflow behaviors on float literals?

1118

---

what is a deadlock? : Sql server database administration

1076

---

What is table valued function and scalar valued functions?

1098

---

If a user does not have permission to a table, but has permission to a view created on it, will he be able to view the data in table?

947

---

List out what other servers you can use with ssrs?

139

---

What is in place upgrade in sql server?

1054

---

If you want to send some data from access database to sql server database. What are different component of ssis will you use?

989

---

Can sql servers link to other servers?

1095

---

What is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure? How many levels of sp nesting are possible?

1011

---