CREATE PROCEDURE getpassword @u_name char(10) AS select u_pass,role from users where u_name=@u_name GO
不知道你的u_name是char还是varchar类型 可以这样CREATE PROCEDURE getpassword @u_name varchar(50) --或者用你需要的长度代替50 AS select u_pass,role from users where rtrim(u_name)=rtrim(@u_name) GO
AS
select u_pass,role from users where u_name=@u_name
GO
可以这样CREATE PROCEDURE getpassword @u_name varchar(50) --或者用你需要的长度代替50
AS
select u_pass,role from users where rtrim(u_name)=rtrim(@u_name)
GO
定义u_name 的时候没指定字段长度!
晕啊!