已知表 sys_tbluser有如下字段
depaid usernumber username
请教下面这句话提示错误怎么解决if @usern <>''
begin
declare @qxbm int
set @qxbm = select depaID from sys_tbluser where usernumber = @usern
depaid usernumber username
请教下面这句话提示错误怎么解决if @usern <>''
begin
declare @qxbm int
set @qxbm = select depaID from sys_tbluser where usernumber = @usern
set @usern = 1 -- 赋值
if @usern <> ''
begin
declare @qxbm int
set @qxbm = (select depaID from dbo.sys_tbluser where usernumber = @usern)
end
begin
declare @qxbm int
set @qxbm = select depaID from sys_tbluser where usernumber = @usern
declare @usern varchar(20)
if @usern <>''
begin
declare @qxbm int
set @qxbm = select depaID from sys_tbluser where usernumber = @usern
end
-->>
select @qxbm=depaID from sys_tbluser where usernumber = @usern