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 do you understand by a stored procedure?

1088

---

What does the not null constraint do?

1086

---

What is the difference between cube operator and rollup operator? : SQL Server Architecture

1122

---

Write query to return all rows sql?

1053

---

What will be query used to get the list of triggers in a database?

1002

---

what changed between the previous version of sql server and the current version? : Sql server database administration

1007

---

Do you know what is lock escalation?

1011

---

What is the difference between char, varchar and nvarchar?

1022

---

Can we linked SharePoint to a SQL database?

1028

---

What is a trace frag?

1085

---

How many types of objects are there?

1008

---

What are “phantom rows”?

1657

---

Can you explain various data region available in ssrs with their use?

976

---

What is use of except clause?

1092

---

Do you know what are pages and extents? : SQL Server Architecture

995

---