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)
 Stored procedure from a stored procedure?

Author  Topic 

isamu_dyson
Starting Member

2 Posts

Posted - 2002-09-15 : 20:44:28
Hi, im scheduling a sql job and i want the stored procedure to call another one, im not sure on the exact syntax, i cant find anything anywhere on this either!.

ack!

Merkin
Funky Drop Bear Fearing SQL Dude!

4970 Posts

Posted - 2002-09-15 : 21:33:12
Exec MyOtherStoredProc @Param1 = 1, @Param2 = @MyLocalVariable

Damian
Go to Top of Page

rihardh
Constraint Violating Yak Guru

307 Posts

Posted - 2002-09-16 : 04:38:07
YOU CAN FIND IT IN BOOKS ONLINE ("BOL" for insiders)!!!

Comes free with every MSSQL server!

Go to Top of Page

Onamuji
Aged Yak Warrior

504 Posts

Posted - 2002-09-16 : 08:25:55
it's also a free download last time i checked

Go to Top of Page
   

- Advertisement -