Get SQL Computed Column Inserted Value?

INSERT tbl_Info (Title) OUTPUT INSERTED. ShortenKey VALUES ('new title') Note: may not work with computed columns says MSDN, if I read it correctly.

Thanks for the response, but this error..."Column 'inserted. ShortenKey' cannot be referenced in the OUTPUT clause because the column definition contains a subquery or references a function that performs user or system data access. A function is assumed by default to perform data access if it is not schemabound.

Consider removing the subquery or function from the column definition or removing the column from the OUTPUT clause. " – Kushan Hasithe Fernando Jun 15 at 8:23 1 Add WITH SCHEMABINDING to the fucntion – gbn Jun 15 at 8:35.

Use SCOPE_IDENTITY to get the new identity value. Then query the newly inserted row. SELECT ShortenKey FROM dbo.

Tbl_Info WHERE SSEID = SCOPE_IDENTITY().

Gbn My code sample returns ShortenKey. Am I missing something? – Anthony Faull Jun 15 at 13:27.

I cant really gove you an answer,but what I can give you is a way to a solution, that is you have to find the anglde that you relate to or peaks your interest. A good paper is one that people get drawn into because it reaches them ln some way.As for me WW11 to me, I think of the holocaust and the effect it had on the survivors, their families and those who stood by and did nothing until it was too late.