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.
what is difference between server & mainframes
what is the difference between server and client computer
host and server are same
What is the difference between a preferred DNS server and an altenate DNS server?Read more: http://wiki.answers.com/What_is_the_difference_between_a_preferred_DNS_server_and_an_altenate_DNS_server#ixzz2LRd3ICed
they all have a male part.
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.
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
client is share to data storage in server
what is the difference between a server physical case and a client case
A server is used for file storage and website hosting.