Beefy Boxes and Bandwidth Generously Provided by pair Networks Cowboy Neal with Hat
Do you know where your variables are?
 
PerlMonks  

Re^3: pass MS SQL server scripts into Win32::ODBC

by mje (Deacon)
on Jan 24, 2013 at 09:36 UTC ( #1015121=note: print w/ replies, xml ) Need Help??


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.


Comment on Re^3: pass MS SQL server scripts into Win32::ODBC
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

Log In?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://1015121]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others scrutinizing the Monastery: (10)
As of 2014-04-17 04:03 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    April first is:







    Results (439 votes), past polls