• 2026/10/15 15:35
  • Login
    글읽기
      제목: in_memory
      번호: 179  이름: 나그네  조회수: 0
      이메일:   홈페이지: http://

    DECLARE @S_SQL NVARCHAR(4000)

    SET @S_SQL = ''
    SET @S_SQL = @S_SQL + N'CREATE TABLE dbo.t_ItemsSale_20191106_inmem ( '
    SET @S_SQL = @S_SQL + N' [seq] [int] IDENTITY(1,1) NOT NULL, '
    SET @S_SQL = @S_SQL + N' [open_dt] [varchar](10) NOT NULL, '
    SET @S_SQL = @S_SQL + N' [item_cd] [varchar](10) NOT NULL, '
    SET @S_SQL = @S_SQL + N' [sale_dt] [datetime] NOT NULL, '
    SET @S_SQL = @S_SQL + N' [ask_price] [int] NOT NULL, '
    SET @S_SQL = @S_SQL + N' [bid_price] [int] NOT NULL, '
    SET @S_SQL = @S_SQL + N' [sale_price] [int] NOT NULL, '
    SET @S_SQL = @S_SQL + N' [change_price] [int] NULL, '
    SET @S_SQL = @S_SQL + N' [change_per] [decimal](5, 2) NULL, '
    SET @S_SQL = @S_SQL + N' [sale_qty] [int] NOT NULL, '
    SET @S_SQL = @S_SQL + N' [total_qty] [int] NULL, '
    SET @S_SQL = @S_SQL + N' [sale_amt] [bigint] NULL, '
    SET @S_SQL = @S_SQL + N' [total_amt] [bigint] NULL, '
    SET @S_SQL = @S_SQL + N' [sale_per] [decimal](5, 2) NULL, '
    SET @S_SQL = @S_SQL + N' [is_sign] [int] NULL, '
    SET @S_SQL = @S_SQL + N' [input_tp] [tinyint] NULL, '
    SET @S_SQL = @S_SQL + N' [prev_total_qty] [int] NOT NULL, '
    SET @S_SQL = @S_SQL + N' [cl_price] [int] NOT NULL, '
    SET @S_SQL = @S_SQL + N' [prev_per] [decimal](9, 2) NULL, '
    SET @S_SQL = @S_SQL + N' [change_per_max] [decimal](5, 2) NULL, '
    SET @S_SQL = @S_SQL + N' [reg_dt] [datetime] NULL, '
    SET @S_SQL = @S_SQL + N'PRIMARY KEY CLUSTERED '
    SET @S_SQL = @S_SQL + N'( '
    SET @S_SQL = @S_SQL + N' [seq] DESC '
    SET @S_SQL = @S_SQL + N') WITH (MEMORY_OPTIMIZED=ON) ON [PRIMARY] '
    SET @S_SQL = @S_SQL + N') ON [PRIMARY] '
    EXEC (@S_SQL)

      관련글
    in_memory
    이름 짧은글 날짜 삭제
    현재 남겨진 글이 없습니다.
    암호