none
Stored Proce for not inserting null value on composite primary key RRS feed

  • Question

  • Create Table #Finalabc (
    id int ,
    [Name] varchar (200),
    [date] datetime,
    adress varchar (200),
    PRIMARY KEY CLUSTERED 
    (
    id ASC,
    [name] ASC,
    [Date] asc 
    )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
    ) ON [PRIMARY]
    GO

    Create Table #Stageabc (
    id int ,
    [Name] varchar (200),
    [date] datetime,
    adress varchar (200))

    I want to create stored proc for loading data from stage to final table 
    , but if any of the Key coulumn has null value then it wont instert that records into final table.

    Wednesday, September 11, 2019 9:44 PM

Answers

All replies