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 is data integrity? Explain constraints?
What is correlated subquery in sql server?
How to disable a login name in ms sql server?
How adventureworkslt tables are related?
what is the maximum size of sql row in mssql?
What is a derived table?
What is the importance of three tier architecture?
What is a data source file?
What is rolap and its advantage? : sql server analysis services, ssas
How to update a field in SQL after ALTERING a row?
Explain cursor as data base object?
how to know description of a table in sqlserver 2000
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)