create proc p_GetBakPath @file nvarchar(200) as
create table #t(logicalname nvarchar(200),
physicalname nvarchar(500),
type varchar(10),
filegroupname varchar(20),
size bigint,
maxsize bigint)
insert into #t exec('RESTORE FILELISTONLY FROM DISK = N''' + @file + '''')
select * from #tgo--调用:
P_GetBakPath '备份文件名'
create table #t(logicalname nvarchar(200),
physicalname nvarchar(500),
type varchar(10),
filegroupname varchar(20),
size bigint,
maxsize bigint)
insert into #t exec('RESTORE FILELISTONLY FROM DISK = N''' + @file + '''')
select * from #tgo--调用:
P_GetBakPath '备份文件名'
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货