Differences between functions and stored procedures?
- 8 Answers
- 14032 Views
- 247Customer, Accenture, I also Faced
- E-Mail Answers
Answer Posted / paras
UDF
1. Must return a value – a single result set
2. Directly used in select, order by,where, from
3. UDF can’t use nondeterministic function Such as
getdate(), rand()
4. Can’t change server enviroment variables
5. Stops execution of T-SQL code when error occurs
6. Can’t use temp table in UDF
Stored Procedure
1. Can return value – multiple result set
2. Can’t use in select
3. Can use nondeterministic functions
4. Can change server enviroment variables
5. Stored procedure move to the next instruction if you used
proper error handling,
6. Can use temp table in SP
| Is This Answer Correct ? | 6 Yes | 2 No |
Post New Answer View All Answers
What are the types of lock supported by ?
Explain magic tables in sql server?
Name few endpoints exposed by ssrs 2012?
Can a function call a stored procedure in sql server?
How we create SQL Server 2005 Reporting Services ? Give me Sample
What are the filtered indexes?
What happens to a trigger with multiple affected rows?
What are pages and extents? : SQL Server Architecture
What is amo? : sql server analysis services, ssas
Which autogrowth database setting is good?
how to take backup bcp out for a column in table in sql server?
What is nolock hint in sql server 2008
What are the elements of dbms?
You have several tables, and they are joined together for querying. The tables contain both clustered indexes and non clustered indexes to optimize performance, how should you distribute the tables and their indexes onto different file groups?
what is a join? : Sql server database administration
