Viewing 15 posts - 40,591 through 40,605 (of 49,571 total)
souLTower (3/4/2009)
Gail, I'm confused as to why to use the datediff function.
The dateadd/datediff is a trick to 'truncate' a data to a certain precision (day, week, month, year)
In the one...
March 4, 2009 at 1:05 pm
Ninja's_RGR'us (3/4/2009)
March 4, 2009 at 12:21 pm
Grant Fritchey (3/4/2009)
I've got a poster that I really don't know how to help.
Sorry, can't help you there.
Check agent error logs?
March 4, 2009 at 12:04 pm
Grant Fritchey (3/4/2009)
March 4, 2009 at 11:55 am
Grant Fritchey (3/4/2009)
March 4, 2009 at 11:35 am
Lowell (3/4/2009)
for varchar strings, the = comparison operator strips out ending whitespace.
Char and varchar both behave this way.
create table #test
(phrase char(10))
insert into #test values ('phrase') -- will be padded out...
March 4, 2009 at 11:21 am
The cache is not refreshed real-time. To force a refresh, Edit -Intellisense -Refresh Local Cache (Ctrl-Shift-R)
March 4, 2009 at 11:18 am
SQL ignores trailing spaces when doing string comparisons, as required by the SQL standard
March 4, 2009 at 11:17 am
Grant Fritchey (3/4/2009)
March 4, 2009 at 11:12 am
Chris Morris (3/4/2009)
21. In case using GROUP BY without an aggregate function try using DISTINCT instead
What a coincidence. In a thread earlier today in which this poster was...
March 4, 2009 at 10:47 am
Peter (3/4/2009)
March 4, 2009 at 10:17 am
Derek Dongray (3/4/2009)
March 4, 2009 at 10:15 am
Lynn Pettis (3/4/2009)
Have you also noted that he changed his name? Now it doesn't match the name in the quoted replies to his deleted posts. :w00t:
That's easily fixable...
March 4, 2009 at 9:46 am
Mangal9i (3/4/2009)
Is there I'm missing something or it is known issue on the forums?
Known issue. The forum code doesn't escape the < and > and treats anything inside them as...
March 4, 2009 at 9:44 am
Peter (3/4/2009)
1) When inserting multiple rows, is there any guarantee that they are inserted in the order in which they are selected in?
No but, if I recall, an Order By...
March 4, 2009 at 9:38 am
Viewing 15 posts - 40,591 through 40,605 (of 49,571 total)