数据插入有关问题尽量能写成存储过程的 待

数据插入问题尽量能写成存储过程的 在线等待

SQL code

INSERT INTO tb_NewsBoard(newsTitle,newsContent,newsDate,boardTitle,browseCount) values('1','1','1','下面查出来的值',0)select  boardTitle from tb_Board where managerID=以知

SQL code

crate proc pp@par1 varchar(100)asbegindeclare @v varchar(8000)select @v=boardTitle from tb_Board where managerID=@par1INSERT INTO tb_NewsBoard(newsTitle,newsContent,newsDate,boardTitle,browseCount)  values('1','1','1',@v,0)end