Answer / Mahak Singh

SQL Server provides a variety of functions to manipulate data, such as built-in system functions (like ISNULL, LEFT, and CONCAT), user-defined functions, aggregate functions (SUM, AVG, COUNT, etc.), scalar functions (LEN, ABS, FLOOR, etc.), and window functions (ROW_NUMBER, RANK, LAG, etc.).

How to create a Master database in SQL server ?

1 Answers   MCN Solutions,

---

What is meant by indexing files?

1 Answers  

---

What is the difference between NOROW and LOCKROW?

1 Answers   Accenture, Honeywell, Satyam,

---

How to tune a stored procedure?

6 Answers  

---

Do you think BCNF is better than 2NF & 3NF? Why?

1 Answers   Ernst Young,

---

What is the command to change the recovery model?

1 Answers  

---

Explain go command in sql server?

1 Answers  

---

Can two tables share the same primary key?

1 Answers  

---

How do I create a trace in sql server?

0 Answers  

---

Which feature in sql server 2008 has surprised you? You can name just one. : sql server database administration

1 Answers  

---

What is pessimistic concurrency?

1 Answers  

---

What is the difference between login and a user?

13 Answers   CTS, TCS,

---