GO
/****** Object:  Table [dbo].[PersonTbl]    Script Date: 04/30/2011 21:01:01 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
if not exists(SELECT
COLUMN_NAME
from information_schema.columns 
WHERE TABLE_NAME = 'invoiceDetailTbl' and COLUMN_NAME='DiscountPercent2')
Begin
Alter TABLE [dbo].[invoiceDetailTbl] ADD
	[DiscountPercent2] [float] NULL
End
Go
if not exists(SELECT
COLUMN_NAME
from information_schema.columns 
WHERE TABLE_NAME = 'ChangeinvoiceDetailTbl' and COLUMN_NAME='DiscountPercent2')
Begin
Alter TABLE [dbo].[ChangeinvoiceDetailTbl] ADD
	[DiscountPercent2] [float] NULL
End