eeckhaut (2/11/2009)

---

Hello,

I want to update several rows in 1 UPDATE statement, this is what I want to do:

The column 'counter' of every row should have a unique incrementing value, starting...

[font="Verdana"]Is there any reason why you can't use a stored procedure to do your inserts?

Create a stored procedure to which you pass the XML. It does the insert, then...

[font="Verdana"]Wow, that's a lot of work.

Why not just insert into the same table on the same server? Once you've done the insert, then pull back the results.

Or am I...

Bob Hovious (2/10/2009)

---

It's interesting to find someone else who thought of table variables as a way of avoiding logging. Usually I hear only that it is much quicker...

[font="Verdana"]In some cases, you do have some sort of identifier (usually a business key of some sort). And yes, this makes it a lot easier.

In other cases,...

[font="Verdana"]You also have to hope that SQL Server doesn't reorder the data...

I think by using the output clause of the insert, it should be possible to avoid the necessity of...

[font="Verdana"]I think what you are saying is that you can use the Microsoft toolset against Oracle, but not the other way around?

I'm just glad we're not talking about the Sybase...

[font="Verdana"]Can we see the code for your trigger, and some table formats please?[/font]

Bob Hovious (2/10/2009)

---

Bruce, check out the OUTPUT clause to an INSERT. You can trap ALL the recently generated IDs from the mass INSERT, not just the last...

GSquared (2/10/2009)

---

If I were interviewing and found that the prospective employer expected me to use a command-line interface to the server as my only tool, I'd tell them the interview...

[font="Verdana"]Yeah, I get that. It's much the same issue (I think) that we face with loading bulk data in our data warehouse (which is running on SQL Server 2005).

Here's...

[font="Verdana"]I don't disagree with any of what you have said. But it's the old argument of why I used to use vi rather than emacs.

Personally, I'd rather use an...

[font="Verdana"]The -N option for bcp is "-N keep non-text native". That means it is storing the binary form of your numbers in the file. Try using a character...

[font="Verdana"]Two thoughts:

You could develop an SSIS package, and your application could ensure that the files that the users upload are in the right place, with the right name, and then...

[font="Verdana"]My experience with Oracle pre-dates SQL Developer being an Oracle product. Did Oracle purchase the tool-set of the same name? (A far better choice than TOAD, if so.)

I...