Find Jobs
Hire Freelancers

P0713 - create a trigger in an SQL-Server database

€30-250 EUR

Ukończony
Opublikowano prawie 5 lat temu

€30-250 EUR

Płatne przy odbiorze
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
Identyfikator projektu: 20303190

Informację o projekcie

18 ofert
Zdalny projekt
Aktywny 5 lat temu

Szukasz sposobu na zarobienie pieniędzy?

Korzyści ze składania ofert na Freelancer.com

Ustal budżet i ramy czasowe
Otrzymuj wynagrodzenie za swoją pracę
Przedstaw swoją propozycję
Rejestracja i składanie ofert jest bezpłatne
Przyznano:
Awatar Użytkownika
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 w 3 dni
5,0 (3 opinii)
2,3
2,3
18 freelancerzy składają oferty o średniej wysokości €129 EUR dla tej pracy
Awatar Użytkownika
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 w 3 dni
5,0 (278 opinii)
7,8
7,8
Awatar Użytkownika
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 w 4 dni
5,0 (77 opinii)
6,4
6,4
Awatar Użytkownika
Hello, I have understood the project requirements and we can discuss further in more details. Thanks.
€135 EUR w 7 dni
4,3 (21 opinii)
5,5
5,5
Awatar Użytkownika
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 w 7 dni
4,9 (18 opinii)
4,4
4,4
Awatar Użytkownika
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 w 5 dni
4,9 (8 opinii)
3,7
3,7
Awatar Użytkownika
Hi contact me ASAP
€30 EUR w 2 dni
5,0 (2 opinii)
3,4
3,4
Awatar Użytkownika
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 w 5 dni
5,0 (6 opinii)
3,3
3,3
Awatar Użytkownika
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 w 1 dzień
5,0 (5 opinii)
3,3
3,3
Awatar Użytkownika
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 w 5 dni
5,0 (5 opinii)
3,1
3,1
Awatar Użytkownika
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 w 2 dni
5,0 (5 opinii)
2,9
2,9
Awatar Użytkownika
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 w 1 dzień
5,0 (1 opinia)
1,4
1,4
Awatar Użytkownika
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 w 4 dni
5,0 (1 opinia)
1,1
1,1
Awatar Użytkownika
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 w 3 dni
0,0 (0 opinii)
0,0
0,0
Awatar Użytkownika
I am a sql developer with almost 9 years of experience in SQL objects. Triggers, Procedures, functions, etc.
€111 EUR w 3 dni
0,0 (0 opinii)
0,0
0,0
Awatar Użytkownika
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 w 2 dni
0,0 (0 opinii)
0,0
0,0

O kliencie

Flaga GERMANY
Filderstadt, Germany
5,0
13
Zweryfikowana metoda płatności
Członek od sty 8, 2016

Weryfikacja Klienta

Dziękujemy! Przesłaliśmy Ci e-mailem link do odebrania darmowego bonusu.
Coś poszło nie tak podczas wysyłania wiadomości e-mail. Proszę spróbować ponownie.
Zarejestrowani Użytkownicy Całkowita Liczba Opublikowanych Projektów
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Wczytywanie podglądu
Udzielono pozwolenia na Geolokalizację.
Twoja sesja logowania wygasła i zostałeś wylogowany. Proszę, zalogować się ponownie.