can we call stored Procedure in Function in Sql Server 2000
and vice versa.
- 3 Answers
- 18147 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
Sql server reporting services vs. Crystal reports.
What is reference section?
Can you explain what is indexed view? How to create it?
What are magic tables in sql server?
Can you give me some DBCC command options?(Database consistency check) - DBCC CHECKDB - Ensures that tables in the db and the indexes are correctly linked.and DBCC CHECKALLOC - To check that all pages in a db are correctly allocated. DBCC SQLPERF - It gives report on current usage of transaction log in percentage. DBCC CHECKFILEGROUP - Checks all tables file group for any damage.
How to find related tables in sql server?
How do you open a cluster administrator?
How you can change the database name in SQL SERVER?
How is table type constraint applied to a table?
What are transactions and its controls?
What Is Rdbms?
How many joins in sql server?
What is the log shipping?
What are the advantages to use stored procedures?
what are different types of backups available in sql server? Given a particular scenario, how would you go about choosing a backup plan? : Sql server database administration
