10월 2009 - 어느용

오라클에서 컬럼 명들을 가지고 오는 쿼리

select *
from dba_col_comments
where 1=1
and owner='anyxxxxxx'
and comments is NULL
and able_name not like 'BIN$%'
order by table_name

select *

from dba_col_comments

where 1=1

and owner='anyxxxxxx'

and comments is NULL

and able_name not like 'BIN$%'

order by table_name

오라클에서 테이블 명들을 가지고 오는 쿼리

select *
from dba_tab_comments
where 1=1
and owner='anyxxxxxx'
and comments is NULL
and table_name not like 'BIN$%'
order by table_name

select *

from dba_tab_comments

where 1=1

and owner='anyxxxxxx'

and comments is NULL

and table_name not like 'BIN$%'

order by table_name

sql server 백업을 하게 하기 위한 스크립트

"C:\Program Files\Microsoft SQL Server90\Tools\Binn\sqlcmd" -S localhost -i e:\Backupbackup.sql

1	"C:\Program Files\Microsoft SQL Server90\Tools\Binn\sqlcmd" -S localhost -i e:\Backupbackup.sql

풀백업

declare @runtime nvarchar(10)
declare @backupdevice nvarchar(100)
declare @backupname nvarchar(100)

set @runtime = substring(convert(nvarchar(20), getdate(), 8) ,1,2)
set @backupdevice = N'e:\Backupbackup_' + @runtime + N'.bak'
set @backupname = N'backup_' + @runtime

BACKUP DATABASE [TU] TO DISK = @backupdevice WITH NOFORMAT, INIT, NAME = @backupname, SKIP, NOREWIND, NOUNLOAD, STATS = 10

declare @runtime nvarchar(10)

declare @backupdevice nvarchar(100)

declare @backupname nvarchar(100)

set @runtime = substring(convert(nvarchar(20), getdate(), 8) ,1,2)

set @backupdevice = N'e:\Backupbackup_' + @runtime + N'.bak'

set @backupname = N'backup_' + @runtime

BACKUP DATABASE [TU] TO DISK = @backupdevice WITH NOFORMAT, INIT, NAME = @backupname, SKIP, NOREWIND, NOUNLOAD, STATS = 10

증분 백업

declare @runtime nvarchar(10)
declare @backupdevice nvarchar(100)
declare @backupname nvarchar(100)

set @runtime = substring(convert(nvarchar(20), getdate(), 8) ,1,2)
set @backupdevice = N'e:\Backupbackup_' + @runtime + N'.bak'
set @backupname = N'backup_' + @runtime

BACKUP DATABASE [TU] TO DISK = @backupdevice WITH DIFFERENTIAL, NOFORMAT, INIT, NAME = @backupname, SKIP, NOREWIND, NOUNLOAD, STATS = 10