SQL Server 例句如下:
select count(*) as Total
from [dbo].[@ENGINEERINGITEM] AS T
where
EXISTS(
SELECT 1 FROM[dbo].[@ENGINEERINGITEM] WHERE DocEntry = '" + DocEntry + "' and U_BOMCode=T.U_BOMCode
)
在Exists中的语句可以现有表字段进行筛选。
SQL Server 例句如下:
select count(*) as Total
from [dbo].[@ENGINEERINGITEM] AS T
where
EXISTS(
SELECT 1 FROM[dbo].[@ENGINEERINGITEM] WHERE DocEntry = '" + DocEntry + "' and U_BOMCode=T.U_BOMCode
)
在Exists中的语句可以现有表字段进行筛选。