ETL Architecture: 01 Create BathPool Table
来源:互联网 发布:固结试验报告数据 编辑:程序博客网 时间:2024/04/28 17:32
CREATE TABLE [dbo].[ETLBatchPool](
[BatchID] [bigint] IDENTITY(1,1) NOT NULL,
[BatchStatus] [tinyint] NULL,
[Generator] [nvarchar](100) NULL,
[GenerateTime] [datetime] NULL,
[ProcessStartTime] [datetime] NULL,
[ProcessEndTime] [datetime] NULL,
InsertTime [datetime] NULL,
[UpdateTime] [datetime] NULL
[BatchID] [bigint] IDENTITY(1,1) NOT NULL,
[BatchStatus] [tinyint] NULL,
[Generator] [nvarchar](100) NULL,
[GenerateTime] [datetime] NULL,
[ProcessStartTime] [datetime] NULL,
[ProcessEndTime] [datetime] NULL,
InsertTime [datetime] NULL,
[UpdateTime] [datetime] NULL
) ON [PRIMARY]
CREATE procedure [dbo].[sp_ETLGenerateBatchID]
@User nvarchar(100) = NULL,
@BatchID int output
as
begin
if (@User is null)
set @User = ORIGINAL_LOGIN();
insert into ETLBatchPool(BatchStatus,Generator,GenerateTime,InsertTime,UpdateTime)
values(0,@User,GETDATE(),GETDATE(),GETDATE());
set @BatchID = SCOPE_IDENTITY();
end
0 0
- ETL Architecture: 01 Create BathPool Table
- ETL Architecture: 02 Create Source Table
- ETL Architecture: 03 Create ProcessRecord Table
- create table
- CREATE TABLE
- CREATE TABLE
- create table
- Create Table
- Create table
- create table
- CREATE TABLE
- create table
- create table
- CREATE TABLE
- CREATE TABLE
- CREATE TABLE
- Create Table中的秘密!
- php create html-table
- IEnumerable和IEnumerator 详解
- Android消息队列模型——Thread,Handler,Looper,Massage Queue
- 即将到来的2015
- Linux之Makefile(# ?=)
- 托福语法指导-并列连词及真题要点解析
- ETL Architecture: 01 Create BathPool Table
- java泛型实现链表基本操作
- 项目范围管理
- Activity生命周期
- Axure产品原型在手机上如何运行
- Quartz 2D编程指南(1) - 概览
- 【ASYNC IO】HP-UNIX_ORACLE10G_ASYNC IO ERROR
- Yii 2.0 路由管理美化URL
- Mysql取某个范围内随机日期 FLOOR和LPAD