Answer Posted / harinireddy

in is peferable bcoz
by using in we can write set of values at time n check it
where as when we use or we need to mention for each n every
value
like ...
select emp_id from employee where emp_id in(1,2,3,4..)
but in case of or...
select emp_id from employee where emp_id=1 or emp_id=2 or
emp_id=3 or emp_id=4...

Using the customer, and order table in northwind database, please write a query to produce xml?

1067

---

Explain logical operators in sql server?

1105

---

What you can do to delete a table without the delete trigger firing?

965

---

Write a program to fetch first 10 records from a file?

1001

---

How dts is used to extract, transform and consolidate data?

1069

---

What is default constraint in ms sql server?

1026

---

What is the use of RDBMS?

997

---

How to restore performance issues and how to check?

1997

---

How to get a list of all tables with "sys.tables" view in ms sql server?

1030

---

What is the Difference Between Primary and Foreign Key?

1002

---

What is Sqlpaging in SqlServer 2005 ?

1061

---

What is rtm version in sql server?

1047

---

what do you understand by change data capture?

999

---

Can we insert data into a view?

1129

---

Explain microsoft sql server functions?

1104

---