Viewing 15 posts - 4,276 through 4,290 (of 8,416 total)
CirquedeSQLeil (4/3/2010)
Fair enough. I have yet to see an application do it correctly though.
It does happen. I'm still a 'database person' though, and would prefer to do it...
April 3, 2010 at 12:59 pm
Carl Federl (4/3/2010)
CAST(convert(int, convert(float, getdate() )) AS DATETIME)
Few of issues with this one.
1. Relies on undocumented internal implementation details.
2. Only works with DATETIME - none of the new...
April 3, 2010 at 12:40 pm
Nabha (4/3/2010)
Paul White NZ (4/1/2010)
If there are points available for being obscure...
SELECT {fn CURRENT_DATE()};
:w00t: huh? :hehe: (ODBC yeah?)
Yeah - works in normal Transact-SQL too though!
Try it!
April 3, 2010 at 12:25 pm
Jeff Moden (4/3/2010)
Heh... you know I'm blind and one eye and can't see out the other before coffee. 😛
:laugh:
Can't believe I missed my own comment :blush:
April 3, 2010 at 12:23 pm
Has a play with this, and came up with the following, as a proof of concept.
This creates 100,000 transactions for a customer, and produces the required output.
Setup
-- =================
-- Test object...
April 3, 2010 at 12:20 pm
April 3, 2010 at 10:56 am
The row counts returned are not guaranteed to be exact - in fact they are documented as being 'approximate'. The numbers you see in the compatibility view 'sysindexes' might...
April 3, 2010 at 10:26 am
Only Joe could whine on about FIPS_FLAGGER and ANSI standards for a day and a half and then accuse someone else of being a whining child!
ANSI standard UPDATE syntax? ...
April 3, 2010 at 9:38 am
Everyone else seems to have had a go, so here are my thoughts:
1. This table probably does not benefit from having a clustered index. If the insertions are...
April 3, 2010 at 8:41 am
Steve Jones - Editor (4/3/2010)
But I don't suspect SQL Server 😉
:laugh:
Ok, ok, I was talking to 'bag of birds' not you lot!
Jusy saying...if SQL Server is in anyway responsible (autoshrink?)...
April 3, 2010 at 8:19 am
PaulB-TheOneAndOnly (4/3/2010)
Either poster has poor comm skills, has no clue about what he's talking about or is the genious that wrote sql kernel 😀
:laugh: genious? :laugh:
Actually, I rather suspect that...
April 3, 2010 at 7:59 am
If it is SQL Server-related, you would expect the guilty process to jump out at you from Activity Monitor (IO latch waits/Data File I/O list depending on version).
You could also...
April 3, 2010 at 7:57 am
bitbucket-25253 (4/3/2010)
Yes I am well aware of what sp_foreach uses
:ermm:...ok! Many people aren't 😉
They can be useful yes, my comment was tongue-in-cheek 😛
Shame they're undocumented, though, right?
April 3, 2010 at 7:50 am
Viewing 15 posts - 4,276 through 4,290 (of 8,416 total)