Answer Posted / elumalai.k

select max(salary) from tablename

What does normalization do to data?

535

---

What are data resources?

500

---

What is service broker?

577

---

Are null values the same as that of zero or a blank space?

567

---

Explain the different index configurations a table can have?

500

---

---

What is query and its types?

506

---

What are the advantages of using stored procedures?

532

---

What is multi-statement table-value user-defined function?

530

---

What is difference between oltp and olap?

568

---

How to loop through result set objects using odbc_fetch_row()?

461

---

What is cursors?

635

---

Mention the command used to rename the database.

532

---

How to get a list of columns in a view using the "sp_help" stored procedure?

564

---

How to create database with physical files specified in ms sql server?

531

---

What stored by the msdb? : sql server database administration

555

---