Ben Nadel
On User Experience (UX) Design, JavaScript, ColdFusion, Node.js, Life, and Love.
I am the chief technical officer at InVision App, Inc - a prototyping and collaboration platform for designers, built by designers. I also rock out in JavaScript and ColdFusion 24x7.
Meanwhile on Twitter
Loading latest tweet...
Ben Nadel at Scotch On The Rock (SOTR) 2010 (London) with:

Dave

Member since Oct 26, 2010

Recent Blog Comments By Dave

  • Getting @@RowCount After SQL INSERT INTO Statement

    Posted on Oct 27, 2010 at 7:53 AM

    Hi Ben, The output would be like this: Row 1: 2, OldName, Desc., Dept., 1 Row 2: 2, OldName, Desc., Dept., 2 Row 3: 2, OldName, Desc., Dept., 3 Row 4: 2, OldName, Desc., Dept., 4 So the Sql statement will process the records from LLEntry table. And each time it processes a record, I want it t... read more »

  • Getting @@RowCount After SQL INSERT INTO Statement

    Posted on Oct 26, 2010 at 4:01 PM

    Hi, I'm trying to figure out how to insert the row count as a value. For example: insert into TempImport (Code, OldName, Description, Def, NewName) Select '2', Name, Description, 'Department', (@@RowCount) from LLEntry where LLEntryID > '0' and LLDefID = '4' I'm trying to use the RowCount for ... read more »