IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[CheckInsForPrintTBL]') AND type in (N'U'))
DROP TABLE [dbo].[CheckInsForPrintTBL]
GO
/****** Object:  Table [dbo].[CheckInsForPrintTBL]    Script Date: 05/12/2011 19:17:55 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
if not exists(SELECT
COLUMN_NAME
from information_schema.columns 
WHERE TABLE_NAME = 'CheckInTBL' and COLUMN_NAME='BeHesabDate')
Begin
Alter TABLE [dbo].[CheckInTBL] ADD
	[BeHesabDate] char(8) NULL
End
GO
CREATE TABLE [dbo].[CheckInsForPrintTBL](
	[Radif] [int] NOT NULL,
	[SerialNo] [bigint] NOT NULL,
	[ACCNo] [nvarchar](1000) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
	[CheckDate] [char](8) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
	[BankName] [nvarchar](1000) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
	[Amount] [money] NOT NULL
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF