Answer Posted / kumar amit ranjan

To find Top 3 max Sal.... to put any number on the place of
3 to find nth max sal...


select top 3 sal from emp order by sal desc

How to get a list of columns using the "sys.columns" view in ms sql server?

945

---

What are page splits? : SQL Server Architecture

971

---

What are the extra roles available in msdb? : sql server security

1109

---

You want to implement the one-to-one relationship while designing tables. How would you do it?

945

---

How do I find the size of a sql server database?

907

---

What is a result set object returned by odbc_exec()?

1002

---

What is command parameter in ssrs?

159

---

Indexes are updated automatically is the full-text index also updated automatically?

1001

---

what is a deadlock? : Sql server database administration

1036

---

What is the latest version of microsoft sql server?

1023

---

code to create procedure for taking databse backup in sql server or i have the query for it but what it's query returns means i want to show on my jsp that the databse backup has been taken on the basis of that return value.does it returns 0 or 1.wat is the code for that

2193

---

What is difference between group by and having?

936

---

What is the new security features added in sql server 2016? : sql server security

1089

---

Explain the microsoft sql server delete command?

999

---

you have separate development and production systems you want to move a copy of a development database into production to do this, you do a backup on the development system and restore to the production system after a few minutes, you begin getting calls from several customers saying that they are denied access to the system why? : Sql server administration

960

---