I'm toying with the idea of using a perl script to generate triggers in my
SQLserver database.
First, is this a reasonable idea?
If it's reasonable to build triggers this way, what escaping do I need to do
to get the following create trigger statement to work? It currently fails
complaining abou
Roger,
Thank you v. much. This is exactly the info I was looking for.
Rgds,
Brien
-Original Message-
From: Roger Perttu
To: Brien Pirkle; '[EMAIL PROTECTED] '
Sent: 28/11/02 16:47
Subject: Re: Calling SQLServer Stored Procedures
Brien Pirkle wrote:
>Jeff,
>
>
str;
{call sp_foo}
#
Rgds,
Brien
-----Original Message-
From: Jeff Urlwin
To: Brien Pirkle; [EMAIL PROTECTED]
Sent: 28/11/02 14:55
Subject: RE: Calling SQLServer Stored Procedures
>
> How can I execute a SQL Server stored proc from my Perl script?
> Th
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?
My platform is NT, ActivePerl 633...database is SQLServer2000.
TIA,
Bri
Hope this isn't too simple a question.but I can't find an example in my
"Programming the Perl DBI"...platform is NT, ActivePerl 633...database is
SQLServer2000, connection is DBI:ODBC
When I select the max (id) from table where status = 'U'
and there aren't any records with a status of 'U', t
