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 |
Is it possible to delete duplicate rows in a table without using a temporary table ?
What is a periodical index?
Does windows server 2016 come with sql server?
Can anybody explain me cold backup and hot backup?
What is mapping schema?
How to set the current database in ms sql server?
What is side by side migration in sql server?
What are the differences between stored procedure and view in sql server?
A left outer join B B right outer join A gives the same result then what is the use of two?
What is the Main Difference between ACCESS and SQL SERVER?
Explain indexed views and partitioned view with their syntax.
How to delete particular value in the column of a table.Is it possible or not?if possible give it as in query.
Oracle (3253)
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)