asranantha (4/9/2012)
1)can we call sp into another sp if yes plz give small example?if no plz tell me reason?2)can we call functionn into another function if yes plz give small example?if no plz tell me reason?
3)can we call sp in function?if yes plz give small exmp?if no plz tell me reason?
4)can we call function in sp?if yes plz give small examp?if no plz tell me reason?
Sounds like interview questions. If you don't the answer in an interview, just say "I don't know." If I'm interviewing you, I'll feel a lot better about an honest answer than to have you reading an answer from a web site that may or may not be true.
You can answer all these on your own with a tiny bit of experimentation.
1) Yes
2) Depends
3) Depends
4) Yes
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning