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

Answer Posted / rvs varma

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

Is This Answer Correct ?    63 Yes 6 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the difference between nvl and nvl2?

549


What is the difference between resultset and resultsetmetadata?

515


How to loop through result set objects using odbc_fetch_row()?

467


What is transaction server isolation?

575


Will the writetext statement activate a trigger?

566






Explain system scalar functions?

574


1.how to find the dead lock in sql server? 2.How to fine the memory leaks in sql server? 3.suppose transaction log file increasing what action will take ?

1550


mention different types of relationships in the dbms?

503


Describe in brief databases and sql server databases architecture.

524


How to select all columns of all rows from a table with a select statement in ms sql server?

571


What is optimistic concurrency?

562


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

509


When does the auto update index statistics feature in sql server turn itself on?q) what specific conditions database should meet, before you can bulk copy data into it using bcp?

574


What is the maximum size of sql server database?

503


Explain what are magic tables in sql server?

535