Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 Transact-SQL (2000)
 question

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2006-07-11 : 11:18:18
chandra writes "how do i call a stored procedure in stored procedure in sqlserver"

RyanRandall
Master Smack Fu Yak Hacker

1074 Posts

Posted - 2006-07-11 : 11:21:24
No differently from normal - using EXEC. e.g. EXEC mySP 1, 'abc'

What are you trying to do?


Ryan Randall
www.monsoonmalabar.com London-based IT consultancy

Solutions are easy. Understanding the problem, now, that's the hard part.
Go to Top of Page

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2006-07-12 : 02:47:27
Note that you cant directly access the data returned from inner procedure until you move them to temp table

Madhivanan

Failing to plan is Planning to fail
Go to Top of Page
   

- Advertisement -