|
Novice sql
Last post 05-19-2008, 5:34 PM by tebbaerty. 26 replies.
-
05-13-2008, 3:52 PM |
-
05-13-2008, 4:12 PM |
-
05-13-2008, 4:14 PM |
-
05-14-2008, 10:32 AM |
-
05-14-2008, 1:20 PM |
-
05-14-2008, 1:28 PM |
-
B_gd_n[ ]Sahlean
-
-
-
Joined on 07-17-2007
-
Bucuresti
-
sysadmin
-
-
|
tebbaerty: ... de ce la tine sunt facute mai usor FK decat la mn ? mi se pare diferenta de cod mult prea mare intre noi 2 :)
Este vorba de o simplă diferenţă de sintaxă. Rezultatul este asemănător. Cheile externe sunt restricţii (en. CONSTRAINT). În cazul sintaxei utilizate de mine: CodLocalitate REFERENCES Localitate(CodLocalitate) SQL Server va atribui automat un nume acestei restricţii, în timp ce în cazul tău, denumirea restricţiei (CONSTRAINT) va fi cea specificată de tine: constraint FK_Phone_CompanyId !
|
|
-
05-14-2008, 4:32 PM |
-
05-14-2008, 8:04 PM |
-
05-14-2008, 8:40 PM |
-
Gherry
-
-
-
Joined on 10-12-2006
-
-
sysadmin
-
-
|
asta ar fi codul trigger-ului pt delete: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 | USE [Eug_tests] GO /****** Object: Trigger [dbo].[DeleteCompany] Script Date: 05/14/2008 20:29:43 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO -- ============================================= -- Author: <Author,,Name> -- Create date: <Create Date,,> -- Description: <Description,,> -- ============================================= CREATE TRIGGER [dbo].[DeleteCompany] ON [dbo].[Companii] for Delete AS BEGIN -- SET NOCOUNT ON added to prevent extra result sets from -- interfering with SELECT statements. SET NOCOUNT ON; INSERT INTO Istorie_Op_Companii (id_companie, alte_date_companie, operatie) SELECT Id, alte_date, 'stergere' AS Expr1 FROM Deleted -- Insert statements for trigger here
END |
asta ar fi pt insert: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 | USE [Eug_tests] GO /****** Object: Trigger [dbo].[InsertCompany] Script Date: 05/14/2008 20:34:52 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO -- ============================================= -- Author: <Author,,Name> -- Create date: <Create Date,,> -- Description: <Description,,> -- ============================================= CREATE TRIGGER [dbo].[InsertCompany] ON [dbo].[Companii] for Insert AS BEGIN -- SET NOCOUNT ON added to prevent extra result sets from -- interfering with SELECT statements. SET NOCOUNT ON; INSERT INTO Istorie_Op_Companii (id_companie, alte_date_companie, operatie) SELECT Id, alte_date, 'inserare' AS Expr1 FROM Inserted -- Insert statements for trigger here
END |
tabelele folosite: 1. Companii 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 | USE [Eug_tests] GO /****** Object: Table [dbo].[Companii] Script Date: 05/14/2008 20:30:54 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[Companii]( [Id] [int] IDENTITY(1,1) NOT NULL, [alte_date] [nvarchar](50) NULL, CONSTRAINT [PK_Companii] PRIMARY KEY CLUSTERED ( [Id] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] |
2. Istorie_Op_Companii 1 2 3 4 5 6 7 8 9 10 11 12 13 | USE [Eug_tests] GO /****** Object: Table [dbo].[Istorie_Op_Companii] Script Date: 05/14/2008 20:31:29 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[Istorie_Op_Companii]( [Id_istoric] [int] IDENTITY(1,1) NOT NULL, [operatie] [nvarchar](50) NULL, [id_companie] [int] NULL, [alte_date_companie] [nvarchar](50) NULL ) ON [PRIMARY] |
sper ca e de folos :)
|
|
-
05-14-2008, 9:26 PM |
-
05-15-2008, 10:16 AM |
-
tebbaerty
-
-
-
Joined on 05-13-2008
-
-
db_owner
-
-
|
CREATE TRIGGER [dbo].[DeleteCompany] ON [dbo].[Companii] for Delete AS BEGIN -- SET NOCOUNT ON added to prevent extra result sets from -- interfering with SELECT statements. SET NOCOUNT ON; INSERT INTO Istorie_Op_Companii (id_companie, alte_date_companie, operatie) SELECT Id, alte_date, 'stergere' AS Expr1 FROM Deleted -- Insert statements for trigger here
END
care e faza cu cu SELECT Id, alte_date, 'stergere' AS Expr1 FROM Deleted
mai exact acel AS Expr1 ... si din cate inteleg tabela Deleted este o tabela temporara creata cand este apelat Delete nu ?
|
|
-
05-15-2008, 10:25 AM |
-
05-15-2008, 10:38 AM |
-
05-15-2008, 11:25 AM |
-
05-15-2008, 11:31 AM |
Page 1 of 2 (27 items)
1
|
|
|