开始学习存储过程,查询语句中的变量问题
create procedure CheckUserId12
(@TextBox1Text varchar)
as
select * from visitor where userid=@TextBox1Text
GO
execute CheckUserId12 asd表是这样的
uerid uername passworldasd asd asd
但是查询不到
create procedure CheckUserId12
(@TextBox1Text varchar)
as
select * from visitor where userid=@TextBox1Text
GO
execute CheckUserId12 asd表是这样的
uerid uername passworldasd asd asd
但是查询不到
(@TextBox1Text varchar(100)) --1.要定义长度
as
select * from visitor where userid=@TextBox1Text
GO
execute CheckUserId12 'asd' --2.字符型要加引号