Viewing 15 posts - 54,436 through 54,450 (of 59,067 total)
Sandy (10/23/2007)
Great Standard of Code,
I really feel its the way need to be done.
but i have a small issue here,
when i am trying to copy your code...
October 23, 2007 at 7:03 am
Peter Larsson (10/23/2007)
Jeff, excellent code but I think you should start using QUOTENAME function for those having brackets, spaces or even single quotes in their table/column names.
Yep... that would work,...
October 23, 2007 at 7:03 am
Fixed that... thanks for the observation... I always hate coverting working code into instructional code... I mess it up almost every time :hehe:
October 23, 2007 at 12:08 am
Now you know why I don't let images and other blobs into may databases... too much of a hassle. I just store the names of files in the database...
October 22, 2007 at 11:56 pm
I know... I'm a sick man... I usually have a primary key and an alternate key... except for a relatively static state or country reference table, I don't like natural...
October 22, 2007 at 11:39 pm
If making RAC open source would stop your spamming, I'd be happy about that. 😛 And, your insults are a great way to drum up business :w00t:
Just curious... how...
October 22, 2007 at 11:22 pm
WHERE = NULL will not work unless you make a pretty uncommon (some consider it "dangerous") change to the ANSI NULL settings of the server. NULL is not "nothing"...
October 22, 2007 at 9:58 pm
Look again... you're not getting what you think you're getting... run this small demo to see why...
[font="Courier New"]DECLARE @Params VARCHAR(100)
SET @Params = 'abcdefghij[ImportDate=12345678901234567890'
SELECT SUBSTRING(@Params,PATINDEX('%[ImportDate=%', @Params)+13,19)[/font]
...did you...
October 22, 2007 at 9:50 pm
I'm curious... what did you need this for?
October 22, 2007 at 9:24 pm
Not sure what you're using to do the move, but can you split the job? Trying to move ore even UPDATE more than 1 or 2 million rows at...
October 22, 2007 at 9:17 pm
It's easier than that... lookup STUFF in Books Online...
October 22, 2007 at 9:13 pm
David McFarland (10/22/2007)
October 22, 2007 at 9:09 pm
Thanks, Matt...
I'd be doing a full install on a box that already has the Developers Edition of 2k on it and I'd be installing the Developer's edition of 2k5... do...
October 22, 2007 at 9:00 pm
Matt... all good points and thanks for the experiments you did... Man, I gotta take the time to install the Dev version of 2k5... then I can run my own...
October 22, 2007 at 6:32 pm
Heh, yep... I've been there as well... puts the DBA between a rock and a hard spot.
I guess all you can do is wait, then. When it gets bad...
October 22, 2007 at 7:08 am
Viewing 15 posts - 54,436 through 54,450 (of 59,067 total)