日期:2014-05-18 浏览次数:20538 次
INSERT INTO tb_NewsBoard(newsTitle,newsContent,newsDate,boardTitle,browseCount) values('1','1','1','下面查出来的值',0) select boardTitle from tb_Board where managerID=以知
crate proc pp @par1 varchar(100) as begin declare @v varchar(8000) select @v=boardTitle from tb_Board where managerID=@par1 INSERT INTO tb_NewsBoard(newsTitle,newsContent,newsDate,boardTitle,browseCount) values('1','1','1',@v,0) end