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 oltp (online transaction processing)?
in tabase table having a column in it empname field is there which having 5 duplicate values is there i want deleted all the duplicates i want showing only one name only.
How many partitions a clustered index has by default in sql server 2012?
how to know Who Is Blocking Your SQL Server?
What are the pre-defined functions in the sql server?
how to find maximum identity number in a table ?
2 Answers JPMorgan Chase, Thomson Reuters, Wipro,
Is foreign key unique?
What is difference between foreign key and unique key?
can we call functions from stored procedure in SQL Server 2005 ? How?
What is collation sensitivity? Explain different types.
what is statistics
How to enter date and time literals in ms sql server?
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)