Trigger, View, Store procedure

Trigger

Create

CREATE TRIGGER trigger_name
ON table_name | view_name
{AFTER, FOR, INSTEAD OF} UPDATE | INSERT | DELETE
AS
BEGIN
    DECLARE @valiable
    SET @varliable = ....--up to you
    --Your code
END

Alter

ALTER TRIGGER trigger_name
ON table_name | view_name
{AFTER, FOR, INSTEAD OF} UPDATE | INSERT | DELETE
AS
BEGIN
    DECLARE @valiable
    SET @varliable = ....--up to you
    --Your code
END

Delete

DROP TRIGGER trigger_name

---

View

Create

CREATE VIEW view_name AS
SELECT *
FROM table_name
WHERE condition

Update

REPLACE VIEW view_name AS
SELECT *
FROM table_name
WHERE condition

Delete

DROP VIEW view_name

---

Store procedure

Create

CREATE PROCEDURE procedure_name [@variable type]
AS
sql_statement
GO

use

EXEC procedure_name @variable = data

Delete

DROP PROCEDURE procedure_name