Data Triggerung in MS SQL Server
We are using an order management tool for ebay, which is based on a MS SQL database.
We have special requirements and need adjust the database.
As first part we have a data triggering project, but more project can follow later
The main table of the database is the “transactions” table.
We extended this table with several fields.
Some of these fields (marked Green) need to be triggered by the other fields.
Which fields need to be triggered and how the attached documents are describing.
Pls note that also Chinese characters need to be insert, so we also need know how to support this character set in the database.
1. Some screenshots from the database and the important “transactions” table viewed by EMS SQL Manager Studio
2. Export file of that table with some data – yellow fields are our input fields - red fields need to be triggered
3. Triggering table - The trigger table is not complete (some fields show “data will be delivered later”). We deliver quickly after provider is choosen.
Timeline is as important as price. So please tell us both.
Timeline must be reliable !!!
Please give us the following information:
3. How you will make the project. As trigger SQL syntax hardcode, or which kind of solution
Money will be escrowed and released when project is done or on proof that project is completed.
If any questions pls contact us.
22 freelancers are bidding on average $332 for this job
Hi, We are quite comfortable to work on your Project with our excellent team of Programmers & Designers. Please see PMB for our company Profile & Experience & Questions. Thanks
For this trigger will be created on database events like while inserting or while updating or inserting a value in particular table trigger will implicitely updates the corrosponding fields of the table.