Shulou(Shulou.com)05/31 Report--

This article introduces you what are the splicing skills of dynamic SQL, the content is very detailed, interested friends can refer to, hope to be helpful to you.

Common misunderstandings are:

1. Dynamic SQL stitching cannot be done only with ado.net.

two。 There are several dynamic parameters, the repetition of the code becomes the combination of different numbers of these parameters, the more dynamic parameters, the greater the repetition.

For the second question, the following error code is evidence:

The code is as follows:

If (id > 0 & & string.IsNullOrEmpty (name)) {

Command.CommandText = "select * from T1 where id=?"

Command.Parameters.Add (id)

}

If (id

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.