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语句查询出来的值附给它
(@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语句查询出来的值附给它
create procedure notesystem_createaddressbook
(@loginname char(20) ,@addressbookname char(20))
as
Declare @userid int
select @userid=userid from userinfo where username = @loginname)
if not exists(select * from addressbook where addressbookname = @addressbookname and owneruserid = @userid)
insert into Addressbook(owneruserid,addressbookname) values (@userid ,@addressbookname)
go
说明@userid没得到select到的userid吧
(@loginname char(20) ,@addressbookname char(20))
as
Declare @userid int
SET @userid=(select userid from userinfo where username = @loginname)
if not exists(select * from addressbook where addressbookname = @addressbookname and owneruserid = @userid)
insert into Addressbook(owneruserid,addressbookname) values (@userid ,@addressbookname)
go
这种写法是没问题的,你查一下是不是别的原因吧
比如你提供的参数有没有可匹配记录,char(20)是否可以容纳参数内容等等
在页面2用string loginname = Convert.ToString(Session["loginname"]);为什么得不到呢~