Groups > comp.databases.ms-sqlserver > #737

Re: trying to replace multiple update statements with one update

From	Erland Sommarskog <esquel@sommarskog.se>
Newsgroups	comp.databases.ms-sqlserver
Subject	Re: trying to replace multiple update statements with one update
Date	2011-10-05 23:44 +0200
Organization	Erland Sommarskog
Message-ID	<Xns9F75F173B44B8Yazorman@127.0.0.1> (permalink)
References	<a1a10e66-2ba9-4940-b933-b02887254a04@t16g2000yqm.googlegroups.com> <d588e8f7-ff99-40af-bb18-5add277d5147@u13g2000vbx.googlegroups.com>

Show all headers | View raw

--CELKO-- (jcelko212@earthlink.net) writes:
> You do know about the ANSI/ISO row constructors? It savrs a lot of
> dialect and typing:

No, in this context they don't save any typing, only wasting time.
Migurus clearly said that he uses SQL 2005 which does not support
row constructors for VALUES.

-- 
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx

Back to comp.databases.ms-sqlserver | Previous | Next — Previous in thread | Find similar

Thread

trying to replace multiple update statements with one update migurus <migurus@yahoo.com> - 2011-10-03 18:11 -0700
  Re: trying to replace multiple update statements with one update Erland Sommarskog <esquel@sommarskog.se> - 2011-10-04 23:14 +0200
  Re: trying to replace multiple update statements with one update --CELKO-- <jcelko212@earthlink.net> - 2011-10-05 09:21 -0700
    Re: trying to replace multiple update statements with one update Erland Sommarskog <esquel@sommarskog.se> - 2011-10-05 23:44 +0200

csiph-web