Answer Posted / amarjit singh

--display 3rd higest salary in MSSQLSERVER
select max(sal) from emp
where sal <(select max(sal) from emp
where sal <(select max(sal) from emp
))

--By , STUDENT OF IET BHADDAL ENG COLLEGE

Explain error handling in ssis?

581

---

Explain four layers of abstraction microsoft architectured?

124

---

What are Row versions of DataRow?

618

---

Explain what is public role in sql server?

598

---

What happens when unicode strings concatenate with non-unicode strings?

558

---

---

sql database suspect We have a sql database that is showing as suspect. How can we recover?

1418

---

What is spid in sql server profiler?

550

---

What is the command dbcc checkdb used for?

544

---

How do you delete duplicate rows in sql server?

515

---

Explain multiserver query

565

---

What is the difference between Stored Procedures and triggers?

586

---

Define outer join in sql server joins?

539

---

What is inner join in sql server joins?

554

---

What is database black box testing?

621

---

What is sql server management studio? : sql server management studio

593

---