can we call stored Procedure in Function in Sql Server 2000
and vice versa.
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 |
What changes in the front end code is needed if mirroring is implemented for the high availability? : sql server database administration
How do I setup a local sql server database?
Do you know what are acid properties of transaction?
How to call stored procedure using http soap?
What is scheduled job and how to create it?
as a part of your job, what are the dbcc commands that you commonly use for database maintenance? : Sql server database administration
how can i lock the column in the table
What is the maximum size of sql server database?
What is bit data type?
Define left outer join?
What is compound operators?
What is the maximum rows in sql server table?
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)