Salvestatud protseduurid = stored procedures = хранимые процедуры.
– See on sama

--Procedure which uses INSERT to add data inside a table brand.
CREATE PROCEDURE LisaBrand
@BrandName varchar(30)
as
BEGIN
INSERT INTO Brands(BrandName) VALUES (@BrandName);
SELECT * FROM Brands;
END;
--Procedure activation
EXEC LisaBrand 'Nintendo';

CREATE PROCEDURE DataDelete
@id int
as
Begin
DELETE FROM Brands WHERE BrandID = @id
End;
--Deletion
EXEC DataDelete 6;

--First letter search
CREATE PROCEDURE FirstLetterSearch
@Taht char(1)
as
BEGIN
SELECT * FROM Brands WHERE BrandName LIKE @Taht+'%';
END

EXEC FirstLetterSearch 'A';