> Anyone else started to play with SS 2005 yet? I tried SQL Server 2005 Express Edition Beta 2., you need .net framework ver 2 installed, didn't like the fact they have not released a gui tool yet so you need to install and play with vb and visual studio and it comes without other management tools, even found making a connection locally to northwind a problem, maybe I'm missing something:)butI figure I'm better off sticking to developer edition of SS 2000...
Colm -----Original Message----- From: Russ Michaels (Snake) [mailto:[EMAIL PROTECTED] Sent: 09 September 2004 10:11 To: [EMAIL PROTECTED] Subject: RE: [ cf-dev ] Yukon WAS: A new problem ??? I get the MS action pack, but not received any copies of SQL2005 yet > -----Original Message----- > From: Adrian Lynch [mailto:[EMAIL PROTECTED] > Sent: 09 September 2004 09:55 > To: [EMAIL PROTECTED] > Subject: RE: [ cf-dev ] Yukon WAS: A new problem ??? > > But come oooooon, dynamic TOP(n), how cool is that!?! :OD > > How are you finding it so far? I'm not too impressed with the > management studio so far, seems awfully slow on my machine. > > Have you found many uses for the new windowing/ranking > functions? Maybe I'm missing the point, but how can I make > use of ROW_NUMBER() and filter on it? > > Anyone else started to play with SS 2005 yet? > > Ade > > -----Original Message----- > From: Robertson-Ravo, Neil (RX) > [mailto:[EMAIL PROTECTED] > Sent: 09 September 2004 09:28 > To: '[EMAIL PROTECTED]' > Subject: RE: [ cf-dev ] A new problem ??? > > > Yep, it also has a shed load more ;-) which is even jucier... > > -----Original Message----- > From: Adrian Lynch [mailto:[EMAIL PROTECTED] > Sent: 08 September 2004 17:48 > To: [EMAIL PROTECTED] > Subject: RE: [ cf-dev ] A new problem ??? > > Or since it's inline SQL, CreateUUID might work for any other DB. > > <cfquery...> > SELECT TOP 5 * > FROM table > ORDER BY 'CreatUUID()' > </cfquery> > > Give it a try, it might work. > > Ade > > BTW, I have installed SQL Server 2005 Beta 2, got a bunch of > new features. > Now call me an idiot, but my favourite is dynamic TOP(n)! > > > -- > These lists are syncronised with the CFDeveloper forum at > http://forum.cfdeveloper.co.uk/ > Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ > > CFDeveloper Sponsors and contributors:- > *Hosting and support provided by CFMXhosting.co.uk* :: > *ActivePDF provided by activepdf.com* > *Forums provided by fusetalk.com* :: *ProWorkFlow > provided by proworkflow.com* > *Tutorials provided by helmguru.com* :: *Lists > hosted by gradwell.com* > > To unsubscribe, e-mail: [EMAIL PROTECTED] > > -- These lists are syncronised with the CFDeveloper forum at http://forum.cfdeveloper.co.uk/ Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ CFDeveloper Sponsors and contributors:- *Hosting and support provided by CFMXhosting.co.uk* :: *ActivePDF provided by activepdf.com* *Forums provided by fusetalk.com* :: *ProWorkFlow provided by proworkflow.com* *Tutorials provided by helmguru.com* :: *Lists hosted by gradwell.com* To unsubscribe, e-mail: [EMAIL PROTECTED] -- These lists are syncronised with the CFDeveloper forum at http://forum.cfdeveloper.co.uk/ Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ CFDeveloper Sponsors and contributors:- *Hosting and support provided by CFMXhosting.co.uk* :: *ActivePDF provided by activepdf.com* *Forums provided by fusetalk.com* :: *ProWorkFlow provided by proworkflow.com* *Tutorials provided by helmguru.com* :: *Lists hosted by gradwell.com* To unsubscribe, e-mail: [EMAIL PROTECTED]
