SQL injection is an issue any time you are accepting information that the user can enter (whether through form fields, or through constructing their own POST or GET command and...

I would disagree with the contention that STATIC cursors should be avoided. Obviously, there are instances where this is true, and yes, this does cause the result set to...

David.Poole said:

Analyst/xxxxxx implies that the role is not a progamming drone role to my way of thinking. You get a spec but are allowed to question requirements.

The analyst role can...

1) I recommend cash and a handgun.

2) Google ACID transaction

3) Master (or Yale, but never Harvard)

4) Invalid command "sql text"

5) Always pull the plug, unless...

As the originator of this thread, I thought i should bring it to some closure.

We have not had a repeat of the symptoms we saw that day. I have...

I have not found out what was wrong. A number of people have suggested that the problem was a single bad query (since many queries do not allow for...

Yes, I have done that - "Use all available processors" is selected, as it should be. Thanks for the suggestion, though.

That may actually be the problem/solution I'm thinking of,...

Double hurm. Typed up a response, and it got eaten. Let's try again....

First, I'll mention that, with an expectation of million of rows, I'm inclined to question how...

For me, the first thing to consider is if I need the values to be stored in their native datatypes within SQL Server. If you do not need to...

I'm curious as to why you say this. Of course, I am making the assumption that the mechanism used to identify which rows should be updated is essentially static,...

Actually, there are other solutions; they just aren't necessarily any better, and might even be worse.

Note, pseudo-code ahead:

create procedure take1 @field_to_update, @value

update table A

set field1 = case...

Oracle uses SEQUENCE to generate new, unique ID numbers for rows.

SQL Server most commonly uses the IDENTITY feature to accomplish this. Look in SQL Books Online for details. ...

OK, let's generalize the question: Does anyone know of a way to generate requests to (and consume responses from) web services via T_SQL, DTS, etc.?

Well, I can see multiple lines, and...

...if there's a blank line there (and now that I've previewed it, I know there is!), don't have to use <br /> to format...

I use Mozilla 1.6, and I still get just the one line instead of a true TEXTAREA. Windows XP Pro