22,300
社区成员




SELECT TOP (100) PERCENT dbo.tower.serialNum, dbo.survey.name,
dbo.survey.localdesc, dbo.survey.terraindesc, dbo.survey.owner,
dbo.survey.version, dbo.survey.status, dbo.survey.submittime,
(select count(*) from dbo.hole where id = dbo.survey.id) as my_count
FROM dbo.survey INNER JOIN
dbo.surveytable ON dbo.survey.id = dbo.surveytable.surveyid INNER JOIN
dbo.soil ON dbo.survey.id = dbo.soil.surveyid INNER JOIN
dbo.hole ON dbo.survey.id = dbo.hole.surveyid INNER JOIN
dbo.tower ON dbo.survey.towerid = dbo.tower.id
ORDER BY dbo.survey.submittime
SELECT TOP (100) PERCENT dbo.tower.serialNum, dbo.survey.name,
dbo.survey.localdesc, dbo.survey.terraindesc, dbo.survey.owner,
dbo.survey.version, dbo.survey.status, dbo.survey.submittime
FROM dbo.survey INNER JOIN
dbo.surveytable ON dbo.survey.id = dbo.surveytable.surveyid INNER JOIN
dbo.soil ON dbo.survey.id = dbo.soil.surveyid INNER JOIN
dbo.hole ON dbo.survey.id = dbo.hole.surveyid INNER JOIN
dbo.tower ON dbo.survey.towerid = dbo.tower.id
ORDER BY dbo.survey.submittime
declare @num int,
@sqls nvarchar(4000)
set @sqls='select @a=count(*) from V_test '
exec sp_executesql @sqls,N'@a int output',@num output
select @num
select count(*) from my_view
where exists (select 1 from table1 where id = my_view.id)