What is the difference between Userdefined function and stored procedure? Explain and give the example also

5 Answers  

---

Is truncate a dml command?

0 Answers  

---

What is an extended stored procedure? Can you instantiate a COM object by using T-SQL?

3 Answers   HCL,

---

is it important for a database administrator to understand the operating system and file access? : Sql server administration

0 Answers  

---

select the 3rd maximum salary from sql server database if 4 (just an example In practically I may not know the exact situation) of the highest salaries are equal.

8 Answers   TCS,

---

What is bit datatype and what's the information that can be stored inside a bit column?

1 Answers  

---

What are the hotfixes and patches in sql server?

0 Answers  

---

WHY CAN WE CREATE ONLY ONE CLUSTERED INDEX ON A TABLE IN SQL SERVER?

8 Answers  

---

What happens if date-only values are provided as date and time literals?

0 Answers  

---

Where are sql server user names and passwords stored in sql server?

0 Answers  

---

Explain basic SQL queries with SELECT from where Order By, Group By-Having?

3 Answers   TetraSoft, Wipro,

---

What is attribute hierarchy? : sql server analysis services, ssas

0 Answers  

---