I want to create a Trigger for inserting a record for ordering a product in the purchase table automatically when Reorder level quantity is going to its minimum level in the stock table.
Loading
I want to create a Trigger for inserting a record for ordering a product in the purchase table automatically when Reorder level quantity is going to its minimum level in the stock table.
Know the answer? Post it — somebody with the same question will find it here.
Sign in to answer this question
It is the same account you read, post and publish with — and you will come straight back to this page.
Jignesh KumarPosted Nov 23, 2022, 4:17 AM
Hello Sagar,
Please refer this thread which will help you out,
https://www.c-sharpcorner.com/article/trigger-in-sql-server2/
https://social.msdn.microsoft.com/Forums/sqlserver/en-US/29e4272c-5542-4489-b956-b74168e2b548/how-to-add-order-item-into-a-purchase-order-using-a-stored-proceduretrigger?forum=transactsql
https://www.red-gate.com/simple-talk/databases/sql-server/database-administration-sql-server/sql-server-triggers-good-scary/