我这样写不对
insert ItemData(MemberInfoID,txtProductName) ('10001这个不对',select txtProductName from CompanyProduct where id="+CompanyProductID+")"
insert ItemData(MemberInfoID,txtProductName) ('10001这个不对',select txtProductName from CompanyProduct where id="+CompanyProductID+")"
select '10001这个不对',txtProductName
from CompanyProduct where id=?
Declare @MemberInfoID Int
Set @MemberInfoID=1
insert ItemData(MemberInfoID,txtProductName) select @MemberInfoID,txtProductName from CompanyProduct where id=1