求助，代码不能用？

来源：百度知道 编辑：UC知道 时间：2024/05/21 16:20:10
有学电脑的朋友吗，帮我看一下这那有问题，万分的感谢
悬赏分：20 - 离问题结束还有 14 天 23 小时
有学电脑的朋友吗，帮我看一下这那有问题，万分的感谢
select b.backup_set_id,b.backup_finish_date,f.logical_name,f.physical_name, f.file_type, f.file_size,b.position
from msdb..backupfile f, msdb..backupset b where f.backup_set_id
in (select backup_set_id where database_name = N'v7')
and NOT (b.type = 'D' and f.file_type ='L')
and f.backup_set_id = b.backup_set_id and b.type != 'I'
order by b.backup_start_date
问题补充：我不能用，我不知道那里出错了，帮忙改正一下
不能用，
不知道
那里出错了
求助

select b.backup_set_id, b.backup_finish_date, f.logical_name, f.physical_name, f.file_type, f.file_size, b.position
from msdb.backupfile f, msdb.backupset b
where f.backup_set_id
in (select backup_set_id from <这里应该有个表名> where database_name = 'Nv7')
and NOT (b.type = 'D' and f.file_type ='L')
and f.backup_set_id = b.backup_set_id and b.type != 'I'
order by b.backup_start_date