Реферат Мережа комп'ютерних магазинів "21 століття"

Тема: Курсовые обзорные

atetime,

@ kol int,

@ l int) @ f int @ f = Kolichestvo_tovara_v_nalichiikatalogArtikul = @ art @ f> = @ kolINTO Prodazha (Artikul, Nomer_pokupatelya, Nomer_magazina, Data, Kolichestvo, Lichniy_nomer) (@ art, @ nomp, @ nomm, @ data, @ kol, @ l) katalogKolichestvo_tovara_v_nalichii = Kolichestvo_tovara_v_nalichii-@ kolArtikul = @ artreturn 1

CREATE PROCEDURE proc7 (

@ lnom int,

@ nompo int,

@ nomm int,

@ data datetime,

@ kol int,

@ art int

) INTO Zakazi (Lichniy_nomer, Nomer_pokupatelya, Nomer_magazina, Data, Kolichestvo, Artikul) (@ lnom, @ nompo, @ nomm, @ data, @ kol, @ art)

CREATE PROCEDURE proc81 (

@ naim varchar (150),

@ mp varchar (150),

@ proc varchar (150),

@ kuler varchar (150),

@ vid varchar (150),

@ op varchar (150),

@ vin varchar (150),

@ klav varchar (150),

@ manip varchar (150),

@ DC varchar (150),

@ Kor varchar (150),

@ Floopy varchar (150),

@ arti int

) INTO Komplektuyuschie (Naimenovanie_tovara, Materinskaya_plata, Processor, Kuler, Videokarta, Operativnaya_pamyat, Vinchester, Klaviatura, Monipulyator, DVD_CD, Korpus, Floopy, Artikul) (@ naim, @ mp, @ proc, @ kuler , @ vid, @ op, @ vin, @ klav, @ manip, @ DC, @ Kor, @ Floopy, @ arti)

CREATE PROCEDURE procupdate1 (

@ nom int,

@ nazv varchar (50),

@ fio varchar (50),

@ adr varchar (70)) magazin = @ nazv, _directora = @ fio, = @ adrNomer_magazina = @ nom

CREATE PROCEDURE procupdate2 (

@ nom int,

@ nazv varchar (50),

@ fio varchar (70),

@ adr varchar (70),

@ tel int

) PokupateliNazvanie_firmi = @ nazv, = @ fio, = @ adr, = @ telNomer_pokupatelya = @ nom