can we call stored Procedure in Function in Sql Server 2000
and vice versa.
- 3 Answers
- 18111 Views
- C3I, eSoft, iPRO Solutions, Wipro, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / rvs varma
Its not possible to call sp's in function but viceversa is
possible
| Is This Answer Correct ? | 63 Yes | 6 No |
We cannot call Procedure from the Function
We can call the Procedure From the Procedure as
EXEC ProcedureName
@Parameter1 = "Para1"
@Parameter2 = "Para2"
@Parameter3 = @Val OUTPUT (Use when there is Output in the Procedure)
| Is This Answer Correct ? | 6 Yes | 1 No |
difference between sql server2000 and sql server2005
How do you send email on SQL Server?
Tell me what is the significance of null value and why should we avoid permitting null values?
How to see existing views in ms sql server?
How to Update from select query in sql server?
How to disable triggers using "disable trigger"?
What are the different types of backups avaialabe in sql server 2005?
Do you know what are the restrictions applicable while creating views? : SQL Server Architecture
What is Data model and how to prepare a data model.?
How will you decide the active and passive nodes?
What is the system function to get the current user's user id?
what is mean by constraints in sql?
-
Oracle (3239) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3312)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1391)
- Databases AllOther (288)
