Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CREATE TRIGGER [Dictionaries].[tr_aInsert_Dictionaries_Languages_InsertEshopLanguages]
- ON [Dictionaries].[Languages]
- AFTER INSERT
- AS
- BEGIN
- INSERT INTO [EShop].[Languages]
- (
- [AltumLangId],
- [EShopLangId]
- )
- SELECT
- I.LanguageID,
- [Dictionaries].[GetEShopLangID](I.InternalName)
- FROM INSERTED I
- WHERE [Dictionaries].[GetEShopLangID](I.InternalName)
- NOT IN (SELECT EShopLangID FROM [EShop].[Languages])
- END
- GO
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement