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


Please Help Members By Posting Answers For Below Questions

Can we take the full database backup in log shipping?

523


What is isnull() operator?

542


What is ms sql server service broker?

494


What is a deadlock and what is a live lock?

556


What is ddl command?

509






List out different types of normalizations in sql server and explain each of them?

534


Difference between 2NF &3NF ?

658


what is a correlated sub-query? : Sql server database administration

463


what is bit datatype and what's the information that can be stored inside a bit column? : Sql server database administration

508


What is difference between temp table and cte?

515


What is a data source file?

471


What is the contrast amongst drop and truncate?

536


Explain the usage of floor function in sql server.

486


Does sql server use t sql?

496


Define Joins?

579