> > How can I execute a SQL Server stored proc from my Perl script? > The Cheeta > book (DBD::ODBC Driver pg 296) suggests using the following ODBC escape > sequence: > > {call procedure1_name} > > Fine. But what's the rest of the syntax?
Err, that is the syntax. If your procedure name is sp_foo, then: {call sp_foo} If your procedure takes parameters: {call sp_foo(1, 2, 3)} etc. > > My platform is NT, ActivePerl 633...database is SQLServer2000. > Jeff