Hello, 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 Product table ID...
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?
hello, Thx for the replies; What is the reason : a process which I don't control (remote process) adds records to a certain table fe...
Hello, 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.
