是语法错误,应该怎么改?
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