I want to batch insert records with LLBLGen, following is T-SQL:
INSERT INTO Role(idt1) SELECT idt2 FROM template WHERE templateid = 1
How can I do this?
I want to batch insert records with LLBLGen, following is T-SQL:
INSERT INTO Role(idt1) SELECT idt2 FROM template WHERE templateid = 1
How can I do this?
You've got two options:
You're best bet is probably the stored procedure, which you can obviously call from within LLBLGen Pro.