Does anyone know whether I need to do 3 separate statements to achieve the following, a single statement doesn't seem to work?
ALTER TABLE AdmixCorr
ALTER COLUMN AdmixCorrID INT NOT NULL,
ALTER COLUMN AdmixCorrRef VARCHAR(20) NOT NULL,
ADD COLUMN DateImp DATETIME NOT NULL
Thanks in advance
ALTER TABLE AdmixCorr
ALTER COLUMN AdmixCorrID INT NOT NULL,
ALTER COLUMN AdmixCorrRef VARCHAR(20) NOT NULL,
ADD COLUMN DateImp DATETIME NOT NULL
Thanks in advance