<div>
NO!<br />
<br />
you won't get &quot;leading zeros&quot; to start with e.g. 1 &lt;&gt;&nbsp;&quot;01&quot;<br />
<br />
and you cannot inject a table name into SQL through a variable like that, you need &quot;dynamic sql&quot; to do that.<br />
<br />
Do you want to &quot;truncate&quot; each table?<br />
<a href="https://docs.microsoft.com/en-us/sql/t-sql/statements/truncate-table-transact-sql" rel="ugc">https://docs.microsoft.com/en-us/sql/t-sql/statements/truncate-table-transact-sql</a>
</div>


<div>
Hi PortletPaul,<br />
<br />
&nbsp; &nbsp; DELETE FROM 'TDJURNAL' + ' + @Year + ' + @IntMonth<br />
<br />
Would you please how to code correctly for the above statement ?<br />
<br />
Thank you.
</div>


<div>
Please answer my question: &nbsp;<br />
<br />
<mark>Do you want to &quot;truncate&quot; each table?</mark> read the documentation first, url provided above
</div>


<div>
I want to use variable for table name.<br />
<br />
That's why I want to use looping.<br />
<br />
Thank you.
</div>


<div>
sigh....<br />
<br />
Please answer my question: &nbsp;<br />
<br />
<mark>Do you want to &quot;truncate&quot; each table?</mark> read the documentation first, url provided above<br />
<br />
<i>only then can I provide more</i>... I need to know if you want to truncate those tables, that is why I asked the question.
</div>


<div>
Just want to delete data as I code.<br />
<br />
Thank you,
</div>


<div>
From table TDJURNAL201701, XXXX201702 and etc.<br />
Using looping or any other better way.<br />
<br />
Thank you.
</div>


<div>
- I really don't know how to help - fully - if I don't understand the nature of those deletion.<br />
Yes, it is the right way.<br />
<br />
Great. It works.<br />
<br />
Thank you very much fo your help.
</div>


<div>
<div class="content wysiwyg-content">
Hi All,<br />
<br />
I try to delete table data. Please see below :<br />
<br />
WHILE ( @IntMonth &lt;= 12)<br />
BEGIN<br />
&nbsp; &nbsp; DELETE FROM 'TDJURNAL' + ' + @Year + ' + @IntMonth<br />
<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;SET @IntMonth = @IntMonth + 1<br />
END<br />
<br />
For example table name TDJURNAL201701 to 201712.<br />
<br />
How could I do it ?<br />
<br />
Thank you.
</div>
</div>


Hi All,

I try to delete table data. Please see below :

WHILE ( @IntMonth <= 12)
BEGIN
    DELETE FROM 'TDJURNAL' + ' + @Year + ' + @IntMonth

	SET @IntMonth = @IntMonth + 1
END

For example table name TDJURNAL201701 to 201712.

How could I do it ?

Thank you.

Delete table with year and month

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.