Interested to Buy Any Domain ? << Click Here >> for more details...
what is the difference between procedure and function.
- 4 Answers
- 8819 Views
- Thomson, I also Faced
- E-Mail Answers
Answer Posted / saurav kumar
1) Inside Stored procedure we can write functions but
inside function we can't write Stored procedures.
2) Stored proedure may or may not return a value but
function must return a value.
3) Stored Procedures can be called independently using exec
keyword ,Function are called using select statement.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is measure group, measure? : sql server analysis services, ssas
is there a column to which a default can't be bound? : Sql server database administration
How to create a stored procedure with a statement block in ms sql server?
What are ddl triggers and types of ddl trigger?
What is exporting utility?
What are the differences between sql server and mysql.
Why is sql server log file full?
What area unit the various kinds of info compression introduced in sql server 2008?
List the various tools available for performance tuning?
Does sql server 2016 have ssms?
How network traffic be reduced by using the stored procedure?
How you can move data or databases between servers and databases in sql server?
Explain syntax for dropping triggers?
Explain what is sql server english query?
How many databases Microsoft SQL server provides?
