Vérifier si l'élément existe déjà avant création de trigger-tables-insertion dans SQL serveur
01/01/2019 |
Admin |
Sql Server
- Trigger
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
IF EXISTS (SELECT * FROM sys.objects WHERE [type] = 'TR' AND [name] = 'MyTrigger' )
DROP TRIGGER MyTrigger;
GO
-- =============================================
-- Author:<Author,,Name>
-- Create date: <Create Date,,>
-- Description:<Description,,>
-- =============================================
CREATE TRIGGER [ MyTrigger ]
ON ...
- Table
IF NOT EXISTS (SELECT * FROM dbo.sysobjects WHERE name = 'MyTable')
CREATE TABLE [dbo].[ MyTable ](....
- Insertion de données
IF NOT EXISTS (SELECT id FROM [MyTable] WHERE [Name] = 'toto')
INSERT INTO [ MyTable ]
([Name]
,[Code])
VALUES
('toto'
,'007')
- View
IF EXISTS (SELECT TABLE_NAME FROM INFORMATION_SCHEMA.VIEWS WHERE TABLE_NAME = 'MyView')
DROP VIEW MyView
GO
CREATE VIEW MyView
AS
....
GO