Interested to Buy Any Domain ? << Click Here >> for more details...
Differnce between Stored procedure and user defined functions?
- 17 Answers
- 28100 Views
- Microsoft, Symphony, I also Faced
- E-Mail Answers
Answer Posted / sivacharan svs
Funtion Should Return a value
Procedure may or may not return a value
Function can be used in Your Select Quries
Procedure has to be passed with or with out parameters
Select Getdate() as date
Function returns date time here
The resultant value of the stored procedure can be used in
application where as the resultant value of the stored
procedure is used in a query.
| Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
What is the difference between Dataset. clone and Dataset.copy?
What are the different row versions available in table?
Where is adodb dll located?
What is sqldatareader?
Compare Data Reader & Dataset in ado.net?
Does sqlclient and oledb class share the same functionality?
Explain all the classes those are used for database connections between sql server and asp.net?
Which is faster entity framework or ado.net?
What is a sqldataadapter?
What is acid in ado.net?
oledbdataadpter with ms access in c#.net giving exception System.Data.OleDb.OleDbException while writing adapter.update(dataset,"tabname"); how to update the database from dataset?
How do you merge 2 datasets into the third dataset in a simple manner?
How can we save all data from dataset?
Explain how to bind the controls(best practice) comboboxes to the data in the dataset?
Which object is used to add relationship between two Datatables?
