Interested to Buy Any Domain ? << Click Here >> for more details...
Differences between functions and stored procedures?
- 8 Answers
- 15366 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 encryption mechanisms in sql server?
after migrating the dts packg to ssis by using migrtn wizrd in 2005. iam not able to open ssis pack and getting error. what r those errors? how to resolve?
What is subreport?
How to connect of datebase with sql express.?
what are constraints? : Sql server database administration
You want your report to display a hyperlink that will take users to your intranet. How do you configure such a hyperlink?
Define self join in sql server joins?
Where the sql logs gets stored?
What are exact numeric data types in ms sql server?
What is the minimum and maximum number of partitions required for a measure group? : sql server analysis services, ssas
What is onf in normalization form?
What is key attribute?
Can you explain various data region available in ssrs with their use?
What is subquery explain with example?
What is the fastest way to permanently delete a 1 million row table named customers?
