freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

[freetds] INSERT with OUTPUT clause

From: mgrosman AT pathcom.com
To: freetds AT lists.ibiblio.org
Subject: [freetds] INSERT with OUTPUT clause
Date: Thu, 01 Apr 2010 13:04:50 -0400

Hi,
I tried a statement like this: INSERT INTO test (char, real, int) output INSERTED.real, INSERTED.int values(1, 5.4, 333)

DB is MS SQL 2005. With TDS version 8.0 (or 7.0) it doesn't return anything, but if I set TDS version to 4.6 or 4.2 it does return a resultset with two columns and one row as it is supposed to.

Was something broken in the latest TDS protocols?

Thanks,
Mike

[freetds] INSERT with OUTPUT clause, mgrosman, 04/01/2010
- Re: [freetds] INSERT with OUTPUT clause, James K. Lowden, 04/01/2010
  - Re: [freetds] INSERT with OUTPUT clause, Mikhail Grosman, 04/02/2010