VS2010 vb.net中SQL文模糊查询的写法

菜鸡程序员_小小

于 2017-10-23 17:38:52 发布

阅读量2.2k

点赞数

CC 4.0 BY-SA版权

本文链接：https://blog.youkuaiyun.com/qingdatiankong/article/details/78321231

经验，学习专栏收录该内容

119 篇文章

订阅专栏

本文介绍了一个具体的SQL查询构造实例，该查询用于从MS_AAAA表中选择特定的产品信息记录，包含多个字段如NO、WRENCH_TTTT等，并通过LIKE操作符进行模糊匹配搜索。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

 '信息的取得
    Private ReadOnly selectProdInfoSel As String = _
                            "SELECT " & vbCrLf & _
                            "  A.NO, " & vbCrLf & _
                            "  A.WRENCH_TTTT, " & vbCrLf & _
                            "  A.USE_BBBBB, " & vbCrLf & _
                            "  A.USE_VVVVV, " & vbCrLf & _
                            "  A.USE_AAAA, " & vbCrLf & _
                            "  A.USE_XXXX, " & vbCrLf & _
                            "  A.STANDARD_WWW, " & vbCrLf & _
                            "  A.QQQQ_LIMIT, " & vbCrLf & _
                            "  A.LWWW_LIMIT, " & vbCrLf & _
                            "  A.TENO, " & vbCrLf & _
                            "  A.NO_AASIGN " & vbCrLf & _
                            "  FROM MS_AAA A " & vbCrLf & _
                            "WHERE A.DELETE_FLG = '0' " & vbCrLf & _
                            "and A.NO LIKE '%' || :1 || '%'"