SQL Server stored procedures generator from SQL statement?

Does anyone know of a freeware to generate SQL Server stored procedure (ie trigger) from a SQL statement?

I mean I don't want the just basic CRUD stored procedures... What I'm looking for is something like this:

Taking a SQL statement like:

INSERT INTO TableB (ColumnA, ColumnB...) 
      (SELECT Distinct ValueA,ValueB FROM someTable where someColumn = someValue)

And issuing the complete stored 开发者_StackOverflow社区procedure statements...

Stored procedures and triggers are quite different things.

There are things like AutoAudit which will generate triggers for a table.

Beyond ordinary CRUD, I'm not sure what else you are looking for in a procedure, but it is certainly possible to add it to a code generation template - have a look at the T4 templating engine if your code generation is complex.