看看这句存储过程错在哪...
是语法错误,应该怎么改?
insert into Article (father_id, author_id, title, text)
values
(@father_id, select id from userinfo where username=@username, @title, @text)
谢谢~
[解决办法]
declare @authorID int
select @authorID = id from userinfo where username=@username
insert into Article (father_id, author_id, title, text)
values
(@father_id, @authorID, @title, @text)
[解决办法]
insert into Article (father_id, author_id, title, text)
values
(@father_id, select id from userinfo where username=@username, @title, @text)
SQL语法错误，不能这样用
可改为
insert into Article select @father_id, id , @title, @text from userinfo where username=@username
