Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between a stored procedure and a user
defined function in sql server?
- 2 Answers
- 7836 Views
- Millennium, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / kumar.t
1. Stored Procedure to return the output parameter.
but function only return single values no output
parameter.
2. Select Clause we cann't use stored procdure. but
fucntion we can use.
3. XMl Clause contain we can use stored procdure. but
function we cann't use.
4. Whenever to execute function at present any error in the
function automatically to exit from the function. but
stored procudure to ignore the error then go to next line.
By
Kumar.T
| Is This Answer Correct ? | 5 Yes | 1 No |
Answer / samant
1.For user defined function one must have to specify it's
return type while in stored procedure it is not mandatory.
2. u can use function in expression but not stored
procedures
| Is This Answer Correct ? | 3 Yes | 0 No |
What is optimistic concurrency?
What command is used to rename the database?
What is query optimization process?
What are .mdf files?
What is the difference between ROW_NUMBER and Ranking function in SQL SERVER?
What are commonly used odbc functions in php?
one table has four field id,name,design,salary. i have to find maximum salary .
How to enter date and time literals in ms sql server?
What is the difference between dbcc indexdefrag and dbcc reindex?
can an automatic recovery be initiated by a user? : Sql server administration
In what sequence sql statement is processed?
What is a join in sql?
-
Oracle (3259) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3330)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
