Difference between Function and Stored Procedure?
Answer Posted / sreyasmn
1. Function must returned a value,but stored procedure is
not necessorly returned value
2. A function can be used to calculations,but sp used to
solve a business logic
Is This Answer Correct ? | 36 Yes | 3 No |
Post New Answer View All Answers
How many types of local tables are there in sql server?
What is data set in report?
How many clustered indexes there can be on table ?
what is difference between NULL and ISNULL in SQL Server 2008?
How to generate create function script on an existing function?
Explain about merge replications?
How to use clusters?
What command is used to rename the database?
What are the advantages of using cte?
What is failover clustering overview?
How to include date and time values in sql statements?
Hi, I Created 3 Tables Person(PersID[prkey],Name,Email,Password), Project(ProjName,ProjID[prkey],ProjLeader,ProjManager) & ProjectInvolvement(EntryDate,ProjID[frkey],PersID[frkey],ProjDuration). For this how can i INSERT,UPDATE & DELETE Through PROCEDURE? Please Post the Answer for me. Desai.
How to delete a login name in ms sql server?
Do you know what is blocking?
Explain the cursor lock types?