Mega Code Archive
Dynamic Deletes
<![CDATA[
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>
]]>