Viewing 15 posts - 42,346 through 42,360 (of 59,067 total)
You have roughly 156 posts as of now... that means you're not really a newbie anymore and you've seen it said before... read the article in the first link in...
--Jeff Moden
Change is inevitable... Change for the better is not.
August 11, 2009 at 6:33 pm
Eric,
Bit Bucket wanted you to post the code for the function that creates the path in the FROM clause of the BCP statement... not all the stuff you've already...
--Jeff Moden
Change is inevitable... Change for the better is not.
August 11, 2009 at 6:19 pm
Heh... crud. False alarm. It was a coincidence... I just did the same delete again and Word still came up properly. Dang...
--Jeff Moden
Change is inevitable... Change for the better is not.
August 11, 2009 at 5:58 pm
Yowch! Thought I'd give a little feedback on this nasty little problem. I found the cause... I'm one of those folks that does things like reject cookies and...
--Jeff Moden
Change is inevitable... Change for the better is not.
August 11, 2009 at 5:49 pm
saivko (8/11/2009)
What methods don't use explicit transactions?
On most systems, everything is an "implicit" transaction and you have to use a BEGIN TRANSACTION to start an "explicit" transaction.
I'm also not...
--Jeff Moden
Change is inevitable... Change for the better is not.
August 11, 2009 at 5:33 pm
timothyawiseman (8/11/2009)
Steve Jones - Editor (8/11/2009)
--Jeff Moden
Change is inevitable... Change for the better is not.
August 11, 2009 at 3:42 pm
Steve Jones - Editor (8/11/2009)
--Jeff Moden
Change is inevitable... Change for the better is not.
August 11, 2009 at 2:07 pm
gah (8/11/2009)
If I run this on 2K5 I...
--Jeff Moden
Change is inevitable... Change for the better is not.
August 11, 2009 at 1:46 pm
timothyawiseman (8/11/2009)
Personally, I am a big fan of this site exactly as it is and have great respect for what it has accomplished.
I absolutely agree... I just got...
--Jeff Moden
Change is inevitable... Change for the better is not.
August 11, 2009 at 1:36 pm
Luke L (8/11/2009)
BTW it's a Belgian Abbey-style Dubbel.
Heh... the acronym for that is pretty BAD. 😛
--Jeff Moden
Change is inevitable... Change for the better is not.
August 11, 2009 at 12:54 pm
The only problem with that is, stuff doesn't line up when you print action characters.
--Jeff Moden
Change is inevitable... Change for the better is not.
August 11, 2009 at 12:33 pm
Shrinking the file after doing a reindex just messes things up because the shrink moves pages.
--Jeff Moden
Change is inevitable... Change for the better is not.
August 11, 2009 at 12:20 pm
Ok... although a nifty trick, the problem with using something like COMPUTE BY for this is that it returns multiple result sets. I can see the need for this...
--Jeff Moden
Change is inevitable... Change for the better is not.
August 11, 2009 at 12:03 pm
JC (8/11/2009)
but i guess we differ in opinion as I have been writiung Oracle SQL for many years and I do not quite understand whay i should not be...
--Jeff Moden
Change is inevitable... Change for the better is not.
August 11, 2009 at 11:49 am
drew.allen (8/11/2009)
You can trick T-SQL into doing this by adding a COMPUTE BY clause...
--Jeff Moden
Change is inevitable... Change for the better is not.
August 11, 2009 at 10:31 am
Viewing 15 posts - 42,346 through 42,360 (of 59,067 total)