functions and procedures

1. Functions in procedure:- Yes this is possible. You can call the functions in your store procedures. You will call functions like normal select statement. E.g.: select * from function_name.
2. Procedure call in function:- No, this is wrong. You can not call procedure in your functions.

Hope this will clear your idea. Happy coding.

Sanhtech, if this helps please login to Mark As Answer. | Alert Moderator

why it is possible in procedure and not in functions?

Sanhtech, if this helps please login to Mark As Answer. | Alert Moderator

No Idea. You can search on google for this.

Sanhtech, if this helps please login to Mark As Answer. | Alert Moderator

>Generally stored procedures can do almost anything. So it is safer to disallow them

>The engine can't reliably work out what your stored procedure does
What about nesting of stored procedures, or recursion, or linked server calls or OPENQUERY calls, and many many other things

>What if someone change it later to do some writes?
You can't schema-bind a UDF to a stored procedure

This is how SQL Server behaves for good reasons

http://hashtagakash.wordpress.com/

Sanhtech, if this helps please login to Mark As Answer. | Alert Moderator