I connect to MSSQL via ODBC, exist some method to get last inserted
id? I read in DBI docs:
For some drivers the value may only be available if placeholders have
not been used (e.g., Sybase, MS SQL). In this case the value returned
would be from the last non-placeholder insert statement.
So I will to have using "select max($field) from $table" 'method' ?
Re: last_insert_id() / MSSQL ... > I connect to MSSQL via ODBC, exist some method to get last inserted ... I read in DBI docs:... > For some drivers the value may only be available if placeholders have ...Sybase DBA/Developer... (perl.dbi.users)
Re: Diff type of data fetching ... ODBC and OLE DB are two different sets of commands and functions as drivers... for connections to client/server SQL databases....ODBC is an industry standard supported by Microsoft; ... MS thought their OLEDB classes would make ODBC obsolete but they have had ... (microsoft.public.fox.programmer.exchange)
Re: Diff type of data fetching ... drivers for connections to client/server SQL databases....ODBC is an industry standard supported by Microsoft; ... MS thought their OLEDB classes would make ODBC obsolete but they have had ...OLEDB permits calling ODBC drivers but this is now a deprecated usage as ... (microsoft.public.fox.programmer.exchange)
Re: ODBC connection to mdb for MacIntosh ... > Microsoft Access does not exist for the Mac.... As long as the computer has ODBC drivers for an Access ... You can use the MS Query interface to create any SQL command... (microsoft.public.mac.otherproducts)
Re: End-user software to query a warehouse? ... > worked, using ODBC, but now I'm battling a slightly different battle, with ... It really sucks that "ordinary" ODBC client... applications can query the DB2 no problems, but when SQL Server... with the API functions it uses to talk to IBM's drivers.... (microsoft.public.sqlserver.datawarehouse)
