Sorry not to be clear here, Its not a conceptual question, its a command syntax question.

Say I'm logged in as a user that has the permission to grant myuser whatever he...

How do I this 'dynamic sql' thing? looks like just what I want to do.

I'm running my sql script embedded in a batch file so I hope its not a GUI...

I got a sql script and I want all sql commands in the script to run regardless of errors that are encountered.

begin transaction

create table a

go

insert into table a select *...