Tamamlanmış

write program (one trigger and two procedures) in database SQL

write program (one trigger and two procedures) in database SQL

/********* Trigger TR_OVERDUE ************/

delimiter //

drop trigger if exists tr_overdue

//

create trigger tr_overdue

-- type of trigger, etc

-- implementation goes here

end

//

---------------------

drop procedure if exists sp_finish_campaign //

create procedure sp_finish_campaign (in c_title varchar(30))

begin

-- code

-- do the error handling

-- employ helper functions and procedures if necessary (advisable to make the code modular and understandable

-- For instance, somewhere in the code ...

--

-- set

-- t_cost = cost_of_campaign(camp_id);

--

--

end//

/************ Procedure SYNC_INVOICE******************/

drop procedure if exists sync_invoice;

//

CREATE procedure sync_invoice()

begin

-- code

end

//

delimiter ;

Beceriler: SQL, MySQL, Veritabanı Programlama

Daha fazlasını gör: use of triggers in sql, triggers in pl sql, types of triggers in sql, simple trigger example in sql, trigger in sql server w3schools, triggers in mysql, procedure in sql, triggers in sql w3schools, store image database sql fileupload, asterisk call forward database sql query, add database sql, Soccer football database sql , password database sql anywhere, changes database sql, deploy sql database sql express, converting access database sql server 2008, executable program uses access database, converting sql 2000 database sql server 2005 express, lunches database sql, spyware database sql

İşveren Hakkında:
( 2 değerlendirme ) Madinah, Saudi Arabia

Proje NO: #21895599

Seçilen:

truongnguyen86

Hello there, i'm expert on SQL, let me help you with this job: 2 procedures and 1 trigger i think i can finish it in a couple of hours. Waiting for your response if interested. Thank you!!!

1 gün içinde %selectedBids___i_sum_sub_4%%project_currencyDetails_sign_sub_5% AUD
(170 Değerlendirme)
6.8

Bu iş için 11 freelancer ortalamada $27 teklif veriyor

bdmpankaj

Hi, We are Codegente. We have gone through your requirements and we can do this task. We can assure you for a complete professional work in a given timeline. Please share the complete detail of your requirement. We Daha Fazla

$20 AUD in 7 gün içinde
(8 Değerlendirme)
3.5
TEKSCENT

hi, i have around 10 years of experience in SQL development in MNC as team lead.i would like to work with you for this [login to view URL] can pay later once satisfied

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% AUD
(2 Değerlendirme)
3.2
adricabrelles

Hi I am Senior Dba with more than 15 years experience in sql. I can help you. Regards

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% AUD
(6 Değerlendirme)
2.6
infodart

_Greetings e-meeting you_ Hi, Sudesh here. Over 10+ years of IT Experience in Database with expertise in SQL Server Development and Reporting using SQL Server 2008/2005, SSRS, SSIS and Micro-strategy. Pragmatic, high Daha Fazla

$20 AUD in 7 gün içinde
(4 Değerlendirme)
3.4
Saimi786

Hello Thanks for your posting. I am a senior developer so i can do it very easily if you want.I’ve read your job description carefully and I am very interested in your project. I am sure that I can finish this project Daha Fazla

$29 AUD in 7 gün içinde
(1 Yorum)
1.6
ITtechsol

Hello! I am very interested in your post project. While I read your description carefully, I was excited with feeling that I would be able to satisfy for your requirements in this job. We can negotiate on price/Budget Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% AUD
(0 Değerlendirme)
0.0
contactmejayw30

I'm an oT graduation ceremony

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% AUD
(0 Değerlendirme)
0.0
som4p

I am working as a DBA for past 5 yrs and i can make the triggers as per you attached requirement ASAP

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% AUD
(0 Değerlendirme)
0.0
DataSME

I am an Australian PR holder, living in the UK. I have over 15 years of DWH (Databases/SQL) experience and looking to build my profile in Freelancer. I can surely do this work. I have written many Triggers and Sprocs Daha Fazla

$30 AUD in 5 gün içinde
(0 Değerlendirme)
0.0
munna1001

I am expert in writing trigger and function in different types of database like SQL,postgresql and mysql.

$25 AUD in 3 gün içinde
(0 Değerlendirme)
0.0