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...

What is an index in a database?

922

---

How to insert multiple rows with one insert statement in ms sql server?

1055

---

What is the purpose of the master database?

1052

---

How to enter unicode character string literals in ms sql server?

1017

---

Describe how to use linked server?

933

---

Where views are stored in sql server?

925

---

Explain about link server in sql server?

1001

---

What are the differences between sql server and mysql.

1024

---

How to delete duplicate rows from table except one?

931

---

Write a Select Query to display title for each group of records, which are collected with Compute Clause? Like titlefield column-A column-B ..... ..... ..... Sum ... titlefield column-A column-B ..... ..... ..... Sum ...

1988

---

What the different components of Replication and what is their use?

1015

---

Explain what is meant by replication of database?

957

---

What are the advantages of using stored procedures?

888

---

What is the difference between count () and rowcount ()?

946

---

What are xml indexes?

892

---