C # The string splitting gadget produced for working SQL (very practical, you deserve to have)

Write in front

Why do you write this tool?

Work needs, splicing string dizzy splicing, especially in query, behind the parameters too much, want to execute some of this SQL statement in the data to the old laborious.

Look at the text

All work (backstage) siege Lions will be exposed to SQL statements, the most common SQL statements have many, especially in queries, the simplest example is

SELECT *  fromSMSSENTLOG201505WHEREAccountCodeinch ('PDA','ORDER','APP','WEB','Zhongtian','00006','02100','Callcenter','APPLE','externalusers','Billpush','Geenk','21198','055555','02199','Wuliao')

This SQL is a very common statement, but in the query, the following number is limited

In Limit number

oracle:1000 A

SQLSERVER:4W (results from online data)

If there are too many arguments in the back, it is very complicated for us to write the SQL statement, so we wrote a gadget to stitch the SQL statements in the back.

Look at the tools.

Gadgets can help us get a little bit more efficient at work, and here's a little introduction to the function points

1. Paste the number of display, in order to compare with the number in Excel, to prevent the pasting missing data

2. The generated SQL string is saved in Notepad for easy recording, or the program is closed.

3.in after the number of parameters can be set itself (not set is all generated at once, the number of sets to generate how many)

Although the tools are small, they can help you improve your productivity a little bit, siege lions, you say?

Please contact my qq:707055073 for any good advice.

Download link available: http://download.csdn.net/detail/mryanghenglian/8752405

C # The string splitting gadget produced for working SQL (very practical, you deserve to have)