select * into 数据库.dbo.新表名 from 数据库.dbo.要复制的表
select * from labsubject where ISNUMERIC (textbookid )=1
update labsubject set textbookid=(select bookname from yq_book where id=cast(textbookid as int)) where ISNUMERIC (textbookid )=1
select * into 数据库.dbo.新表名 from 数据库.dbo.要复制的表
select * from labsubject where ISNUMERIC (textbookid )=1
update labsubject set textbookid=(select bookname from yq_book where id=cast(textbookid as int)) where ISNUMERIC (textbookid )=1