{"version":"1.0","image_url":null,"author_url":"https://blog.hatena.ne.jp/iad_otomamay/","blog_url":"https://daiyamamoto.hatenablog.com/","published":"2008-04-30 00:00:00","provider_url":"https://hatena.blog","categories":["SQLServer2005"],"title":"\u30c8\u30ea\u30ac\u306e\u30c6\u30f3\u30d7\u30ec\u30fc\u30c8","author_name":"iad_otomamay","provider_name":"Hatena Blog","height":"190","width":"100%","html":"<iframe src=\"https://hatenablog-parts.com/embed?url=https%3A%2F%2Fdaiyamamoto.hatenablog.com%2Fentry%2F20080430%2Fp1\" title=\"\u30c8\u30ea\u30ac\u306e\u30c6\u30f3\u30d7\u30ec\u30fc\u30c8 - \u30ec\u30d9\u30eb\u30a8\u30f3\u30bf\u30fc\u5c71\u672c\u5927\u306e\u30d6\u30ed\u30b0\" class=\"embed-card embed-blogcard\" scrolling=\"no\" frameborder=\"0\" style=\"display: block; width: 100%; height: 190px; max-width: 500px; margin: 10px 0px;\"></iframe>","description":"SQLServer\u306e\u30c8\u30ea\u30ac\u30fc\u3092\u4f5c\u3063\u305f\u306e\u3067\u3001\u30c6\u30f3\u30d7\u30ec\u30fc\u30c8\u3068\u3057\u3066\u3042\u3052\u3068\u304d\u307e\u3059\u3002target_table \uff08\u30c8\u30ea\u30ac\u8a2d\u5b9a\u30c6\u30fc\u30d6\u30eb\uff09 \u30ab\u30e9\u30e0 \u578b col_1 int identity col_2 nvarchar(50) trgger_ins_data\uff08\u30c8\u30ea\u30ac\u5b9f\u884c\u7d50\u679c\u767b\u9332\u30c6\u30fc\u30d6\u30eb\uff09 \u30ab\u30e9\u30e0 \u578b ID int identity Msg nvarchar(50) \u30c8\u30ea\u30ac\u306e\u30c6\u30f3\u30d7\u30ec\u30fc\u30c8\u30af\u30a8\u30ea CREATE TRIGGER [my_trigger] ON [target_table] AFTER INSERT,DELETE,UPDATE AS BEGIN --\u30c8\u30ea\u30ac\u5185\u3067\u51e6\u7406\u3055\u308c\u305f\u884c\u6570\u3092\u793a\u3059\u30e1\u30c3\u30bb\u30fc\u30b8\u304c\u7d50\u679c\u30bb\u30c3\u30c8\u2026","type":"rich","url":"https://daiyamamoto.hatenablog.com/entry/20080430/p1","blog_title":"\u30ec\u30d9\u30eb\u30a8\u30f3\u30bf\u30fc\u5c71\u672c\u5927\u306e\u30d6\u30ed\u30b0"}