• 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.