lundi 28 mars 2016

Generate month and year from date and store automatically in table

Im working on sql server 2005, i have a column 'Date' of datatype datetime and want to extract month and year separately and store it in two separate columns in the same table as 'Date'. How do i do this and make it happen automatically everytime a new entry is entered where i dont have to manually input month and date.

Aucun commentaire:

Enregistrer un commentaire