DELETE FROM MyOilsWHERE (OilName = 'Basil')

Данный сценарий выполняет действия:

DELETE FROM MyOilsWHERE (OilName = 'Basil')

DELETE FROM MyOilsWHERE (OilName = 'Basil')

CREATE PROCEDURE InputSP@OilName char(50)ASSELECT OilName, LatinName FROM OilsWHERE OilName = @OilName

CREATE PROCEDURE InputSP@OilName char(50)ASSELECT OilName, LatinName FROM OilsWHERE OilName = @OilName

CREATE PROCEDURE InputSP@OilName char(50)ASSELECT OilName, LatinName FROM OilsWHERE OilName = @OilName

CREATE PROCEDURE DefaultSP@OilName char(50) = 'Fennel'ASSELECT OilName, LatinName FROM OilsWHERE OilName = @OilName

CREATE PROCEDURE DefaultSP@OilName char(50) = 'Fennel'ASSELECT OilName, LatinName FROM OilsWHERE OilName = @OilName

CREATE PROCEDURE DefaultSP@OilName char(50) = 'Fennel'ASSELECT OilName, LatinName FROM OilsWHERE OilName = @OilName

SELECT OilName, LatinNameINTO #TempTableFROM Oils

SELECT OilName, LatinNameINTO ##TempTableFROM Oils