We cannot call Procedure from the Function We can call the Procedure Fr

can we call stored Procedure in Function in Sql Server 2000
and vice versa.

Question Posted / mohammad ali

3 Answers
19545 Views
C3I, eSoft, iPRO Solutions, Wipro, I also Faced
E-Mail Answers

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 the federation in sql azure?

What are locks in sql?

980

How to create a view and a stored procedure in ms sql server using "create view/procedure" statements?

1009

how can u get last observation in an unknown dataset ?

2436

What is NOT NULL Constraint in sql server 2012?

1000

What is system stored procedures?

1040

Difference between connected and disconnected database in .net with sql server?

1095

What are the different types of stored procedures?

1117

What is query optimizer in sql server?

1020

What is replace and stuff function in sql server?

1065

How to backup encryption key ?

182

Why use triggers?

1014

Why is normalisation important?

942

What is application role in sql server database security? : sql server security

1057

What is standby servers? Explain types of standby servers.

995