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


Please Help Members By Posting Answers For Below Questions

What is a trace frag?

644


What are the new features of sql server 2008 r2 reporting service?

110


what is an extended stored procedure? Can you instantiate a com object by using t-sql? : Sql server database administration

588


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

573


How do I delete a sql server database?

549






Can a trigger be created on a view?

575


How do you rename a table in sql server?

490


Write an SQL query to obtain the 2nd highest salary.

611


How would you choose between a clustered and a non-clustered index?

545


How to set the current database in ms sql server?

534


What happens if you delete a table that is used by a view?

565


How to use subqueries with the in operators in ms sql server?

566


What is the process of normalization?

558


What are drilldown reports?

86


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

680