Best Answer

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.

User Avatar

Wiki User

โˆ™ 2009-06-09 07:29:11
This answer is:
User Avatar
Study guides

Is Microsoft Access an RDBMS or DBMS

How might an automobile company use a management information system to reduce its costs and better serve its customers

What are PCs that are classified as mobile computers

What are the entry barriers that act as a potiential threat to new entrants in the market

See all cards
9 Reviews

Add your answer:

Earn +20 pts
Q: What is difference between function and stored procedure in sql server?
Write your answer...
Still have questions?
magnify glass
Related questions

What is difference between server mainframes?

what is difference between server & mainframes

What is the difference between the client and the server?

what is the difference between server and client computer

What is difference between host and server?

host and server are same

What is the difference between a preferred DNS server and an altenate DNS server?

What is the difference between a preferred DNS server and an altenate DNS server?Read more:

What is difference between client server and web server?

they all have a male part.

What is the difference between server and domains?

The difference between the server and domains is fairly simple. The server is the system on which the entire functions rest, and the domains are pages within that system. Imagine the server as a neighborhood and domains as houses.

What is the difference between the dumb and intelligent terminals?

Dump Terminal is just activate the server function but there is no separate function in own terminal (not autonomous)ButIntelligent Terminal is having autonomous and also client function

What is the difference between a host and a server?

Same thing.

What is difference between a firewall and ISA server?


What is the difference between client and member server?

client is share to data storage in server

What is a server's physical case?

what is the difference between a server physical case and a client case

What is the difference between normal system and server?

A server is used for file storage and website hosting.

People also asked

In Latin America the Maya and the Aztec civilizations were similar that they?

View results