We have SQL2005 and SQL2008 servers. When we went to 2005 I thought "This is great", with 2008 I think "How did I do this before"!
The MERGE function is really nice. It's also nice to be able to declare a variable and set its value all in one statement. Example: 2005 (and before): declare @today datetime; select @today = getDate(); 2008: Declare @today datetime = getDate(); I keep coming across new stuff that I like as well. Just don't have time to read through all the changes and play with them until I need them. Steve -----Original Message----- From: Michael Dinowitz [mailto:mdino...@houseoffusion.com] Sent: Friday, January 28, 2011 2:13 PM To: cf-talk Subject: Re: Insert without checking existance MSSQL 2000. While this is for a client, a lot of what I'm doing here is going to applied to my own stuff. The client will be moving to MSSQL 2008 soon but I'm assessing if I can stay on MSSQL 2000, can move to MSSQL 2008, or should just move over to MySQL for my own stuff. The licensing on MSSQL 2008 is kind of high, but it ranks high on my personal priority scale. As a total aside, I rank CFBuilder low on the scale as it doesn't give me more than I have with Homesite/CFEclipse. I'll reassess when the next release comes out. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:341661 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm