Search Result

StevieMars · Aug 24 '10, 10:37 AM

Hello,

I want to do two sql INSERTS into the same table (table holds pk and fk rows) but I need the second insert to use the new Identity from the first INSERT. Something like:

Code:

INSERT INTO [table]
SELECT [Cols] FROM [Table] Where [blah];SELECT NewUDValue AS @@IDENTITY;
UNION ALL
SELECT [colName = NewUDValue, more cols] FROM [Tablle] Where [Blah]

However this doesn't work! Is this...

cgiguere · May 22 '09, 12:47 PM

Hello,

Trying to just insert a simple record in DB and it fails. When I set debugger on, I see that execution jumps out by IntakeNummer to the Catch and of course, assigns value -1 to IntakeNummer. As if it was impossible to increment or even read de identity column! In my DB, IntakeID is my identity column (1,1).

Underneath the vb.net code that fails. Can anyone help me? What am I doing wrong?

---------------------------------------------------------------...

Search Result

Multiple Inserts

Insert to SQLExpress table