Differences between functions and stored procedures?

Answer Posted / gautam

function does have update or delete statment.

Is This Answer Correct ?    3 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to change the name of a database user?

554


Explain use of expression builder.

571


How to create function with parameter in sql server?

560


Can we use where and having clause together?

514


What should be the fill factor for indexes created on tables? : sql server database administration

633






how to control the amount of free space in your index pages? : Sql server database administration

602


How do I repair damaged sql server mdf file database? In previous day my mdf file has got damage due to unknown reasons then I used dbcc chekcdb command but it failed, MDF file is important for me, I don’ know that how to get back mdf file data. Please anyone suggest me?

1303


What are distributed partitioned views?

627


What is surrogate key? : sql server analysis services, ssas

701


How to loop through result set objects using mssql_fetch_array()?

547


Explain what is the use of custom fields in report?

504


What method is used by the Command classes to execute SQL statements that return single values?

606


What is the contrast between sql and mysql?

594


how do you implement one-to-one, one-to-many and many-to-many relationships while designing tables? : Sql server database administration

588


What are the differences between local and global temporary tables?

562