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 is a trace frag?
What are the new features of sql server 2008 r2 reporting service?
what is an extended stored procedure? Can you instantiate a com object by using t-sql? : Sql server database administration
your sql server is running out of disk space. You notice that there are several large files with ldf extensions what are these files? : Sql server administration
How do I delete a sql server database?
Can a trigger be created on a view?
How do you rename a table in sql server?
Write an SQL query to obtain the 2nd highest salary.
How would you choose between a clustered and a non-clustered index?
How to set the current database in ms sql server?
What happens if you delete a table that is used by a view?
How to use subqueries with the in operators in ms sql server?
What is the process of normalization?
What are drilldown reports?
I have all the primary data files, secondary data files as well as logs. Now, tell me can I still restore the database without having a full backup? : sql server database administration