<div>
Yes you can use a trigger to that,<br />
but why you want to store that data ? when you can derive it at any time
</div>


Yes you can use a trigger to that,
but why you want to store that data ? when you can derive it at any time

<div>
I needed it to make it easier to do reporting .....actually...I figured it out<br />
<br />
<br />
for call_month<br />
<br />
(case when ([FOTCCallDate] is not null) then (datepart(month,[FOTCCallD<wbr />ate])) else '' end)<br />
<br />
<br />
for call_year<br />
<br />
(case when ([FOTCCallDate] is not null) then (datepart(year,[FOTCCallDa<wbr />te])) else '' end)<br />
<br />
<br />
How can I close this case?
</div>


I needed it to make it easier to do reporting .....actually...I figured it out


for call_month

(case when ([FOTCCallDate] is not null) then (datepart(month,[FOTCCallDate])) else '' end)


for call_year

(case when ([FOTCCallDate] is not null) then (datepart(year,[FOTCCallDate])) else '' end)


How can I close this case?

<div>
Take a look at this<br />
<br />
<a href="https://www.experts-exchange.com/help.jsp#hs5" rel="ugc">https://www.experts-exchange.com/help.jsp#hs5</a>
</div>


Take a look at this

https://www.experts-exchange.com/help.jsp#hs5 [https://www.experts-exchange.com/help.jsp#hs5]

<div>
<div class="content wysiwyg-content">
I have a date column on my table defined as datetime (call_date) (not necessarily current date)<br />
<br />
I also have 2 columns named &nbsp;call_month and call_year ( both defined as varchar).<br />
<br />
I would like the call_month and call_year values to be defaulted to month and year portions of call_date respectively.<br />
<br />
Is it possible to do this using the default or formula values for the field definitions?<br />
<br />
<br />
For example if call_date is 5/24/06....call_month would default to 5 and call_year would default to 06<br />
<br />
<br />
I know I could do this using a trigger but just curious....
</div>
</div>


I have a date column on my table defined as datetime (call_date) (not necessarily current date)

I also have 2 columns named  call_month and call_year ( both defined as varchar).

I would like the call_month and call_year values to be defaulted to month and year portions of call_date respectively.

Is it possible to do this using the default or formula values for the field definitions?


For example if call_date is 5/24/06....call_month would default to 5 and call_year would default to 06


I know I could do this using a trigger but just curious....

Default column value using default or formula properties

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.