Find Jobs
Hire Freelancers

P0713 - create a trigger in an SQL-Server database

€30-250 EUR

Abgeschlossen
Veröffentlicht vor fast 5 Jahren

€30-250 EUR

Bezahlt bei Lieferung
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
Projekt-ID: 20303190

Über das Projekt

18 Vorschläge
Remote Projekt
Aktiv vor 5 Jahren

Möchten Sie etwas Geld verdienen?

Vorteile einer Ausschreibung auf Freelancer

Legen Sie Ihr Budget und Ihren Zeitrahmen fest
Für Ihre Arbeit bezahlt werden
Skizzieren Sie Ihren Vorschlag
Sie können sich kostenlos anmelden und auf Aufträge bieten
Vergeben an:
Avatar des Nutzers
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 in 3 Tagen
5,0 (3 Bewertungen)
2,3
2,3
18 Freelancer bieten im Durchschnitt €129 EUR für diesen Auftrag
Avatar des Nutzers
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 in 3 Tagen
5,0 (278 Bewertungen)
7,8
7,8
Avatar des Nutzers
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 in 4 Tagen
5,0 (77 Bewertungen)
6,4
6,4
Avatar des Nutzers
Hello, I have understood the project requirements and we can discuss further in more details. Thanks.
€135 EUR in 7 Tagen
4,3 (21 Bewertungen)
5,5
5,5
Avatar des Nutzers
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 in 7 Tagen
4,9 (18 Bewertungen)
4,4
4,4
Avatar des Nutzers
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 in 5 Tagen
4,9 (8 Bewertungen)
3,7
3,7
Avatar des Nutzers
Hi contact me ASAP
€30 EUR in 2 Tagen
5,0 (2 Bewertungen)
3,4
3,4
Avatar des Nutzers
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 in 5 Tagen
5,0 (6 Bewertungen)
3,3
3,3
Avatar des Nutzers
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 in 1 Tag
5,0 (5 Bewertungen)
3,3
3,3
Avatar des Nutzers
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 in 5 Tagen
5,0 (5 Bewertungen)
3,1
3,1
Avatar des Nutzers
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 in 2 Tagen
5,0 (5 Bewertungen)
2,9
2,9
Avatar des Nutzers
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 in 1 Tag
5,0 (1 Bewertung)
1,4
1,4
Avatar des Nutzers
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 in 4 Tagen
5,0 (1 Bewertung)
1,1
1,1
Avatar des Nutzers
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 in 3 Tagen
0,0 (0 Bewertungen)
0,0
0,0
Avatar des Nutzers
I am a sql developer with almost 9 years of experience in SQL objects. Triggers, Procedures, functions, etc.
€111 EUR in 3 Tagen
0,0 (0 Bewertungen)
0,0
0,0
Avatar des Nutzers
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 in 2 Tagen
0,0 (0 Bewertungen)
0,0
0,0

Über den Kunden

Flagge von GERMANY
Filderstadt, Germany
5,0
13
Zahlungsmethode verifiziert
Mitglied seit Jan. 8, 2016

Kundenüberprüfung

Danke! Wir haben Ihnen per E-Mail einen Link geschickt, über den Sie Ihr kostenloses Guthaben anfordern können.
Beim Senden Ihrer E-Mail ist ein Fehler aufgetreten. Bitte versuchen Sie es erneut.
Registrierte Benutzer Veröffentlichte Jobs
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Vorschau wird geladen
Erlaubnis zur Geolokalisierung erteilt.
Ihre Anmeldesitzung ist abgelaufen und Sie wurden abgemeldet. Bitte melden Sie sich erneut an.