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 do in data exploration

928

---

Explain about analysis services?

980

---

How to count groups returned with the group by clause in ms sql server?

1006

---

can a table be moved to different filegroup? : Sql server administration

910

---

How to copy data from one table to another table?

933

---

What is conditional split?

991

---

Can I use sql azure as a backup with log shipping or database mirroring?

156

---

What is the difference between Stored Procedures and triggers?

1034

---

What is shrink log file?

843

---

How is a full-text index updated?

896

---

What are the differences between stored procedure and view in sql server?

1159

---

What functions can a view be used to performed?

995

---

What is it’s similarity with sql server?

160

---

Can sql servers linked to other servers like oracle?

902

---

What is isolation levels?

962

---