)
) ProdavciNomer_magazina = @ nom, FIO = @ fio
where Lichniy_nomer = @ lnom
CREATE PROCEDURE procupdate5 (
@ art int,
@ naim varchar (50),
@ kol int,
@ opis varchar (100),
@ nal varchar (10),
@ n int, @ cena int
) Katalog_tovara = @ naim, Kolichestvo_tovara_v_nalichii = @ kol, = @ opis, Nalichie = @ nal, Nomer_postavschika = @ n, cena = @ cena
where Artikul = @ art
CREATE PROCEDURE procupdate7 (
@ lnom int,
@ nompo int,
@ nomm int,
@ data datetime,
@ kol int,
@ art int
GO
create procedure procup8
(
@ art int,
@ 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)
) Komplektuyuschie
set Naimenovanie_tovara = @ naim, Materinskaya_plata = @ mp, Processor = @ proc, Kuler = @ kuler, = @ vid, Operativnaya_pamyat = @ op, Vinchester = @ vin, Klaviatura = @ klav, Monipulyator = @ manip, _CD = @ DC, Korpus = @ Kor, Floopy = @ Floopy
where = @ art
CREATE PROCEDURE procdel221 (
@ N1 varchar (20)) AS
@ err int @ N1 not in (select Nomer_pokupatelya from Pokupateli) 2 (@ N1 in (select Nomer_pokupatelya from Pokupateli)) and
(@ N1 in (select Nomer_pokupatelya from Zakazi)) and
(@ N1 in (select Nomer_pokupatelya from Prodazha)) 1Nomer_pokupatelya = @ N1
return @ err
CREATE PROCEDURE procdel3 (
@ N1 int) AS
@ err int @ N1 not in (select Nomer_postavschika from Postavschiki) 2 (@ N1 in (select Nomer_postavschika from Postavschiki)) (@ N1 in (select Nomer_postavschika from Katalog)) 1Nomer_postavschika = @ N1
return @ err
CREATE PROCEDURE procdel4 (
@ N1 int) AS
@ err int @ N1 not in (select Lichniy_nomer from Prodavci) 2 (@ N1 in (select Lichn...
