title: Truncate multiple tables in SQL Server using stored procedure
body: <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>