북마크

2025/04/06 03:13

글쓰기

이름

이메일

홈페이지

암호

제목

HTML 사용

본문

***********************************************************
<pre>
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)
</pre>

***********************************************************

*엔터값이 2개들어간것을 1개로 변환(CR, LF, BR)

서명

# File 1