I am kind of new to SPROCs, can anyone see why won't this work?
Code:
CREATE PROCEDURE sp_emptytable
	@MyTable varchar(50)
AS
DELETE FROM @MyTable WHERE id > 0
I am entering the SPROC using SQL Server Enterprise Manager.