SQL Server 2008: how to give a value of a field in a column and return the column identity

Question

I have a stored procedure that updates my table data.

update tbl_duty
set Name = @DName,
    Necessity = @DNecessity,
    Payment = @DPayment,
    [Estimation Time] = @DEstimationTime,
    Term = @DTerm,
    [Description] = @DDescription
where 
    Id = "what can I put here"

but I don't now how get the ID of column to update because it generated itself (identity column)

Anyone can help me?

Do we have something like GETIDENTITY(column name)?

Are you sure you want an update query and not an insert query? — Dan Bracuk, Dec 29 '13 at 15:52
Does this help? http://stackoverflow.com/questions/1610509/getting-the-id-of-a-row-i-updated-in-sql-server — Panu Oksala, Dec 29 '13 at 15:53
Thanks but No. It was For after Update. I want it before my updating process! — user3139219, Dec 29 '13 at 16:02
Somehow you have to identify the record you want to update. From where are you sending the other parameters? — Dan Bracuk, Dec 29 '13 at 16:23

score 1 · Accepted Answer · answered Dec 29 '13 at 16:00

1

Do you want something like this?

update tbl_duty
set Name = @DName,
    Necessity = @DNecessity,
    Payment = @DPayment,
    [Estimation Time] = @DEstimationTime,
    Term = @DTerm,
    [Description] = @DDescription
where id = (select max(id) from tbl_duty);

This seems very dangerous. Why wouldn't you insert the records with the right values in the first place?

answered Dec 29 '13 at 16:00

Gordon Linoff

1,242,037
58
646
786

how can i get the right values. the id generated itself. i don't have it – user3139219 Dec 29 '13 at 16:24

SQL Server 2008: how to give a value of a field in a column and return the column identity

1 Answers1