تشکر مهندس از کمکتون
این جدول پرداخت وام هست
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Hesab](
[idHesab] [int] IDENTITY(1,1) NOT NULL,
[ShomareHesab] [int] NULL,
[idPersonal] [int] NULL,
[Bestankar] [int] NULL,
[Date] [nvarchar](200) NULL,
CONSTRAINT [PK_Hesab] PRIMARY KEY CLUSTERED
(
[idHesab] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
این جدول مبلغ وامم هست
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Vam](
[idVam] [int] IDENTITY(1,1) NOT NULL,
[ShomareHesab] [int] NULL,
[Name] [nvarchar](200) NULL,
[Mablagh] [int] NULL,
[NoGhest] [int] NULL,
[PriceGhest] [int] NULL,
[StartDate] [nvarchar](500) NULL,
[EndDate] [nvarchar](500) NULL,
[Comment] [ntext] NULL,
CONSTRAINT [PK_Vam] PRIMARY KEY CLUSTERED
(
[idVam] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO