http://www.perlmonks.org?node_id=1015121


in reply to Re^2: pass MS SQL server scripts into Win32::ODBC
in thread pass MS SQL server scripts into Win32::ODBC

Some of these statements are transact-SQL and cannot be used over ODBC in the way you are doing it. You could create a procedure over ODBC which can use t-sql statements.

Of course, I'm presuming there is more to the script than what you posted as it is effectively just a select statement.

Replies are listed 'Best First'.
Re^4: pass MS SQL server scripts into Win32::ODBC
by Anonymous Monk on Jan 24, 2013 at 18:04 UTC

    Thank You Both.

    I didn't realize the limitation of ODBC and transact statements

    I appreciate the advise and comments/guidance