Viewing 15 posts - 301 through 315 (of 851 total)
Florian Reischl (4/19/2009)
Bruce W Cassidy (4/19/2009)
I also enjoyed reading Phil Factor's article on CLR RegEx. A little scary that you can basically hang SQL Server with it though.
What do...
April 19, 2009 at 3:47 pm
[font="Verdana"]If you are building that translation for performance, I'd make one change:
Use an array of 256 2-character strings with the hexadecimal encoding for each byte. So you will have...
April 19, 2009 at 3:39 pm
[font="Verdana"]I'd like to see Microsoft ship SQL Server with the RegEx stuff built in. I guess the whole "server crashing capability" is something they would need to resolve first.
Architecturally...
April 19, 2009 at 2:28 pm
Florian Reischl (4/18/2009)
What do you like more C# or VB.Net?
[font="Verdana"]For me personally I prefer C#. But you will probably find there's a bigger audience for VB. Really, either...
April 19, 2009 at 2:03 pm
[font="Verdana"]The quotes got a bit hairy, so I'm just going to reply with some points.
Firstly, there are two Bruce's in this conversation! Eeek! :w00t:
Secondly, comparing the use of...
April 19, 2009 at 1:59 pm
Thomas (4/16/2009)
April 16, 2009 at 3:24 pm
Grant Fritchey (4/16/2009)
Evidently you're not supposed to spit water all over them while laughing. Who knew?
[font="Verdana"]On another site I frequented, this was known as the "coke spew". You got...
April 16, 2009 at 2:24 pm
[font="Verdana"]Based on some earlier comments, I suspect you are trying to do something like this:
select [...]
where a.filekey in (@filekey) and
...
April 16, 2009 at 2:07 pm
David Webb (4/16/2009)
wasn't "thread" the stuff that fell on Pern, destroyed all life it encountered, and was only thwarted by fire breathing dragons?
[font="Verdana"]Sure was! Their whole societal organisation was...
April 16, 2009 at 2:02 pm
[font="Verdana"]Sorry Steve. I'm going to reserve judgement. Most of it (to me) still seems to be pie in the sky dreaming. Yep, great to have something to...
April 16, 2009 at 1:43 pm
WayneS (4/16/2009)
Thomas (4/15/2009)
Using a cross join is not itself counter-intuitive. Using it in this fashion to generate a bunch of numbers probably is to most developers.
I think that this is...
April 16, 2009 at 1:41 pm
Grant Fritchey (4/15/2009)
Actually sounded like some of the deconstructionist stuff I used to have to read in film school. Lots of words, doesn't say much.
[font="Verdana"]Mmm. "Indisputable validity... I...
April 15, 2009 at 5:04 pm
Jeff Moden (4/15/2009)
It wasn't on Simple-Talk on 4/1, was it?
[font="Verdana"]Nope. Not another wunnerful article from Mr Hugh Bin Haad. This one purports to be serious. Personally I...
April 15, 2009 at 4:59 pm
[font="Verdana"]Have you tried something like the following:
declare @t table(OrderID int not null);
insert into tOrder(...)
output OrderID into @t(OrderID)
values (...);
select top 1
@intOrderID = OrderID
from...
April 15, 2009 at 2:58 pm
[font="Verdana"]I suspect that scope_identity() is being checked inside the stored procedure doing the insert, not inside the trigger.
Some code examples would help!
[/font]
April 15, 2009 at 2:53 pm
Viewing 15 posts - 301 through 315 (of 851 total)