Viewing 15 posts - 49,336 through 49,350 (of 59,066 total)
Yep... same ol' stuff, too! Basically a summary of everything that everyone has spoken of so far except how lame some (supposedly) certified folks "real skills" actually are. ...
July 8, 2008 at 4:46 am
No problem, Mick... It's easy to miss stuff especially when it's new.
July 8, 2008 at 4:34 am
There's nothing stopping you from that... think about it...
July 8, 2008 at 4:32 am
. EH! Wrong again! You only read the title... you didn't even read the requirements from the first post of the OP. Worse yet, this...
July 8, 2008 at 4:31 am
Your wasting a lot of time to maybe get it wrong. I don't normally advocate 3rd party software, but RedGates SQL Compare will do everything you just asked for......
July 8, 2008 at 4:23 am
Also, try Decimal(38,0) or BIGINT....
July 8, 2008 at 4:18 am
alijaffaromran (7/7/2008)
I want to create a table X1 with a datetime field StartDate and format it as "dd-mmm-yyyy hh:mm:ss". Is defining the format of a field possible?
For way to many...
July 7, 2008 at 7:32 pm
annas (7/7/2008)
This is my first post here and I hope this is not an insanely stupid question, but how does N recieve values in the function listed by Jeff?...
July 7, 2008 at 7:15 pm
sqlservercenter (7/7/2008)
shrink it at each weekend.
Absolutely not... it's just going to grow again and all you're doing by shrinking it is cause fragmentation of the underlying files at the OS...
July 7, 2008 at 5:13 pm
Tomm Carr (7/7/2008)
alter table dbo.CallCost
add Seconds as DateDiff( ss, 0, '1900-01-01 ' + Duration );
Now you have a computed column which very quickly, and behind the...
July 7, 2008 at 5:11 pm
Heh... translation... BOOOOOM! 😀
July 7, 2008 at 5:03 pm
B.A. Cooper (7/7/2008)
July 7, 2008 at 5:00 pm
Ok... now, to understand how the function works, you have to read the following...
http://www.sqlservercentral.com/articles/TSQL/62867/
If you want a super deep knowledge of how to do splits well beyond what's in that...
July 7, 2008 at 10:19 am
mick burden (7/7/2008)
DECLARE @Now...
July 7, 2008 at 10:16 am
If you're not going to finish it, you shouldn't start it. 😉 What do you want to race on... again? 🙂
July 7, 2008 at 9:25 am
Viewing 15 posts - 49,336 through 49,350 (of 59,066 total)