SQL 101

[digitalsuperman]

---

^yep, absolutely..use DTS..

[sthung_kling]

Good Adlaw!!!
Kung naa mangutana about PHP, Apache WebServer, Linux and PostgreSQL, Im here... Hope I can HelP.....

[Orgasms]

question lang po...

unsaon man pag delete sa entry sa ako sql database inig ka abot sa given nga oras

pananglitan...
gusto ko mo delete ug isa ka line sa usa ka table inig abot ug 3 hours...

unsaon man?

help

[simoncpu]

It depends on your system. If your using Unix or other Unix-like system, then you can use the cron utility. If your using Windows, I think you can use Task Scheduler. =)

[ simon.cpu ]

question lang po...

unsaon man pag delete sa entry sa ako sql database inig ka abot sa given nga oras

pananglitan...
gusto ko mo delete ug isa ka line sa usa ka table inig abot ug 3 hours...

unsaon man?

help

[bisdakgyud]

Why not create a program that just check the time elapsed and loops back/or sleeps if the time elapsed is not yet reached.

[RyoZen]

question lang po...

unsaon man pag delete sa entry sa ako sql database inig ka abot sa given nga oras

pananglitan...
gusto ko mo delete ug isa ka line sa usa ka table inig abot ug 3 hours...

unsaon man?

help

you can follow their suggestions above kung naa sa application-side na siya nga feature. otherwise, pwede ka magbuhat ug job/SQL job nga ang task kay magdelete ug one record sa table sa particular nga database. sa MS SQL sure ko naa na.. don't know with other RDBMS lang hinuon...

[BadDudes]

in Oracle you can create a procedure or function to delete a certain record ... and submit it in the built in job ... dbms_jobs which is configurable by time and interval in seconds!

[dlanyer77]

BadDudes, i agree with you bro Oracle can do the job to do it. And also i agree with bisdakgyud and RyoZen just incase your back-end is not Oracle you better make an agent that carry the task you want.

[miss tapya]

magbuhat ka og procedure nga mag set xa sa time nga i delete ang entry...
set the limits diay tood..make sure nga wala xa gigamit as foreign key to other tables....

[shootme]

Using SQL query string in sybase.. sample code:

if @sItem_codeFrom <> '' then
set @sqlItems=string('select x.item, x.company_code, x.SOQty, d.Cwarehouse_code, d.Fwarehouse_code, c.qtyUnit, c.FWstockQty, c.CWstockQty, c.flag into #xItems2 from ((select a.company_code,b.item, sum(b.qty) as SOQty into #xItems from salescontract a left join sc_detail b on a.sc_no=b.sc_no ',@sqlDate,' and b.item between ''',@sItem_codeFrom,''' and ''',@sItem_codeTo,''' group by a.company_code, b.item order by b.item) as x left outer join customer d on x.company_code = d.company_code), stock as c where x.item = c.item and c.flag = ''f'' order by x.item')
else
set @sqlItems=string('select x.item, x.company_code, x.SOQty, d.Cwarehouse_code, d.Fwarehouse_code, c.qtyUnit, c.FWstockQty, c.CWstockQty, c.flag into #xItems2 from ((select a.company_code,b.item, sum(b.qty) as SOQty into #xItems from salescontract a left join sc_detail b on a.sc_no=b.sc_no ',@sqlDate,' group by a.company_code, b.item order by b.item) as x left outer join customer d on d.company_code = x.company_code ), stock as c where x.item = c.item and c.flag = ''f'' order by x.item')
end if;
// end of sqlItem
execute immediate @sqlItems;