存储过程参数问题
create procedure notesystem_createaddressbook
(@loginname char(20) ,@addressbookname char(20))
as
Declare @userid int
select userid from userinfo where username = @loginname)
set @userid = userid ------为什么不能让userid附值给@userid
if not exists(select * from addressbook where addressbookname = @addressbookname and owneruserid = @userid)
insert into Addressbook(owneruserid,addressbookname) values (@userid ,@addressbookname)
go
@loginname 和 @addressbookname 是外面传近来的参数
问题是如何在存储过程中另建1个参数让select语句查询出来的值附给它