g********d
发帖数: 2022 | 1 你那个方法我没看懂，详细说说？
可以这样生成一个macro v：
proc sql noprint;
select crdate into :crdate
from sashelp.vtable
where libname="" and memname="";
quit;
%put &crdate; |
|
B*****g
发帖数: 34098 | 2 曾哥度假也要回答技术问题
【 以下文字转载自 Database 讨论区 】
发信人: zenny (素能), 信区: Database
标 题: Re: 各位各位，江湖救急 -- 数据被删
发信站: BBS 未名空间站 (Tue May 1 08:44:27 2012, 美东)
Please run this script first. Check the database properties first to get the
create date of the database
select * from sysdatabases
the crdate(?) is the create date for that database.
Then run the following script to find out available backups.
I'm on vacation now. So cannot verify the following script. If there's typo
or grammar error, please correct it y... 阅读全帖 |
|
z***y
发帖数: 7151 | 3 Please run this script first. Check the database properties first to get the
create date of the database
select * from sysdatabases
the crdate(?) is the create date for that database.
Then run the following script to find out available backups.
I'm on vacation now. So cannot verify the following script. If there's typo
or grammar error, please correct it yourself:
SELECT
msdb.dbo.backupset.database_name,
msdb.dbo.backupset.backup_start_date,
msdb.dbo.backupset.backup_finish_date,
... 阅读全帖 |
|
