<div>
-- This is the varchar<br />
SELECT CONVERT(VARCHAR(4),YEAR(ge<wbr />tdate())) + RIGHT('0' + CONVERT(VARCHAR(2),MONTH(g<wbr />etdate()))<wbr />,2)<br />
<br />
The use of RIGHT('0'.. is required because February will evaluate to 2, and not 02, so to correct this add a zero to the left side and take the right-most two characters. <br />
<br />
-- This is an int, assuming you'll want to do math on this value then any numeric is better<br />
SELECT (CONVERT(VARCHAR(4),YEAR(g<wbr />etdate()))<wbr /> * 100) + CONVERT(VARCHAR(2),MONTH(g<wbr />etdate()))<wbr />
</div>


-- This is the varchar
SELECT CONVERT(VARCHAR(4),YEAR(getdate())) + RIGHT('0' + CONVERT(VARCHAR(2),MONTH(getdate())),2)

The use of RIGHT('0'.. is required because February will evaluate to 2, and not 02, so to correct this add a zero to the left side and take the right-most two characters.

-- This is an int, assuming you'll want to do math on this value then any numeric is better
SELECT (CONVERT(VARCHAR(4),YEAR(getdate())) * 100) + CONVERT(VARCHAR(2),MONTH(getdate()))

<div>
qry_mmyy varchar(6) default CONVERT(varchar(6), getdate(), 112)
</div>


qry_mmyy varchar(6) default CONVERT(varchar(6), getdate(), 112)

<div>
Just to clarify for sure:<br />
I assume you mean &quot;computed column&quot; rather than &quot;calculated column&quot;?
</div>


Just to clarify for sure:
I assume you mean "computed column" rather than "calculated column"?

<div>
<div class="content wysiwyg-content">
I am trying to create a table and set a default value for one of the field to 'yyyymm'<br />
the code I am using is <br />
<br />

<pre><code id="code-10-28610259-1">qry_mmyy varchar(6) default (CONVERT(VARCHAR(4),YEAR(getdate()) + CONVERT(VARCHAR(2),MONTH(getdate())))),</code></pre>
<br />
I am getting 2017 still though instead of 201502<br />
<br />
any ideas would be welcome<br />
<br />
thanks
</div>
</div>


I am trying to create a table and set a default value for one of the field to 'yyyymm'
the code I am using is 

(CODE)

I am getting 2017 still though instead of 201502

any ideas would be welcome

thanks

Setting default value when creating table

Microsoft SQL Server 2008 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. Major improvements include the  Always On technologies and support for unstructured data types.

Microsoft SQL Server 2008

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.