Truncate multiple tables in SQL Server using stored procedure
<p>I'm using SQL Server. I want to create a stored procedure that truncates 3 of my tables (<code>dbo.table1</code>, <code>dbo.table2</code>, <code>dbo.table3</code>). </p>

<p>I want to clear out all of my tables this way. What am I missing?</p>

<pre><code>  CREATE PROCEDURE truncate_tables()
  AS
        truncate table dbo.table1
        truncate table dbo.table2
        truncate table dbo.table3
</code></pre>