"http://ls.sswug.org/cgi-bin/lyris.pl?site=sswug&page=topic&topic=sql_server&text_mode=0&lang=english

"

Weird. I guess either that change happened seamlessly, or there has been a community of squatters Like refugees, abandoned by our listmates.

Sneaky. Two reasons why I got it right; 1) I'm a stickler for trying not to use keywords or reserved keywords... 2) I took a little more time...

Bah, I'm going to be cranky here 😉 Not just because I got the answer wrong, I swear.

The correct answer really shouldn't be "Another SQL Server 2000 machine" you're...

quote:

---

Hi CarKnee,

you've already seem to have found a solution.

What about REPLACE (your_column, 'ed','',1) and CAST this as int?

Haven't tried this here at...

Whoops, I think I replied to one of those threads in a link.

Out of curiousity, why do you need to be concerned with leap years...

This is how I'd do it:

declare @bd datetime

select @bd = '1976-12-2'

select case when month(@bd) > month(getdate()) then datediff(year, @bd, getdate())-1

when month(@bd) = month(getdate()) and day(@bd) < day(getdate()) then datediff(year, @bd,...

Looking BOL for SQL2000 64bit, they only mention Itanium/Itanium II processors. I know this doesn't really help you, but it doesn't look good. There's no HCL 64bit SQL...

You could always just stop SQL Server, delete the LDF then restart SQL Server.. before you do so, make sure your initial size setting isn't huge, or you'll be...

I wouldn't now how to handle the multiple recordsets. My advice would be to copy the portion out of sp_helplogins that creates only the output you desire and create...

"For testing purposes, is there a way to corrupt a db via an .ASP page over http?"

Edited by - spongemagnet on 06/11/2003 3:03:12 PM

Here's a twist, how do you pronounce: VARCHAR

Some say VAR (sounds like PAR) CHAR (like CHAR-BROILED)

I say it like VARE (like the V-A-R- in 'variable') CARE (like the C-H-A-R- in...

While I would still stick with the general concensus of having one big raid 5 and no logical partititions - there is one advantage I can think of to having...

heh, you guys overlooked the best and most obvious resource! Lookup Reserved Keywords in SQL BOL and you'll find everything you're looking for, and then some.. including ODBC Reserved...

I have the same consensus as everyone else regarding use of cursors. The only time I really use cursors is if I am manually handling data, it's rare to...

I put a lot of thought into my oltp server;

4 data channels (two 3200 smartarray controllers I think there's at least 4 dat channels, it's been awhile..),

1 going to...