Posted by Erland Sommarskog on 06/04/05 15:08

kalamos (kmcclare@hotmail.com) writes:
> The above solutions were great. I only had the "a" in the wrong place. I
> did not understand that sql server was "different" from Oracle in this
> way.

Just a word of warning, while most, if nor all, RDBMSs today provides
SQL, that does not mean that SQL from one engine runs on another. You
cannot even rely on some sort of standard, because few engines implement
all of the standard.

....and even if the statement runs and give the same result on two
engines, performance may differ considerably.


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

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp

• Next in forum: Re: Code in the database or middle tier (the CLR controversy)
• Prev in forum: Re: Code in the database or middle tier (the CLR controversy)
• Thread view: Re: SELECT works but UPDATE fails. ?

[Reply to this message]