Programming Archives - 25 중 23 번째 페이지

함수 포인터 샘플

#include

#define COMMAND(NAME) {
  #NAME,
  NAME # # _command
}

using namespace std;

struct command {
  char * name;
  void( * function)(int r_nArg);
};

void quit_command(int r_nArg) {
  cout << "quit_command " << r_nArg;
}
void help_command(int r_nArg) {
  cout << "help_command " << r_nArg;
}
struct command commands1[] = {
  {
    "help",
    help_command
  },
  {
    "quit",
    quit_command
  },
};
struct command commands2[] = {
  COMMAND(help),
  COMMAND(quit),
};
int _tmain(int argc, _TCHAR * argv[]) {
  commands1[0].function(3000);
  cout << endl;
  commands1[1].function(5000);
  return 0;
}

#include

#define COMMAND(NAME) {

#NAME,

NAME # # _command

}

using namespace std;

struct command {

char * name;

void( * function)(int r_nArg);

};

void quit_command(int r_nArg) {

cout << "quit_command " << r_nArg;

}

void help_command(int r_nArg) {

cout << "help_command " << r_nArg;

}

struct command commands1[] = {

{

"help",

help_command

{

"quit",

quit_command

};

struct command commands2[] = {

COMMAND(help),

COMMAND(quit),

};

int _tmain(int argc, _TCHAR * argv[]) {

commands1[0].function(3000);

cout << endl;

commands1[1].function(5000);

return 0;

}

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

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 Server\90\Tools\Binn\sqlcmd" -S localhost -i e:\Backup\backup.sql

1	"C:\Program Files\Microsoft SQL Server\90\Tools\Binn\sqlcmd" -S localhost -i e:\Backup\backup.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:\Backup\backup_' + @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:\Backup\backup_' + @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:\Backup\backup_' + @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

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:\Backup\backup_' + @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

anydragon

참고자료

최신 글

보관함

함수 포인터 샘플

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

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

태그

링크

메타