can we call stored Procedure in Function in Sql Server 2000
and vice versa.
- 3 Answers
- 18143 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 |
I have a table in which phno is one of the columns.i do have some values in tht phno column.i need to update phno column values with 0(zero) as prefix.give me a correct solution plz...
How real and float literal values are rounded?
what is procedure in sql?
How to search for a string in all stored procedure in sql server?
Explain stored procedure?
how we use window authentication connection with sql server.?
What is openrowset sql server?
How to delete an existing row with delete statements in ms sql server?
What is an index in a database?
How to modify existing triggers using "alter trigger"?
If we drop a table, does it also drop related objects like constraints, indexes, columns, defaults, views, and stored procedures?
How to transfer an existing table from one schema to another schema in ms sql server?
-
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)
