Interested to Buy Any Domain ? << Click Here >> for more details...
Differences between functions and stored procedures?
- 8 Answers
- 15683 Views
- 247Customer, Accenture, I also Faced
- E-Mail Answers
Answer Posted / avinash
1. Functions can used with Select statement
SP are not
2. If we have a syntax error or bug in SP it ignore it at
execution. In case of Function it won't.
3. Function should return atlease one value.
SP may or maynot return values.
4. Function cannot include in other function.
We can execute one SP in other.
| Is This Answer Correct ? | 9 Yes | 4 No |
Post New Answer View All Answers
What is the name of reporting services config file and what’s it’s used for?
What is a transaction and why is it important?
How do you Implement SSIS Packages in your Project?
What is a system database and what is a user database?
Explain the usage of floor function in sql server.
What are the advantages of policy management?
What are system databases in ms sql server?
How can sql server instances be hidden? : sql server security
Explain the difference between delete,drop and truncate in SQL Server?
How to create new table with "create table" statements?
How do you use a subquery to find records that exist in one table and do not exist in another?
How to get a list of columns in a view using the "sp_columns" stored procedure?
What are the advantages of paper records?
Explain about temporary stored procedure?
You want to check the syntax of a complicated update sql statement without executing it. What command should you use?
