Small Flex Tool for parsing column names to SQL format string

Categories: Development Notes • Flex • 分享; Tagged with: Flex • SQL • Tools; @ November 19th, 2012 18:40

Hi all,

I wrote a small Flex tool for parsing column names to SQL format, for example:

when I want to select those fields:

ColumnName

ACCOUNT

SECURITYEXCHANGE

ORDREFNO

ORDERID

BUYSELL

I need to copy those fields into my SQL editor, and put “,” for each of them, it’s boring and waste time, So I wrote a Flex tool, which can parse the fields into:

1: Added comma:

ACCOUNT,

SECURITYEXCHANGE,

ORDREFNO,

ORDERID,

BUYSELL

2: Added quotation marks and comma:

‘ACCOUNT’,

‘SECURITYEXCHANGE’,

‘ORDREFNO’,

‘ORDERID’,

‘BUYSELL’

Hope it can save your time if you are doing such kind of SQL jobs.

Get the tool: http://liguoliang.com/wp-content/uploads/2012/11/ParseStrForSQL.swf

Windows提示移动硬盘未格式化快速修复: ChkDsk / Check Disk <-> Use expression to get dynamic data in SSIS package (file name with date)