question

Hi Experts ,My developer write below TSQL query and asked me to review it . what steps should i take ?and how i do i test it ? BEGIN INSERT INTO nsConfig (MachineName, PropertyName, PropertyValue) VALUES ('*', 'PurgeDocumentsBatchSize', '1000'); END IF NOT EXISTS( SELECT * FROM sys.schemas s INNER JOIN sys.tables t ON s.schema_id = t.schema_id INNER JOIN sys.columns c ON t.object_id = c.object_id WHERE s.name = 'dbo' AND t.name = 'nsTransactionProperties' AND c.name = 'ToBePurgedDate' ) BEGIN ALTER TABLE nsTransactionProperties ADD ToBePurgedDate DATETIME NULL; END IF NOT EXISTS( SELECT * FROM sys.schemas s INNER JOIN sys.tables t ON s.schema_id = t.schema_id INNER JOIN sys.columns c ON t.object_id = c.object_id WHERE s.name = 'dbo' AND t.name = 'nsPDFDocument' AND c.name = 'PurgedDocumentHash' ) BEGIN ALTER TABLE nsPDFDocument ADD PurgedDocumentHash VARBINARY(MAX) NULL; END END thanks