Differences between functions and stored procedures?

Answer Posted / manoj pandey

Check following blog post for difference between UDF & Stored Procedures: http://sqlwithmanoj.wordpress.com/2011/09/21/stored-procedures-vs-functions-difference-between-sp-udf/

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are trace flags?

598


What are the steps you must follow to hide sql server instances?

541


What are the common performance issues in sql server?

505


What is delete query?

524


If we delete pack Spec what will be the status of pack Body ?

970






Mention a few common trace flags used with sql server?

544


What is the dbcc command and why is it used?

573


What are the basic functions for master, msdb, model, tempdb and resource databases? : SQL Server Architecture

567


What are “lock” hints?

593


Can a synonym name of a table be used instead of a table name in a select statement?

580


How to insert a new row into a table with "insert into" statements in ms sql server?

536


What are window functions in sql server?

513


What is unique key constraint?

633


What is the meaning of resultset type_scroll_insensitive?

565


what do you understand by change data capture?

560