Difference between Function and Stored Procedure?
- 9 Answers
- 18967 Views
- C1 India, NA, I also Faced
- E-Mail Answers
Answer Posted / arvind kumar
1-Function can not return the value but store procedure
return value
2-Store procedure is pree-compile statement but function is
not pree-compile satement.
3 function fallowed by select statement but store procedure
fallowed select, insert,update statement.
| Is This Answer Correct ? | 2 Yes | 40 No |
Post New Answer View All Answers
What are unicode character string data types in ms sql server?
How the authentication mode can be changed?
What is the difference between the 2 operating modes of database mirroring?
What is row_number()?
Can you explain how long are locks retained within the repeatable_read and serializable isolation levels, during a read operation with row-level locking?
What is the query and subquery?
How to create a Master database in SQL server ?
What does the not null constraint do?
What is data source view or dsv? : sql server analysis services, ssas
Explain throw statement in sql server 2008?
What is the cpu pressure?
How to override dml statements with triggers?
What is 1nf normalization form?
Do you know what are the restrictions applicable while creating views? : SQL Server Architecture
What is the maximum size of a row in sql server?
