Viewing 15 posts - 1 through 15 (of 38 total)
To be quite honest, if another DBA/programmer brought the second statement to me, I'd ask him what he thought he was doing... The logic to think through that query is...
April 7, 2006 at 5:37 pm
Marie, in this case, I think the derived table just makes it more obvious what the query is doing than the "WHERE...IN" version. SQL should only have to actualize...
December 19, 2005 at 1:02 pm
I'm not sure about doing it in the connection dialog in QA, but you can always use SQL's Client Network Utility, found in the SQL program group, to configure an...
June 7, 2005 at 1:20 pm
I think debugging technique is one of the most interesting topcis in programming. As such, this is a great question, IMHO, for an interview. Honestly, the content of...
July 11, 2004 at 1:38 pm
You might do some research on the "NT Fibers" server option to get more information on how SQL handles concurrent execution. I think that by default, it spawns a thread...
February 19, 2004 at 9:58 am
They way I've learned most languages is by needing to do something in the language that I don't know how to do yet. Then I'll hit up some web...
December 30, 2003 at 10:00 am
Jonathan appears to be right, you could rewrite this as an update.
Forgive me if I am wrong, but it looks like you already know how to program in another language...
December 29, 2003 at 4:07 pm
The first step will be to export all of the images. You will probably have to write a custom application to handle this, but I suspect you already have...
December 29, 2003 at 3:49 pm
I don't know that I would ever use a global table to look up so many attributes for a wide array of objects, but I have used a similar system...
December 9, 2003 at 10:12 am
That's pretty much what I was talking about... I was forgetting, however, that you can get around the message/status table being locked inside long-running transactions by using:
SELECT * from message...
November 26, 2003 at 7:34 am
I think that once you know how a language works and have a good understanding of it, then there's absolutely no reason in the world you should be typing everything...
November 21, 2003 at 9:27 am
Me too, actually. The first change I would make the the script I posted would be to make it take a parameter for the alias I wanted to use.
November 21, 2003 at 9:09 am
I use a method similar to the one scripted on the page Frank linked, except I don't use permanent temp tables, instead favoring a single message table that contains a...
November 21, 2003 at 8:54 am
To ease coding it:
select '[' + object_name(id) + '].[' + name + '] ,'
where id = object_id('tablename')
order by colid
Copy and paste the result, remove the columns you don't want....
November 21, 2003 at 8:35 am
My personal preference for outputting data to Excel is via a DTS package. If I need to pass a variable to it, I create a global variable and pass...
November 21, 2003 at 8:19 am