Write Database Triggers for SQL server

$30-250 USD

Completed

Posted

almost 2 years ago

$30-250 USD

Paid on delivery

Write Database Triggers for SQL server. Please refer the attached Image for Database Diagram. We will give you database backup before you actually stat working. Database Triggers and work requirements- 1) Each time Formula:CalculationCount is updated (by 1)- a) Update UserInfo:CalculationsCount_List, CalculationsCount_Create, CalculatorCount_Verify, CalculationsCount_Verify b) Update Node:TotalCalculationCount [Iteratively] 2) Each time Formula Inserted/ Deleted a) Update 1) above. b) Node:FormulasUnderCount, TotalFormulasUnderCount [Iteratively] 3) Each time a Node Inserterd / Deleted a) Update Node: NodesUnderCount, TotalNodesUnderCount [Iteratively] 4) Buffer - A couple of more if and as required. 5) Also, Write required SQL insert/update/delete Queries as test cases to demo working of above triggers! Please bid IFF you have experience with writing Database Triggers for MS SQL Server.

Microsoft SQL Server

SQL

Project ID: 33742369

About the project

9 proposals

Remote project

Active 2 yrs ago

Looking to make some money?

Email address

Benefits of bidding on Freelancer

Set your budget and timeframe

Get paid for your work

Outline your proposal

It's free to sign up and bid on jobs

Awarded to:

@Abuzar16nucs

Hi there, Based on your Project Post, I come to know that you need help in database project MySQL triggers for tables. I have gone through the database schema and fully confident doing it. Let's discuss. We Believe in order to achieve your goal or Scope, We have a bunch of skillset in PHP, SQL, C, C++, and Java Programming languages. Data Structures and Database are one of my best subjects. I am doing quizzes, and assignments for CS subjects for 3 years and have proficient skills in it. I hope you at least see the capability in us through this proposal, the rest will be handled by us with committing to provide one world-class output. Thanks Abuzar Ghafari

$30 USD in 2 days

5.0

(1 review)

1.0

9 freelancers are bidding on average $110 USD for this job

@ManzoorH

Hello I am certified SQL Server developer with 8+ years of experience as DBA and .NET developer. I can write any kidn of After INSERT, UPDATE or DELETE triggers for you. I will make sure handle the deadlocks and optimization of the query as it is very important in triggers. I understood the 5 points can you pelase come on chat and show me the SPs and Tables you have, i have no issue to work on your PC via a remote sharing tool. Regards Manzoor

$150 USD in 2 days

4.7

(15 reviews)

4.9

@mirzaahamza

Hey I am expert and I can help you with your project message me to discuss so that we can start working on it

$50 USD in 1 day

5.0

(8 reviews)

3.7

@abatsis

I have an example of a table trigger i can show you: 1) Each time Formula:CalculationCount is updated (by 1)- a) Update UserInfo:CalculationsCount_List, CalculationsCount_Create, CalculatorCount_Verify, CalculationsCount_Verify Contact me to upload image file Hello, I have many years of experience in SQL programming stored procedures and table triggers. I used triggers in an Automatic Robotic Handling system. See my profile for more. Contact me to discuss further. Regards, Alexandros

$150 USD in 7 days

5.0

(1 review)

1.0

@jegaonline

Hello, We are using SQL Server for all the our Client Projects and used to work on Triggers more often. Please give us this Job. We can do this with quality on time. You can refer my profile anytime here https://www.freelancer.com/u/jegaonline I am looking forward to working with you. Thank You

$120 USD in 2 days

0.0

(0 reviews)

0.0

@abhannan930

Hi sir, my name is Abdul Hannan and i am final year computer science student i have good experience of database my sql ms excel , word etc i am assure that you will be satisfy with my work

$30 USD in 2 days