Answer Posted / dharmendra nonia

Function and Stored Procedure both are precompiled objects
in databases but there is some difference between UDFs and
Stored Procedure such as--
1)Function Must be return at least one value but stored
procedure may or may not.
2)We can use Function for only data manipulation but stored
Procedure is used to Manipulation as well as Modification
of Data on tables.
3)We can't use DML statements inside Function but In stored
Procedure, we can use DML statements.
4)In stored Procedure, we can pass INPUT and OUTPUT
parameter but Function accept only input parameter and
return a value.

What are partitioned views and distributed partitioned views?

1061

---

Mention the command used to rename the database.

1048

---

What is partitioned view?

957

---

How to configure and test odbc dsn settings?

1224

---

Which tools are available to manage SQL Azure databases and servers?

115

---

What is pivot and unpivot?

1060

---

What are the drawbacks of reporting in ssrs?

159

---

Does sql server 2016 have ssms?

1001

---

What are the difference between primary key and unique key? : sql server database administration

986

---

How retrieve field names from the table in SQL through JAVA code?

1946

---

What is partition in sql server?

1084

---

What are the advantages of passing name-value pairs as parameters?

1215

---

Can We Use Data-grids For Our Report In Ssrs?

188

---

What is Cross Join and in which scenario do we use Cross Join?

1056

---

What is a mutating table error and how can you get around it?

1119

---