Hello Database Masters:

Im a newbie to the SQL server world, basically I have a table with 3 column
CountryID, CountryName and Currency in the insert i will just insert two values for CountryName and Currency
and the CountryID will populate automatically using a trigger eg: CYYYYMMDDHHSS(Code|Year|Month|Day|Hour|Seconds)

Can some expert help me with my problem?