jeudi 9 janvier 2020

Unit Test to verify if Trigger in Sql Server [closed]

I have created a Trigger which Insert data into PorductHistory Table on Inserting/Modifying Product Table. Here is what I did.

CREATE TRIGGER update_log ON dbo.Product AFTER UPDATE,INSERT AS BEGIN INSERT INTO dbo.ProductHistory( ProductId, ProductName, ProductPrice ) SELECT i.ProductId, i.ProductName, i.ProductPrice FROM inserted i LEFT JOIN deleted d ON i.ProductId = d.ProductId END;

Now I want to write Unit Test for it to verify If It is Inserting data into ProductHistory Table. Please help me in writing Unit Test for it.

I tried tSQLt, but it didnt helped me. Can you please provide me some code snippet example

Aucun commentaire:

Enregistrer un commentaire