1. Categories >> Software >> Databases >> SQL Server
  2. Suggest New Category

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

Question Posted / mohammad ali

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

Explain what is cte (common table expression)?

712

How do I shrink an ldf file?

654

Explain the working of sql privileges?

720

What is the need for indexing?

578

What is db stored procedure?

541




What is the return type of executeupdate ()?

623

What is the difference between local and global temporary tables?

682

What is a db view?

609

What are the different types of backups avaialabe in sql server 2005?

703

Explain data warehousing in sql server?

692

What is a rollup clause?

624

Is it possible for a stored procedure to call itself or recursive stored procedure? How many levels of sp nesting are possible?

576

What are the different normalization forms?

716

What is command parameter in ssrs?

130

How to list all user names in a database?

669