vb中sql语句的单引号和双引号的用法

<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= ' " &amp; Text1.Text &amp; " ' "</span></p> <p><span style="font-size:24px"></span></p> <p><span style="font-size:24px">用 &amp; 连接字符串的时候会有些麻烦，" "之间是一个字符串，" " 和 " " 用&amp; 连接</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">李四换成 &amp; Text1.Text &amp;</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=" " " " &amp; "b" &amp; " " " 表示a为 " b "</span></p> <p><span style="font-size:24px">a=" ' b ' " 表示a为 ' b '</span></p> <p><span style="font-size:24px">a=" ' " &amp; " b " &amp; " ' " 表示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>