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 are the types of table?

921

---

Explain what is the use of custom fields in report?

872

---

Explain the microsoft sql server delete command? : SQL Server Architecture

1011

---

Is the primary key column of a table an index in ms sql server?

920

---

What is the main difference between ‘between’ and ‘in’ condition operators?

1106

---

A trigger can reference objects outside the current database? State true or false.

948

---

How do you maintain database integrity where deletions from one table will automatically cause deletions in another table?

1140

---

Differentiate between a primary key and a unique key.

1001

---

List the data types available in mssql?

959

---

How to join two tables in a single query in ms sql server?

943

---

1.what are diff types of joins , and explain diff between cross join and full outer join 2.diff types of views 3. Diff types of index 4. What is diff b/w stores procedure and function procedure 5.diff between double and int in SQL 6.diff between char and varchar in SQL. 7.Oracle or SQL whice you will preferred and why.

1530

---

Where are full-text indexes stored?

948

---

What are 3 ways to get a count of the number of records in a table?

1019

---

Explain atomicity?

974

---

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?

888

---