Answer Posted / shahid

select * from(select * from Employee order by salary desc) where rowNum<3

Explain the benefits of user-defined functions?

1056

---

What is a document index?

1022

---

How to execute function in stored procedure sql server?

1147

---

hi, the following are the outputs of sp_spaceused and sp_tempdbspace sp_spaceused ------------ database size unallocated size tempdb 77752.95 MB 28026.99 MB sp_tempdbspace ------------- database size spaceused tempdb 77752.945312 1.007812 the unused space in sp_spaceused is nearly 28 Gb and in sp_tempdbspace is nearly 76 Gb cany any one explain about this output and why its giving different results.

2927

---

Where sql server user names and passwords are stored in sql server? : sql server database administration

1048

---

What is the difference between a function and a stored procedure?

1066

---

what is the different types of backups available in sql server? : Sql server database administration

922

---

Explain about system stored procedure?

1031

---

What are system databases into sql server (2005/2008)?

997

---

How to verify a login name with sqlcmd tool?

1214

---

Benefits of Stored Procedures?

963

---

What are the differences between left join and inner join in sql server?

1104

---

Explain how long are locks retained within the repeatable_read and serializable isolation levels, during a read operation with row-level locking?

1160

---

Does sql server 2016 have ssms?

954

---

What are the types of indexing?

1079

---