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 use of @@ spid in sql server?
Difference between report and query parameter. Why do we need different type of parameter?
how to rest identity columns in sql server
To find second largest salary in Employee table
Describe in brief databases and sql server databases architecture.
What are synonyms?
How do I save a stored procedure in sql server?
What is the default sql server instance name?
Do you know clustered and non-clustered index?
What is SCOPE_IDENTITY() in sql
Is candidate a key?
What is store procedure? How do they work? When do you use?
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)