Sử dụng trigger trong SQL qua ví dụ cơ bản - Trang Chủ

span

class

“token comment”

/* cập nhật hàng trong kho sau khi đặt hàng hoặc cập nhật */

span

class

“token keyword”

CREATE

span

class

“token keyword”

TRIGGER

span

trg_DatHang

span

class

“token keyword”

span

tbl_DatHang

span

class

“token keyword”

AFTER

span

class

“token keyword”

INSERT

span

class

“token keyword”

span

class

“token keyword”

BEGIN

span

class

“token keyword”

UPDATE

span

tbl_KhoHang

span

class

“token keyword”

SET

span

SoLuongTon

span

class

“token operator”

span

SoLuongTon

span

class

“token operator”

–

span

class

“token punctuation”

(

span

class

“token keyword”

SELECT

span

SoLuongDat

span

class

“token keyword”

FROM

span

inserted

span

class

“token keyword”

WHERE

span

MaHang

span

class

“token operator”

span

tbl_KhoHang

span

class

“token punctuation”

span

MaHang

span

class

“token punctuation”

)

span

class

“token keyword”

FROM

span

tbl_KhoHang

span

class

“token keyword”

JOIN

span

inserted

span

class

“token keyword”

span

tbl_KhoHang

span

class

“token punctuation”

span

MaHang

span

class

“token operator”

span

inserted

span

class

“token punctuation”

span

MaHang

span

class

“token keyword”

END

span

class

“token comment”

/* cập nhật hàng trong kho sau khi cập nhật đặt hàng */

span

class

“token keyword”

CREATE

span

class

“token keyword”

TRIGGER

span

trg_CapNhatDatHang

span

class

“token keyword”

span

tbl_DatHang

span

class

“token keyword”

after

span

class

“token keyword”

update

span

class

“token keyword”

span

class

“token keyword”

BEGIN

span

class

“token keyword”

UPDATE

span

tbl_KhoHang

span

class

“token keyword”

SET

span

SoLuongTon

span

class

“token operator”

span

SoLuongTon

span

class

“token operator”

–

span

class

“token punctuation”

(

span

class

“token keyword”

SELECT

span

SoLuongDat

span

class

“token keyword”

FROM

span

inserted

span

class

“token keyword”

WHERE

span

MaHang

span

class

“token operator”

span

tbl_KhoHang

span

class

“token punctuation”

span

MaHang

span

class

“token punctuation”

)

span

class

“token operator”

span

class

“token punctuation”

(

span

class

“token keyword”

SELECT

span

SoLuongDat

span

class

“token keyword”

FROM

span

deleted

span

class

“token keyword”

WHERE

span

MaHang

span

class

“token operator”

span

tbl_KhoHang

span

class

“token punctuation”

span

MaHang

span

class

“token punctuation”

)

span

class

“token keyword”

FROM

span

tbl_KhoHang

span

class

“token keyword”

JOIN

span

deleted

span

class

“token keyword”

span

tbl_KhoHang

span

class

“token punctuation”

span

MaHang

span

class

“token operator”

span

deleted

span

class

“token punctuation”

span

MaHang

span

class

“token keyword”

end

span

class

“token comment”

/* cập nhật hàng trong kho sau khi hủy đặt hàng */

span

class

“token keyword”

create

span

class

“token keyword”

TRIGGER

span

trg_HuyDatHang

span

class

“token keyword”

span

tbl_DatHang

span

class

“token keyword”

FOR

span

class

“token keyword”

DELETE

span

class

“token keyword”

span

class

“token keyword”

BEGIN

span

class

“token keyword”

UPDATE

span

tbl_KhoHang

span

class

“token keyword”

SET

span

SoLuongTon

span

class

“token operator”

span

SoLuongTon

span

class

“token operator”

span

class

“token punctuation”

(

span

class

“token keyword”

SELECT

span

SoLuongDat

span

class

“token keyword”

FROM

span

deleted

span

class

“token keyword”

WHERE

span

MaHang

span

class

“token operator”

span

tbl_KhoHang

span

class

“token punctuation”

span

MaHang

span

class

“token punctuation”

)

span

class

“token keyword”

FROM

span

tbl_KhoHang

span

class

“token keyword”

JOIN

span

deleted

span

class

“token keyword”

span

tbl_KhoHang

span

class

“token punctuation”

span

MaHang

span

class

“token operator”

span

deleted

span

class

“token punctuation”

span

MaHang

span

class

“token keyword”

END

span

Sử dụng trigger trong SQL qua ví dụ cơ bản – Trang Chủ

mtoplist