• Is DateStamp a column name in emDetail?

    If so, your syntax is going to be more like this:

    update dbo.emDetail

    set dateYear = DATEPART('year',datestamp)

    Remember single quotes for literals in T-SQL.

    If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.