Answer Posted / shashi kishor prasad

The where Clause allows you to give so many conditions like
in the above case you can use
select * from employee where empid >122
select * from employee where empid <125
select * from employee where empid between 122 and 125
select * from employee where empid is not null(if null allowed)
and many moer..........
where as
The in clause allows you to give a no of values inside the
parenthesis decided by you like

select * from employee where empid in(123,1234,125)
or
select * from employee where empid in(select empid from
employee where empid>200)

What are the new features in sql server 2016?

973

---

What is inner join? Explain with an example?

1230

---

What are the properties of primary key?

976

---

What is the difference between Clustered and Non-Clustered Index?

1062

---

What do we have to check in database testing?

1023

---

What are the risks of storing a hibernate-managed object in a cache? How do you overcome the problems?

1112

---

How can sql server instances be hidden? : sql server security

1154

---

What are triggers? How do you invoke a trigger on demand?

1321

---

How can windows applications connect to sql servers via odbc?

1129

---

how you can list all the tables in a database?

1030

---

What is self contained scalar sub query?

977

---

where can you add custom error messages to sql server? : Sql server administration

1127

---

What happens when transaction log is full?

933

---

What is the use of keyword with encryption. Create a store procedure with encryption?

966

---

What is bulkcopy in sql?

951

---