Jennifer_Jinhong_34

Adding Additional CPs (above the default 5) - MS SQL

Discussion created by Jennifer_Jinhong_34 on Jan 23, 2014
Latest reply on Jun 3, 2016 by Luu_Le_185

Hi All, here's the SQL statement for adding additional CPs (above the default 5)

MSSQL

CREATE TABLE MQCP006 (
MQCP_PK int IDENTITY NOT NULL,
MQCP_System varchar (8) NULL,
MQCP_CAddr varchar (32) NULL,
MQCP_CSRName varchar (8) NULL,
MQCP_CAcv int NULL,
MQCP_BAddr varchar (32) NULL,
MQCP_BSRName varchar (8) NULL,
MQCP_BAcv int NULL,
MQCP_FAddr varchar (32) NULL,
MQCP_LogAddr varchar (32) NULL,
MQCP_PhysAddr varchar (32) NULL,
MQCP_BTable varchar (8) NULL,
MQCP_SchedTime datetime NULL,
MQCP_Status int NULL,
MQCP_Priority int NULL,
MQCP_DRole varchar (32) NULL,
MQCP_LAddr varchar (32) NULL,
MQCP_Len int NULL,
MQCP_Msg varbinary (max) NULL,
CONSTRAINT PK_MQCP006 PRIMARY KEY NONCLUSTERED ( MQCP_PK) )
GO

CREATE INDEX NK_MQCP001_BAcv ON MQCP006(MQCP_BAcv)
GO

CREATE CLUSTERED INDEX NK_MQCP001_Prio ON MQCP006(MQCP_Priority, MQCP_SchedTime, MQCP_PK, MQCP_Status)
GO

Outcomes