Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / jayanth
Functions always returns a value where as sp performs bath execution
functions can be used along with select statement and where clause where as functions cannot be used with update insert delete statements in which sp cannot be used with select and DML events
functions cannot be used with try catch block where as sp can use try catch block
functions are of two types system functions and user defined functions where as sp's are four types mostly
sp with parameters
sp without parameters
sp with out parameters
sp with return values
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is Service Broker in sql server 2012?
Why use cursor in sql server?
how to determine the service pack currently installed on sql server? : Sql server database administration
What is indexing in sql server with example?
What is the definition for sql server 2000?
How does index makes search faster?
What is nonclustered index with included columns ?
What are the benefits of normalization?
What are the different types of upgrades that can be performed in sql server?
If the job running very slow what is the action you do
You have a table ‘test’ which is a copy of northwind employee table you have written a trigger to update the field ‘hiredate’ with the current date
Explain what is lock escalation and what is its purpose?
You notice that the transaction log on one of your databases is over 4gb the size of the data file is 2mb what could cause this situation, and how can you fix it?
What is a partition function in sql server?
What are triggers? How many triggers you can have on a table? How to invoke a trigger on demand?
