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 objects does the fn_my_permissions function reports on? : sql server security
How to stop log file growing too big?
How do I save a stored procedure in sql server?
What will be query used to get the list of triggers in a database?
ow to bring suspect mode datbase online from scratch
What is the maximum row of a size?
What triggers long term care?
You are creating an application where users are asked their gender in the gender combo box you have three options: ‘male’ , ‘female’ and ‘i choose not to disclose’ these options are stored in the table as 1, 0 or null which datatype should you use?
Explain what is the purpose of sql profiler in sql server?
how can you find out if the current user is a member of the specified microsoft® windows nt® group or microsoft sql server™ role? : Sql server administration
Difference between report and query parameter. Why do we need different type of parameter?
Explain the disadvantages/limitation of the cursor?
Explain the categories of stored procedure?
What is sql injection and why is it a problem? : sql server security
What is a full text index?