Differences between functions and stored procedures?
Answer Posted / purushotam bhardwaj
FUnction use when you want to return any value only
but SP is best for all
Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
How many types of subqueries are there in sql server?
How to view existing indexes on an given table using sp_help?
When does the auto update index statistics feature in sql server turn itself on?q) what specific conditions database should meet, before you can bulk copy data into it using bcp?
what is an extended stored procedure? : Sql server database administration
what is database replication? : Sql server database administration
What is scheduled job and how to create it?
What is used to replicate sessions between instances in coldfusion clusters?
What is system stored procedures?
What will happen if a column containing char type data is changed to the nchar data type?
What does truncate do?
can a table be moved to different filegroup? : Sql server administration
Why use update_statistics command in sql server?
How do you delete a data source?
When you should use a low fill factor?
Is it ok to shrink transaction log?