What are the differences between stored procedure and
functions in SQL Server 2000?
Answer Posted / nazeema
Stored procedures can change server environment and our
operating system environment.
Function can not change server environment and our
operating system environment.
Stored procedures are stored in parsed and compiled format
in the database.
Functions are compiled and executed at run time.
Stored procedure return more than one value or Dataset.
Fuction can return a single value only.
error handling can be done in Stored procedure.
it not possible in function.
Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
Where in ms sql server is ’100’ equal to ‘0’?
How to send email from database?
Explain filestream storage of sql server 2008?
Where sql server user names and passwords are stored in sql server? : sql server database administration
What is impersonation? What are the different impersonation options available in ssas? : sql server analysis services, ssas
How to find Duplicate Records In table?
What is normalization and its types?
Is resultset an interface?
What is the most common trace flags used with sql server?
How to enable/disable indexes?
What is use of except clause? How it differs from not in clause?
Why de-normalization required?
What are the different Authentication modes in SQL Server and how can you change authentication mode?
explain what are the steps you will take, if you are tasked with securing an sql server? : Sql server database administration
Some queries related to SQL