SHARE
TWEET

Utils

mhamdani049 Jun 29th, 2020 (edited) 1,201 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. ALTER TABLE spex.TB_R_REPORT_PROBLEM ADD REFILL_QTY INT NULL;
  2.  
  3. USE [SPEX_DB]
  4. GO
  5. /** Object:  Table [dbo].[TB_R_REFILL]    Script Date: 2/11/2020 5:50:50 PM **/
  6. SET ANSI_NULLS ON
  7. GO
  8. SET QUOTED_IDENTIFIER ON
  9. GO
  10. CREATE TABLE [dbo].[TB_R_REFILL](
  11.     [ID] [INT] IDENTITY(1,1) NOT NULL,
  12.     [TRANSFER_NO] [VARCHAR](MAX) NOT NULL,
  13.     [BT_NO] [VARCHAR](MAX) NOT NULL,
  14.     [PART_NO] [VARCHAR](MAX) NOT NULL,
  15.     [QTY] [INT] NULL,
  16.     [CREATED_BY] [VARCHAR](MAX) NOT NULL,
  17.     [CREATED_DT] [datetime] NOT NULL,
  18.     [CHANGED_BY] [VARCHAR](MAX) NULL,
  19.     [CHANGED_DT] [datetime] NULL
  20. ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
  21. GO
  22.  
  23. ALTER TABLE dbo.TB_R_REFILL ADD SOURCE VARCHAR (MAX) NULL;
  24. ALTER TABLE dbo.TB_R_REFILL ADD RACK_ADDRESS VARCHAR (MAX) NULL;
  25. -- ALTER TABLE dbo.TB_R_REFILL ADD IS_BINNING INT  NOT NULL DEFAULT(0);
RAW Paste Data
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand
Top