How about using an Identity column. This will number your records sequentially. Then all you need do is select the records with an identity value between your first and last...

The first thing you should do is put your two database writes into a transaction. This will ensure that they will either both get committed or that both will be...

Check out ADO 2.6 there is a flag you can set on the recordset object(PersistXML from memory) which will return your recordset in XML. Neat huh?

Don't rightly know is the answer. It'll depend on how detailed SQLSERVER is when returning the error to ADO. To be honest with you I tend to avoid cascading deletes...

I'd go with Andy. The Text-File/DTS load method would be my preffered route. XML's great particularly with handling complex data-set structures, but yours is simple.

DTS gives you the oppurtunity to...

OK The trick is in capturing the error and doing something with it. To do this I use a small footprint object to handle all database access. This has two...

This is an intriguing question. Could you elaborate on the thinking behind passing the recordset INTO a stored procedure.

Where's the recordset coming from?

What is the stored procedure...

This might be a dumb question, but on your table defs I can't see any indexes, you do have some don't you?

Assuming you have indexes I notice you're using a...

Steve is right VBSCRIPT and ASP will handle the database interaction OK

But you will still need some HTML to present your pages to your users. You als need to...

Try This. I did it with two tables (tbl_new_1 and tbl_new_2) both containing columns for stock_id VARCHAR(10), description VARCHAR(20). Primary key on stock_id

INSERT dbo.tbl_new_1(

stock_id,

description)

SELECT...

You find yourself padlocked to your PC and you have and intraveneous Coffee-Drip (or perhaps Herbal Tea) inserted in your arm

You may find some interesting little challenges if your SP's use good ORACLE standards like %ROWTYPE and %TYPE. For example I've not found any equivilant of %ROWTYPE for Cursor handling...

YUP I use DELPHI 5 accessing SQLSWERVER through ADO (direct ADO TLB not ADO Express)

Works uncommonly well! But I have to admit to being an MS person as well my...

Thank you Antares686. So Simple, So Elegant So.... SQL Server.

The more I work with this product the more I like it. Yes there are things to curse at, but then...

The inserts we're interested in hit the db singly (not part of a batch input). As to the code well I tried just adding FOR INSERT, UPDATE and leaving the...