Advertisement
avaqe

Untitled

Nov 4th, 2015
98
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.45 KB | None | 0 0
  1. CREATE TRIGGER [Dictionaries].[tr_aInsert_Dictionaries_Languages_InsertEshopLanguages]
  2. ON [Dictionaries].[Languages]
  3. AFTER INSERT
  4. AS
  5. BEGIN
  6. INSERT INTO [EShop].[Languages]
  7. (
  8. [AltumLangId],
  9. [EShopLangId]
  10. )
  11. SELECT
  12. I.LanguageID,
  13. [Dictionaries].[GetEShopLangID](I.InternalName)
  14. FROM INSERTED I
  15. WHERE [Dictionaries].[GetEShopLangID](I.InternalName)
  16. NOT IN (SELECT EShopLangID FROM [EShop].[Languages])
  17. END
  18. GO
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement