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

Is truncate autocommit?

563


How to select an exiting database using mssql_select_db()?

509


What happens if null values are involved in string operations?

558


What is explicit mode in sql server?

532


when you create a database how is it stored? : Sql server database administration

494






How will you decide the active and passive nodes?

639


What is the difference between varchar and varchar types?

564


Give a example to search fr a string in all stored procedure in sql server.

532


What are secondary xml indexes?

564


What are the properties of the transaction?

543


if no size is defined while creating the database, what size will the database have? : Sql server administration

546


Tell me about builtinadministrator?

562


What guidelines should be followed to help minimize deadlocks?

502


Do you know spatial data types - geometry and geography in sql server 2008?

576


Why use “pivot” in sql server?

625