Question

sql语句 where后使用变量？

SELECT [userid], [username], [userpwd], [usertype] FROM [user] WHERE usertype ='usrt'
usrt是变量int型值应该是2
请问后面怎么写？
不用"SELECT [userid], [username], [userpwd], [usertype] FROM [user] WHERE usertype ="&usrt,我试了不好用。

Answer 1

你是用的什么？asp么？如果是asp的话应该是这样

"SELECT userid，username,userpwd,usertype FROM user WHERE usertype ="& usrt &"

如果你数据库里定义的usertype不是int型而是String之类的非数字类型的话应该写成这样：
"SELECT userid，username,userpwd,usertype FROM user WHERE usertype ='"& usrt &"'"

Answer 2

单纯的SQL语句使用变量时,定义变量是: @usrt int.
如果你只是写在SQL企业查询器上就用(先定义一下@usrt):
"SELECT [userid], [username], [userpwd], [usertype] FROM [user] WHERE [usertype] =@usrt"

写在其它的地方.....没有去钻研了

Answer 3

"SELECT [userid], [username], [userpwd], [usertype] FROM [user] WHERE usertype =" & usrt
在VB中usrt最好是“sting”不过“integer”也可以，但是你的“&”前后都得加上空格

Answer 4

sql = "SELECT [userid], [username], [userpwd], [usertype] FROM [user] WHERE usertype = 0" & cstr(usrt)

这样好用了吧

Answer 5

"SELECT [userid], [username], [userpwd], [usertype] FROM [user] WHERE [usertype] =" & usrt
加上空格