This is true. I've done it and it works. It's easy enough to test and see that Alan is correct.
On 1/26/2011 1:57 PM, Alan Rother wrote: > I don't know what to tell you Mike, SQL Server doesn't care, it works either > way > > SELECT * > FROM PropImage > WHERE > 20 = PropertyID works exactly the same as PropertyID = 20 > > It's just common convention that we use PropertyID = 20 > > In the internal SQL engine it's just running a logical comparison against > the statement itself. SQL Server is pretty darn intelligent. > > Try it. > > > Now all that being said, I still wouldn't recommend doing things that way, > but it does work. > > > > On Wed, Jan 26, 2011 at 11:27 AM, Michael Firth<mfsqlser...@gmail.com>wrote: > >> Alan wrote: >> >> MSSQL doesn't care if the field is on the left or the right, it's just >> running a comparison against the statement. >> >> Gotta say thats a first and I have been doing mssql for ten years. I am >> telling you this is what is causing his error because tsql is not as >> flexible as you think because its procedural and requires you do it in a >> certain way. >> >> Mike >> >> On Jan 26, 2011, at 1:23 PM, Alan Rother wrote: >> >>> MSSQL doesn't care if the field is on the left or the right, it's just >>> running a comparison against the statement. >> >> > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:341412 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm