Find Jobs
Hire Freelancers

P0713 - create a trigger in an SQL-Server database

€30-250 EUR

Ολοκληρώθηκε
Αναρτήθηκε περίπου 5 χρόνια πριν

€30-250 EUR

Πληρωμή κατά την παράδοση
The target of this job is to create a trigger in the an SQl-Server database. The trigger should log changes in the database The final result has these features 1 Once per week: Kill all Log data older than 2 Years 2 Log "NEW" record 3 Log "CHANGED" records 4 Log "DELETED" records See attached PDF. Greetings Rainer
Ταυτότητα εργασίας: 20303190

Σχετικά με την εργασία

18 προτάσεις
Απομακρυσμένη Εργασία
Ενεργός/ή 5 χρόνια πριν

Ψάχνεις τρόπο για να κερδίσεις μερικά χρήματα;

Πλεονεκτήματα πλειοδοσίας στο Freelancer

Καθόρισε τον προϋπολογισμό σου και το χρονοδιάγραμμα
Πληρώσου για τη δουλειά σου
Περίγραψε την πρόταση σου
Η εγγραφή και η πλειοδοσία σε εργασίες είναι δωρεάν
Βραβεύτηκε στον/στην:
Avatar Χρήστη
Hello, I read your project description and understand all(about create Trigger). I have rich experience in Ms. Sqlserver Developing and Administration I will make the perfect product what you want. I promise to complete your project within your time and budget beyond your expectation. I am willing to work at lower pay. Let me know when we can discuss and share all.
€75 EUR σε 3 ημέρες
5,0 (3 αξιολογήσεις)
2,3
2,3
18 freelancers δίνουν μια μέση προσφορά €129 EUR για αυτή τη δουλειά
Avatar Χρήστη
Hello, As an expert in ms sql server, i am very much interested to do create the required trigger. I checked the attached document and i understand the requirements. Looking forward to have a positive response. Thanks
€150 EUR σε 3 ημέρες
5,0 (278 αξιολογήσεις)
7,8
7,8
Avatar Χρήστη
Hi I am a database expert with 12 years experience in handling MS SQL and MySQL databases. I have worked as DBA for large ERP databases and use to write and do performance tuning for SQL queries, procedures and triggers. I have gone through the document but not understood the below line. "I have more than 100 columns. Consider this in the trigger. Use a global function to store the fieldname" Did you meant the field names will be dynamic? Is both the tables not defined initially with correct number of columns? Using dynamic field names with in the trigger can be a bit complex. Or did you meant the column names will be fixed like PropertyString01, PropertyString02,...PropertyString100? We might need three tirggers - one Insert trigge, one update trigger (both Before and Update evens can be coded in a single after update trigger) and a delete trigger. Look forward to hear from you. Thanks Roni
€120 EUR σε 4 ημέρες
5,0 (77 αξιολογήσεις)
6,4
6,4
Avatar Χρήστη
Hello, I have understood the project requirements and we can discuss further in more details. Thanks.
€135 EUR σε 7 ημέρες
4,3 (21 αξιολογήσεις)
5,5
5,5
Avatar Χρήστη
hi I am expertise in sql server and writing queries triggers and procs . please let me know few more details to continue . ping me if you are interested
€140 EUR σε 7 ημέρες
4,9 (18 αξιολογήσεις)
4,4
4,4
Avatar Χρήστη
hi, i am c# & database developer with 5 years of experience. have developed many application. have knowledge in database like mssql, oracle, postgrey., (store procedure, triggers, sql job scheduler, oracle/ postgrey packages etc.)etc. have maintain multiple large size databases.
€111 EUR σε 5 ημέρες
4,9 (8 αξιολογήσεις)
3,7
3,7
Avatar Χρήστη
Hi contact me ASAP
€30 EUR σε 2 ημέρες
5,0 (2 αξιολογήσεις)
3,4
3,4
Avatar Χρήστη
Dear Sir/Madam, I have relational database design and development experience of 10 years. Recently I completed 5 Database Systems Course projects which cover: - Conceptual design (ER Diagram) - Creation of database schema (creating tables, constraints, triggers) - Writing simple and complex SQL queries including subqueries. - Writing stored functions/procedures I have the following experience: I developed reports or enhanced performance of queries in the reports using Oracle Reports, Oracle BI reports, SQL, stored procedures for the following projects: -Oracle Financials (Oracle EBS) Project -Oracle Transportation Management (OTM) Project -Siber Logistics Software Project(MSSQL) -Cognos BI Project(MSSQL) -I wrote Oracle stored procedures to send automatic invoices, arrival notices, cargo specs and reconciliation letters to customers. I am sure that I am a good fit for your project. Hope to hear from you soon. Best Regards Huseyin Aygun
€200 EUR σε 5 ημέρες
5,0 (6 αξιολογήσεις)
3,3
3,3
Avatar Χρήστη
Myself Anil have more then 10 years of experience in SQL Server databse development and Administration. I have worked with big Databases for clients like match. Com, nationstar mortgage and with TCS. I am also good for BI part like SSIS, SSRS and SSAS. I am looking for full time /part time or hourly remote job. I am immediate available. 
€111 EUR σε 1 ημέρα
5,0 (5 αξιολογήσεις)
3,3
3,3
Avatar Χρήστη
Hi, I have 7+ years of experience working in Top IT companies as a Database Developer. I have read the PDF that you have attached with the requirement. I believe I would be able to create the trigger as required in the given time frame.
€111 EUR σε 5 ημέρες
5,0 (5 αξιολογήσεις)
3,1
3,1
Avatar Χρήστη
Hi,I've read your document . your need 2 table : - first table is standard table - second table for trigger from first table, copy all data from first table with process action (NEW, Change Before, Change After, DELETED). delete log process, your need to add field "action timestamp" in tabContractLOG for filter your log time. Please send me message so that we could discuss it further. To make sure that employment will truly serve your requirement, you can evaluate my skill by giving part of your coding for skill testing before hiring. see more about me: I am keen to work for those who need an expert in SQL Language and Database System. More than 7 years experience in many project on SQL, non-SQL, and Database Management such as MS SQL, Oracle, mySQL, Postgresql, MS Access, MongoDB, Firebase and so on. I developed many web applications using Angular, Bootstrap, Angular Material, Prime NG, Ant Design, and Express NodeJS. 3 years experience Data science , Data mining project using Python, Pandas, Numpy, R, Scikit learn, XGboost and Lightgbm. I have top 11% on Kaggle competitions See my Kaggle profile : @l0ginx or "Pratya Thanwatthanakit" I like to face technical challenges and feel pleasure to resolve.
€100 EUR σε 2 ημέρες
5,0 (5 αξιολογήσεις)
2,9
2,9
Avatar Χρήστη
Hi there - This is Abdul Mannan and i can create trigger queries as described in the attached file as per your requirements, I am an expert in writing My-SQL Queries, no matter how much it is complex.
€200 EUR σε 1 ημέρα
5,0 (1 αξιολόγηση)
1,4
1,4
Avatar Χρήστη
Hello sir, I read your document and I can provide you your Microsoft SQL Server triggers to log manipulation of your data. Just send me a message and we can start immediately! Have a nice day.
€100 EUR σε 4 ημέρες
5,0 (1 αξιολόγηση)
1,1
1,1
Avatar Χρήστη
A new freelancer with a good experience in sql and sql server(1 year) and i really like using triggers because of the huge time/effort they save me , i have no problem with working with a low price . Relevant Skills and Experience Im specialized in desktop applications and i have been using sql and aql server in like every project i have created , and i know the important of using triggers
€155 EUR σε 3 ημέρες
0,0 (0 αξιολογήσεις)
0,0
0,0
Avatar Χρήστη
I am a sql developer with almost 9 years of experience in SQL objects. Triggers, Procedures, functions, etc.
€111 EUR σε 3 ημέρες
0,0 (0 αξιολογήσεις)
0,0
0,0
Avatar Χρήστη
I have 1+ year of experience for creating Optimized stored Procedures,function,triggers,views. Looking forward to discuss with you in greater detail.
€111 EUR σε 2 ημέρες
0,0 (0 αξιολογήσεις)
0,0
0,0

Σχετικά με τον πελάτη

Σημαία της GERMANY
Filderstadt, Germany
5,0
13
Επαληθευμένη μέθοδος πληρωμής
Μέλος από Ιαν 8, 2016

Επαλήθευση Πελάτη

Ευχαριστούμε! Σου έχουμε στείλει ένα email με ένα σύνδεσμο για να διεκδικήσεις τη δωρεάν πίστωση σου.
Κάτι πήγε στραβά κατά την προσπάθεια αποστολής του email σου. Παρακαλούμε δοκίμασε ξανά.
Εγγεγραμμένοι Χρήστες Συνολικές Αναρτημένες Δουλειές
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Φόρτωση προεπισκόπησης
Δόθηκε πρόσβαση για Geolocation.
Η σύνδεση σου έχει λήξει και τώρα έχεις αποσυνδεθεί. Παρακαλούμε συνδέσου ξανά.