SQL Server/T-SQL Tutorial/Procedure Function/Drop procedure — различия между версиями
Admin (обсуждение | вклад) м (1 версия) |
(нет различий)
|
Текущая версия на 13:25, 26 мая 2010
DROP PROC|PROCEDURE <sproc name>
<source lang="sql">
8> CREATE TABLE Shippers ( 9> ShipperID int NOT NULL , 10> CompanyName nvarchar (40) NOT NULL , 11> Phone nvarchar (24) NULL 12> ) 13> GO 1> 2> 3> INSERT Shippers VALUES(1,"Express","(503) 555-9831") 4> INSERT Shippers VALUES(2,"Package","(503) 555-3199") 5> INSERT Shippers VALUES(3,"Shipping","(503) 555-9931") 6> go (1 rows affected) (1 rows affected) (1 rows affected) 1> CREATE PROC spShippers 2> AS 3> SELECT * FROM Shippers 4> GO 1> EXEC spShippers 2> GO ShipperID CompanyName Phone
---------------------------------------- ------------------------
1 Express (503) 555-9831 2 Package (503) 555-3199 3 Shipping (503) 555-9931
(3 rows affected) 1> drop PROC spShippers; 2> GO 1> 2> drop table Shippers; 3> GO</source>
How to delete or change a stored procedure
<source lang="sql">
5> -- 6> --The syntax of the DROP PROC statement 7> -- 8> --DROP {PROC|PROCEDURE} procedure_name [, ...]</source>