当我尝试使用多个select语句运行insert语句时,将出现错误。
,(select top 20 percent lname from ZZZ_FKP_NEW_PATIENT order by newid())但是,当我使用单个语句运行insert语句时,此查询将成功运行,如下所示:
insert into zzz_fkp_tbl2 (lnam
对于内部控制,我们希望为多个发票类型和地区中的每一个选择一张随机发票。InvoiceType,RegionID group by InvoiceType, RegionID SELECT top 1 ,InvoiceNum FROM Invoices
JOIN Customers on Customers.CustomerID=Inv