<wbr><p><span style="font-size:24px"></span></p> <p><span style="font-size:24px"></span></p> <p><span style="font-size:24px">例如:strsql =" selcet * from sp_table where xm= ' " & Text1.Text & " ' "</span></p> <p><span style="font-size:24px"></span></p> <p><span style="font-size:24px">用 & 连接字符串的时候会有些麻烦," "之间是一个字符串," " 和 " " 用& 连接</span></p> <p><span style="font-size:24px">假如Text1.Text的值是:李四</span></p> <p><span style="font-size:24px">那么应该写成:</span></p> <p><span style="font-size:24px">strsql = "select * from sp_where sp_table where xm= ' " 李四 " ' "</span></p> <p><span style="font-size:24px">现在把它分为三部分</span></p> <p><span style="font-size:24px"> "select * from sp_table where xm= ' "</span></p> <p><span style="font-size:24px"> 李四</span></p> <p><span style="font-size:24px"> " ' "</span></p> <p><span style="font-size:24px">李四换成 & Text1.Text &</span></p> <p><span style="font-size:24px">简单地说,双引号是给VB用的,单引号是给SQL语句用的。</span></p> <p><span style="font-size:24px"></span></p> <p><span style="font-size:24px">a= "b" 表示a为b</span></p> <p><span style="font-size:24px">a=" " b " " 表示a为" b "</span></p> <p><span style="font-size:24px">a=" " " " & "b" & " " " 表示a为 " b "</span></p> <p><span style="font-size:24px">a=" ' b ' " 表示a为 ' b '</span></p> <p><span style="font-size:24px">a=" ' " & " b " & " ' " 表示a为 ' b '</span></p> <p><span style="font-size:24px"></span></p> <p><span style="font-size:24px">推荐文章:</span></p> <p><a href="http://www.sudu.cn/info/html/edu/20080415/278459.html"><span style="font-size:24px">http://www.sudu.cn/info/html/edu/20080415/278459.html</span></a></p> </wbr>
vb中sql语句的单引号和双引号的用法
最新推荐文章于 2022-12-05 21:27:20 发布