T SQL Script: Conditional ALTER TABLE script

-- Conditional ALTER TABLE script
IF NOT EXISTS (
    SELECT 1
    FROM sys.columns
    WHERE Name = N'ReceiptNo'
      AND Object_ID = Object_ID(N'dbo.tblMemorialInformation')
)
BEGIN
    ALTER TABLE dbo.tblMemorialInformation
    ADD ReceiptNo NVARCHAR(50) NULL;
END