Viewing 15 posts - 31 through 45 (of 50 total)
Thanks SJTerrill! If I may, I would like to pick your brain a little more... I was trying to do this w/ ROLLUP but I couldn't. I STILL...
April 9, 2003 at 2:38 pm
Do a simple search on "Visual Source safe" and you'll find numerous articles on Change management and source code management. eg:
http://www.sqlservercentral.com/columnists/ckempster/changemanagement.asp
I remember seeing a few scripts in...
April 9, 2003 at 2:03 pm
Bring up an old topic. I recently renamed a laptop which has a SQL Svr 2000 installed on it. I read this and the BOL topic on "Renaming...
February 11, 2003 at 9:42 pm
Are you comparing the whole address + city + state + zip? I know at the place I work, sales people entered all sorts of crap into the app...
February 11, 2003 at 3:45 pm
There was an interesting article on "How to Search for Date and Time Values" written by Bryan Syverson.
http://www.sqlservercentral.com/columnists/bsyverson/sqldatetime.asp
May be that can help.
February 11, 2003 at 9:28 am
Has it gotten faster? I didn't notice it.
Just wondering, is this forum self written? I notice that sql-server-performance.com also has a similar looking forum on asp. I also...
February 11, 2003 at 9:10 am
Kind of off topic but not really...
How do one go about finding a lost / forgotten sa password? Assuming that one cannot even login to the box.
Err... this happens...
December 10, 2002 at 10:26 am
hmm... I don't think this is a problem that DISTINCT can fix. The problem is, joepin is getting both account types returned. The account_no for different account type...
October 25, 2002 at 2:37 pm
This method is great! LEFT OUTER JOIN, when there's no join on the right side, NULL is returned... no need to use <> or NOT.
Slight mistake on the Left...
October 25, 2002 at 10:11 am
"What i want to do is basically delete messages whose expiration date (contained within the table and set through an asp form)
is... well expired."
I do audits of old data in...
October 11, 2002 at 7:33 am
There was a script written by Narayana Vyas Kondreddi that will search all columns in every (user) table in one database. I think you can modify that script very...
September 13, 2002 at 9:53 am
There was a script written by Narayana Vyas Kondreddi that will search all columns in every (user) table in one database. I think you can modify that script very...
September 13, 2002 at 9:31 am
Are those columns NULLABLE? I think if it's NULLABLE then when you insert nothing into it it gets a NULL, otherwise you can always specify a DEFAULT value.
ALTER TABLE...
September 12, 2002 at 12:50 pm
Yeah, I once had a problem w/ DATEDIFF and these "ghost friends" here helped me out. You guys are awesome!
I had something like this for DATEADD:
CONVERT(CHAR(10),el.event_time,112) =
CONVERT(CHAR(10), DATEADD(dd,...
September 11, 2002 at 4:24 pm
Viewing 15 posts - 31 through 45 (of 50 total)