Abonamenty
use ct_klienci;
select * from abonament where id_klient=239215
update abonament
set data_do='2011-07-16 00:00:00.000', data_od='2011-06-17 00:00:00.000'
where id_klient=239215
select * from dbo.ABONAMENT_OKRESY where id_abonament=335
update ABONAMENT_OKRESY
set data_do='2011-07-16 00:00:00.000', data_od='2011-06-17 00:00:00.000'
where id_abonament=335
Klienci_DaneWww
use ct_klienci;
select * from klienci where id=239215
select * from klienci_danewww where id_klienta=239215
update klienci_danewww
set
ogl_nazwa='Elro Trucks NV',
ogl_miejsc='Bree',
ogl_kier1='0032',
ogl_tel1='89 777 460',
ogl_kier2='0032',
ogl_tel2='89 775 923',
ogl_t_dod2='Fax',
ogl_email='timo@elro-trucks.be',
ogl_http='www.elro-trucks.be',
email_www='info@elro-trucks.be'
where id_klienta=239215
use internet_ogloszenia;
select * from webklienci where id=239215
update webklienci
set nazwa='Elro Trucks NV',miasto='Bree', kraj='be'
where id=239215
