can we call stored Procedure in Function in Sql Server 2000
and vice versa.
Answer Posted / mohammad ali
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 |
Post New Answer View All Answers
What do you mean by sql server agent?
What are dml triggers and types of dml triggers?
Explain about extended stored procedure?
How does index makes search faster?
To automatically record the time on which the data was modified in a table, which data type should you choose for the column?
What are the advantages of user-defined functions over stored procedures in sql server?
Tell me what is difference between view and materialized view?
What are the export options of ssrs?
Would you store your query in a ssrs report or a database server? State the reason why?
What is bulkcopy in sql?
How much is a sql server license?
What are pessimistic lock and optimistic lock?
What are key, name and value columns of an attribute? : sql server analysis services, ssas
What is a dataset and what are the different types of datasets?
How do I start sql server agent automatically?