ببخشید چشم الان میزارم
اول جدول مشترکینم رو میزارم بعدش هم جدول اطلاعات جزئی و بعد هم تریگری که نوشتم
CREATE TABLE [dbo].[Costumers](
[Costumer_ID] [int] IDENTITY(1,1) NOT NULL,
[First_Name] [nvarchar](30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Last_Name] [nvarchar](40) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Official_Name] [nvarchar](30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Job_Name] [nvarchar](40) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Birth_Date] [smalldatetime] NULL CONSTRAINT [DF_Costumers_Birth_Date] DEFAULT ((0)),
[Location_BirthDate] [nvarchar](30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL CONSTRAINT [DF_Costumers_Location_BirthDate] DEFAULT ((0)),
[Sex] [tinyint] NULL CONSTRAINT [DF_Costumers_Sex] DEFAULT ((0)),
[Marriad] [tinyint] NULL CONSTRAINT [DF_Costumers_Marriad] DEFAULT ((0)),
[Black_List] [tinyint] NULL CONSTRAINT [DF_Costumers_Black_List] DEFAULT ((0)),
[Costumer_Type] [tinyint] NULL CONSTRAINT [DF_Costumers_Costumer_Type] DEFAULT ((0)),
[Activity_ID] [int] NULL,
[Department_ID] [int] NOT NULL,
[Favourits] [tinyint] NULL CONSTRAINT [DF_Costumers_Favourits] DEFAULT ((0)),
CONSTRAINT [PK_Costumers_1] PRIMARY KEY CLUSTERED
(
[Costumer_ID] ASC
)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
USE [phonNumber]
GO
ALTER TABLE [dbo].[Costumers] WITH CHECK ADD CONSTRAINT [FK_Costumers_Activity] FOREIGN KEY([Activity_ID])
REFERENCES [dbo].[Activity] ([Activity_ID])
GO
ALTER TABLE [dbo].[Costumers] WITH CHECK ADD CONSTRAINT [FK_Costumers_Department] FOREIGN KEY([Department_ID])
REFERENCES [dbo].[Department] ([Department_ID])
CREATE TABLE [dbo].[costumer_Phon_Details](
[Row_ID] [bigint] IDENTITY(1,1) NOT NULL,
[Costumer_ID] [int] NOT NULL,
[Type_ID] [tinyint] NOT NULL,
[Details] [nvarchar](200) COLLATE Arabic_CI_AS NOT NULL,
CONSTRAINT [PK_costumer_Phon_Details] PRIMARY KEY CLUSTERED
(
[Row_ID] ASC
)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
USE [phonNumber]
GO
ALTER TABLE [dbo].[costumer_Phon_Details] WITH CHECK ADD CONSTRAINT [FK_costumer_Phon_Details_costumers] FOREIGN KEY([Costumer_ID])
REFERENCES [dbo].[Costumers] ([Costumer_ID])
GO
ALTER TABLE [dbo].[costumer_Phon_Details] WITH CHECK ADD CONSTRAINT [FK_costumer_Phon_Details_PhonType] FOREIGN KEY([Type_ID])
REFERENCES [dbo].[phonTypes] ([Type_ID])
set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
go
-- =============================================
-- Author: Alireza
-- Create date: <Create Date,,>
-- Description: Delete Phon types
-- =============================================
ALTER TRIGGER [TR_Delete_Phon_Details]
ON [dbo].[costumer_Phon_Details]
AFTER DELETE
AS
BEGIN
Delete dbo.costumer_Phon_Details where Costumer_ID in (Select Costumer_ID from Deleted)
END
آموزش کار با تریگر
پاسخ با نقل قول
نوشته شده توسط You-See
شرمنده خواستم سرعت به جواب رسیدن تو انجمن رو تست کنم!!!
