create proc sea
as
declare @num char
declare @pwd char
go
set @num=(select usernum from table1 where username='陆勋')
go
set @pwd=(select userpwd from table1 where username='陆勋')
print @num,@pwd检查语法的时候提示@num @pwd使用前必须声明
as
declare @num char
declare @pwd char
go
set @num=(select usernum from table1 where username='陆勋')
go
set @pwd=(select userpwd from table1 where username='陆勋')
print @num,@pwd检查语法的时候提示@num @pwd使用前必须声明
create proc sea
as
declare @num char
declare @pwd char
select @num=usernum from table1 where username='陆勋'
select @pwd=userpwd from table1 where username='陆勋'print @num,@pwd