• 2024/05/03 23:18
  • 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
    À̸§ ªÀº±Û ³¯Â¥ »èÁ¦
    ÇöÀç ³²°ÜÁø ±ÛÀÌ ¾ø½À´Ï´Ù.
    ¾ÏÈ£