DECLARE @Id Int                                                     
Select @Id = Id From sysobjects Where Name = 'PISReceivedPrescriptionDetail'
IF not Exists(SELECT * FROM syscolumns WHERE id = @Id and Name = 'PatientInstruction')
  Alter Table PISReceivedPrescriptionDetail Add PatientInstruction NVARCHAR(Max) ;

Select @Id = Id From sysobjects Where Name = 'PISReceivedPrescriptionDetail'
IF not Exists(SELECT * FROM syscolumns WHERE id = @Id and Name = 'SiteTerm')
  Alter Table PISReceivedPrescriptionDetail Add SiteTerm NVARCHAR(20) ;