Answer Posted / s.chandrahasan

A stored procedure is like a miniture program in SQL Server.
It can be as simple as a select statement, or as complex as
a long script that adds, deletes, updates, and/or reads data
from multiple tables in a database. (Stored procedures can
also implement loops and cursors which both allow you to
work with smaller results or row by row operations on data.)

The SQL Server functions are option for doing certain
operations in SQL Server. They can not be used to update,
delete, or add records to the database. They simply return a
single value or a table value. They can only be use to
select records. However, they can be called very easily from
within standard SQL, such as:

SELECT dbo.functionname('Parameter1')

OR

SELECT Name, dbo.Functionname('Parameter1') FROM sysObjects

For simple reusable select operations, functions can simply
your code. Just be wary of using JOIN clauses in your
functions. If your function has a JOIN clause and you call
it from another select statement that returns multiple
results, that function call with JOIN those tables together
for EACH line returned in the result set. So though they can
be helpful in simpling some logic, they can also be a
performance bottleneck if they're not used properly.

Detail about the hardware which is supported by SQL server?

1008

---

What are four major operators that can be used to combine conditions on a where clause?

983

---

What is the latest version of microsoft sql server?

956

---

Can you change the data type of a column in a table after the table has been created? If so, which command would you use?

975

---

Does dbcc checkdb requires db to be in single_user mode? : sql server database administration

912

---

What is the difference between getdate and sysdatetime?

940

---

What do you understand by integration services in sql server?

917

---

Data table as parameter in sql server?

973

---

What is the optimal disk configuration for a database server and what raid configurations would you use if budget is not a constraint?

903

---

How to concatenate two character strings together?

1053

---

What are the joins in sql server? : sql server database administration

961

---

What is the sql case statement used for?

1032

---

How to connect to a sql server using odbc_connect()?

1090

---

What is application role in sql server database security? : sql server security

992

---

How do I port a number to sql server?

978

---