The tables are linked by the ArtID from all the tables to the ID of the articles
There always the possibility that there are no records in the...
Hello, I want to write a select query to get the info to build a purchase & sales report.
The next structure table exists
Can anyone explain what is wrong with that piece of code?
CREATE TRIGGER trg_Insert ON [dbo].[tblproduct_stock_history] <br />FOR INSERT<br />AS<br />declare @TypeTrans varchar(9) ,<br />@SPID numeric ,<br...
Can you give me an example for multiple fields?
Thx for the replies;
What is the reason : a process which I don't control (remote process) adds records to a certain table fe...
I want to write a trigger which does the following
When a record is inserted in a table,
I want to check a field from the new record on a...
Separate names with a comma.