All pastes #165361 Raw Edit

Miscellany

public sql v1 · immutable
·published 2006-09-09 20:23 UTC
rendered paste body
-- I want to do this:foreach (row in oldTable){  insert into Aspect values (row.Name)  insert into AspectDetail values (Scope_Identity (), row.Description, row.Modification)}Aspect------Id (int) PKName (varchar)Creation (date)AspectDetail------------AspectId (int) FKModification (date)Description (varchar)OldTable--------Id (int) PKName (varchar)Description (date)LastChange (date)