Answer Posted / harikumar

select max(salary) as secondMax from employee where salary
<> (select max(salary) from employee)

How can you list all the columns in a database?

931

---

Why use triggers?

1014

---

What is the report model project?

141

---

What is resultset concur_updatable?

1021

---

What are the differences between stored procedure and view in sql server?

1248

---

Does any body please help me what question's have asked for SSRS in the interview?

2148

---

How to call stored procedure using http soap?

1079

---

What is a bit datatype?

987

---

Explain stored procedure?

1055

---

How to make a column nullable?

1115

---

What do mean by xml datatype?

1103

---

what are the critical issues you have resloved in your company

1964

---

Explain nested stored procedure. Syntax and an example for create nested stored procedure?

933

---

How to include text values in sql statements?

1040

---

What are extended events in sql server?

955

---