CREATE PROCEDURE rs_main_user
@name varchar(30)
with encryption
AS select * from main_users
where username = @name
go
exec rs_main_user提示我没有声明变量@name,请问大家这个是咋回事,谢谢
@name varchar(30)
with encryption
AS select * from main_users
where username = @name
go
exec rs_main_user提示我没有声明变量@name,请问大家这个是咋回事,谢谢
@name varchar(30)=NULL
with encryption
AS
if @name is null
select * from main_users
else
select * from main_users
where username = @name
go exec rs_main_user