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 different types of data sources?

1004

---

Can we use where clause in union?

1055

---

What are information schema views?

969

---

How do I save a stored procedure in sql server?

985

---

What is command parameter in ssrs?

161

---

How to access the inserted record of an event?

1041

---

How you can add messages to the nt event log from within a stored procedure?

1056

---

Disadvantages of the indexes?

1110

---

What is master database? : SQL Server Architecture

1010

---

Explain what is use of dbcc commands?

1042

---

Explain DBCC?

949

---

What are the types of containers in ssis?

1158

---

You have a table ‘test’ which is a copy of northwind employee table you have written a trigger to update the field ‘hiredate’ with the current date

1043

---

Explain the phases a transaction has to undergo?

1047

---

What are “lost updates”?

985

---