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.

How much space does sql server 2016 take?

915

---

What is a view in sql?

935

---

How to find which stored procedure is currently running in sql server?

932

---

What is set nocount on and what is set nocount off?

895

---

What happens to a statement batch if there is a compilation error?

907

---

What is constraints and its types?

885

---

Do you know concepts and capabilities of sql server?

1013

---

Can anyone tell that the extra features are there in SQL SERVER 2008 that are not available in previous versions .

1909

---

How to execute multiple stored procedures at one time in sql server?

951

---

What are commonly used mssql functions in php?

1014

---

A user is a member of the public role and the sales role. The public role has select permission on all the tables. The sales role does not have select permission on some of the tables will the user be able to select from all tables?

912

---

What are security principals used in sql server 2005?

918

---

Explain what are the restrictions while creating batches in sql server?

1032

---

What authentication modes does sql server support?

1030

---

What is subquery in sql?

995

---