<?xml version="1.0" encoding="utf-8"?>
<rss version="2.0" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:atom="http://www.w3.org/2005/Atom">
	<channel>
		<title>OUTPUT command in MSSQL 2005</title>
		<description>Discuss OUTPUT command in MSSQL 2005</description>
		<link>https://selectsql.com/mssql/output-command-in-mssql-2005.html</link>
		<lastBuildDate>Wed, 08 Apr 2026 02:09:23 +0000</lastBuildDate>
		<generator>JComments</generator>
		<atom:link href="https://selectsql.com/jcomments/rss/com_content/5" rel="self" type="application/rss+xml" />
		<item>
			<title>Harish says:</title>
			<link>https://selectsql.com/mssql/output-command-in-mssql-2005.html#comment-28</link>
			<description><![CDATA[ You can store the result set returned from the update command in table as shown below: UPDATE Companies SET CompanyName = 'New name' OUTPUT inserted.Compan yName, deleted.Company Name, inserted.ID into @table WHERE ID = 3]]></description>
			<dc:creator>Harish</dc:creator>
			<pubDate>Wed, 07 Jul 2010 14:28:44 +0000</pubDate>
			<guid>https://selectsql.com/mssql/output-command-in-mssql-2005.html#comment-28</guid>
		</item>
		<item>
			<title>masmas says:</title>
			<link>https://selectsql.com/mssql/output-command-in-mssql-2005.html#comment-20</link>
			<description><![CDATA[your are beeest]]></description>
			<dc:creator>masmas</dc:creator>
			<pubDate>Wed, 05 Aug 2009 12:56:55 +0000</pubDate>
			<guid>https://selectsql.com/mssql/output-command-in-mssql-2005.html#comment-20</guid>
		</item>
		<item>
			<title>Stanislav Duben says:</title>
			<link>https://selectsql.com/mssql/output-command-in-mssql-2005.html#comment-11</link>
			<description><![CDATA[Hi Christopher, this is pretty simple. You can use syntax OUTPUT ... INTO ... See my example here: UPDATE test SET test='example test' OUTPUT deleted.id, deleted.test INTO test2 (id, test2) WHERE id]]></description>
			<dc:creator>Stanislav Duben</dc:creator>
			<pubDate>Thu, 10 Jan 2008 09:05:58 +0000</pubDate>
			<guid>https://selectsql.com/mssql/output-command-in-mssql-2005.html#comment-11</guid>
		</item>
		<item>
			<title>Christopher says:</title>
			<link>https://selectsql.com/mssql/output-command-in-mssql-2005.html#comment-12</link>
			<description><![CDATA[got one question.. ^^ what if i want to store the result returned by the "OUTPUT", and not just sending it to client.. ex is i want the OUTPUT result to be inserted to a variable table?.. if you know how, please let me know.. thanks.. peace out... ^^]]></description>
			<dc:creator>Christopher</dc:creator>
			<pubDate>Wed, 09 Jan 2008 02:00:16 +0000</pubDate>
			<guid>https://selectsql.com/mssql/output-command-in-mssql-2005.html#comment-12</guid>
		</item>
		<item>
			<title>FAISAL says:</title>
			<link>https://selectsql.com/mssql/output-command-in-mssql-2005.html#comment-4</link>
			<description><![CDATA[i never know about this before, this a simple code but so informative thanks a bunch Stanislav Duben!]]></description>
			<dc:creator>FAISAL</dc:creator>
			<pubDate>Wed, 26 Sep 2007 06:24:40 +0000</pubDate>
			<guid>https://selectsql.com/mssql/output-command-in-mssql-2005.html#comment-4</guid>
		</item>
	</channel>
</rss>
