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

Answers were Sorted based on User's Feedback



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

Answer / rvs varma

Its not possible to call sp's in function but viceversa is
possible

Is This Answer Correct ?    63 Yes 6 No

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

Answer / swathi

no we cannot call sp in a function

Is This Answer Correct ?    28 Yes 3 No

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

Answer / 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

More SQL Server Interview Questions

What is use of @@ spid in sql server?

1 Answers  


Difference between report and query parameter. Why do we need different type of parameter?

1 Answers  


how to rest identity columns in sql server

3 Answers   Matrix,


To find second largest salary in Employee table

17 Answers   CSS,


Describe in brief databases and sql server databases architecture.

1 Answers  


What are synonyms?

1 Answers  


How do I save a stored procedure in sql server?

1 Answers  


What is the default sql server instance name?

1 Answers  


Do you know clustered and non-clustered index?

1 Answers  


What is SCOPE_IDENTITY() in sql

4 Answers   Cap Gemini,


Is candidate a key?

1 Answers  


What is store procedure? How do they work? When do you use?

1 Answers  


Categories