Viewing 4 posts - 226 through 229 (of 229 total)
... declarative in his sense means specifying the result you want (chocolate chip cookies) rather than specifying a method of achieving it (make the mix, bake it). You've fallen...
May 1, 2009 at 1:23 pm
gserdijn (4/14/2009)
select square(count(1)) From master.sys.columns C1
Oops! I had missed that one.
Nice !
April 29, 2009 at 3:12 pm
Tom.Thomson (4/29/2009)
gautamsheth2000 (4/13/2009)
Should use this code 🙂Select count(*) From master.sys.columns C1 CROSS JOIN master.sys.columns C2
That's far too slow 😉
Try instead:
select power(count(*),2) from master.sys.columns
Comparing equivalent code on SQL Server 2000...
April 29, 2009 at 3:10 pm
RBarryYoung (4/14/2009)
gautamsheth2000 (4/13/2009)
Should use this code 🙂Select count(*) From master.sys.columns C1 CROSS JOIN master.sys.columns C2
Yes indeed. Good job!
Using the offending solution took 14 seconds on a MacPro. When I ran...
April 21, 2009 at 11:31 am
Viewing 4 posts - 226 through 229 (of 229 total)