Dynamic Deletes : Delete Statement « Transact SQL « SQL Server / T-SQL Tutorial

1. SQL Server / T-SQL Tutorial
2. Transact SQL
3. Delete Statement

4>
5>
6>
7>
8>     CREATE PROCEDURE prDeleteData
9>         @chvTable VARCHAR(30)
10>     AS
11>     DECLARE @chvSQL VARCHAR(255)
12>     SELECT @chvSQL = 'DELETE ' + @chvTable
13>     EXEC (@chvSQL)
14>     GO
1>
2>     drop PROCEDURE prDeleteData;
3>     GO
1>