Path: csiph.com!x330-a1.tempe.blueboxinc.net!usenet.pasdenom.info!aioe.org!eternal-september.org!feeder.eternal-september.org!mx04.eternal-september.org!.POSTED!not-for-mail From: Erland Sommarskog Newsgroups: comp.databases.ms-sqlserver Subject: Re: Select affected rows Date: Tue, 7 Feb 2012 12:54:01 +0000 (UTC) Organization: Erland Sommarskog Lines: 15 Message-ID: References: <93b61b75-3623-40cb-943e-84afb1451403@dp8g2000vbb.googlegroups.com> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Injection-Date: Tue, 7 Feb 2012 12:54:01 +0000 (UTC) Injection-Info: mx04.eternal-september.org; posting-host="G7+Jz22XqYCG8C6rb1H3YA"; logging-data="7304"; mail-complaints-to="abuse@eternal-september.org"; posting-account="U2FsdGVkX18W+tuzOSbfQpN+/yTCtPBo" User-Agent: Xnews/2005.10.03 Mime-proxy/1.4.c.4 (Win32) Cancel-Lock: sha1:SFmcqqJfr5Q6bmiXzGR1g/v0SQA= Xref: x330-a1.tempe.blueboxinc.net comp.databases.ms-sqlserver:927 Bob Barrows (reb01501@NOSPAMyahoo.com) writes: > It depends on the version of SQL Server you are using. SQL 2008 introduced > the OUTPUT clause that you can read about here: > http://msdn.microsoft.com/en-us/library/ms177564.aspx The OUTPUT clause was added in SQL 2005. -- Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se Books Online for SQL Server 2005 at http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx Books Online for SQL Server 2000 at http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx