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 the difference between function and stored procedure in sql server?
Which is best Subquery (or) joins in sql server? explain why
What is the use of group by clause?
How do I port a number to sql server?
How to list all user defined functions in the current database?
Do you know what is rank function?
Name 3 ways to get an accurate count of the number of records in a table?
What is merge join?
Tell me what is a linked server?
What is coalesce and check constraint in sql server?
how do we insert 100 records at a time in a table without using for loop in database
What is key attribute?
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)