Viewing 15 posts - 33,781 through 33,795 (of 59,102 total)
Yes, at the very least. That's correct for when the "numeric" date format is unknown. If you have dates like '1 Jan 2011' or 'January 1st, 2001' (etc),...
--Jeff Moden
Change is inevitable... Change for the better is not.
June 2, 2011 at 4:21 pm
jarid.lawson (6/2/2011)
--Jeff Moden
Change is inevitable... Change for the better is not.
June 2, 2011 at 7:59 am
thomas.bassett (6/1/2011)
Declare @InFoodID int
SET @InFoodID = 2
SELECT
AnimalFood.FoodID, Animal.AnimalName
FROM
AnimalFood INNER JOIN
Animal ON AnimalFood.AnimalID = Animal.AnimalID
WHERE
...
--Jeff Moden
Change is inevitable... Change for the better is not.
June 1, 2011 at 11:27 pm
Nadrek (6/1/2011)
As a very rough example, the first two statement could collapse to:
Update...
--Jeff Moden
Change is inevitable... Change for the better is not.
June 1, 2011 at 11:23 pm
jarid.lawson (5/31/2011)
I need to go through this list and update all date fields into one format,...
I strongly recommend against that. First, DATE datatype "fields" cannot be formatted. Second,...
--Jeff Moden
Change is inevitable... Change for the better is not.
June 1, 2011 at 11:20 pm
sql_jr (6/1/2011)
It doesn't matter when the period starts,...
Actually, it does and the reason I asked it is because I believed I could save you a lot of pain in...
--Jeff Moden
Change is inevitable... Change for the better is not.
June 1, 2011 at 10:51 pm
Fal (6/1/2011)
Can you tell me what Hoot means?
Actually, it's the sound made when you blow a pork chop out of your nose. 😛
--Jeff Moden
Change is inevitable... Change for the better is not.
June 1, 2011 at 10:42 pm
Ahhhh... you've left out the third member of the team to make it all happen securely; the Master database. 😉
--Jeff Moden
Change is inevitable... Change for the better is not.
June 1, 2011 at 10:29 pm
Based on item #7 of the article that SteveB posted, I'd like to make a couple of recommendations.
1. Set the database you're loading to to "Bulk-Logged" recovery.
2. Lookup...
--Jeff Moden
Change is inevitable... Change for the better is not.
June 1, 2011 at 10:12 pm
thundersplash845 (5/31/2011)
Hi ,I want to set the first row third column (e-mail) value as empty. How do i handle?? Can anyone help on this??
Expected output
NAME-----PHONE-------EMAIL
A---------3333---------
B---------4444---------XXX
I've just gotta ask... Why do...
--Jeff Moden
Change is inevitable... Change for the better is not.
June 1, 2011 at 7:17 am
sql_jr (6/1/2011)
This doesn't return the correct results -the count is wrong (probably due...
--Jeff Moden
Change is inevitable... Change for the better is not.
June 1, 2011 at 7:13 am
coenie-353912 (6/1/2011)
--Jeff Moden
Change is inevitable... Change for the better is not.
June 1, 2011 at 6:33 am
I agree with Steve... language and region are probably the reason and should be compared old to new.
--Jeff Moden
Change is inevitable... Change for the better is not.
June 1, 2011 at 6:30 am
Craig Farrell (5/31/2011)
Jeff Moden (5/31/2011)
The Dixie Flatline (5/31/2011)
Could 42 possibly be the airspeed velocity of an unladen swallow?
Nope... it's the terminal velocity for a pork chop with a bone in...
--Jeff Moden
Change is inevitable... Change for the better is not.
May 31, 2011 at 9:10 pm
Lookup MAXDOP in Books Online. The answer is there.
--Jeff Moden
Change is inevitable... Change for the better is not.
May 31, 2011 at 8:53 pm
Viewing 15 posts - 33,781 through 33,795 (of 59,102 total)