Saturday, 13 October 2012
Quick Code Generator
Sometimes you want to generate a quick bit of code and dont want to use a massive code generator. Well what if you could just get a list of values and apply a template to them quickly and generate the resulting code. The answer is http://nimbletext.com/live
I need to insert a few values from Excel into a SQL Database.
The template looks like below
Insert ADX.tbl_PROD_ADVERTISER_Mapping( ADVERTISER_ID, ADVERTISER_NAME_SB, REVENUE_STREAM, ADVERTISER_NAME_ADX)
Values ($0, '$1', '$2', '$3')
go
To split on tabs (defualt when copying from Excel) use \t as the column separator.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment