How to write computed column in SQL Server

Hi chenna,

You can doing this stuff using After Insert Trigger on your table.

Ex :

CREATE TABLE dbo.Products
(
ID INT IDENTITY(1, 1)
NOT NULL ,
UserCode VARCHAR(20) ,
ComputedValue VARCHAR(50)
)

--------------------------------------------------------------

2) Then apply this trigger on Product table(Execute below query)

CREATE TRIGGER [dbo].[computedvalue_after_insert] ON [dbo].[Products]
AFTER INSERT
AS
BEGIN
SET NOCOUNT ON;
DECLARE @lastInsertedid INT
SET @lastInsertedid = ( SELECT IDENT_CURRENT('Products')
)
UPDATE Products
SET ComputedValue = UserCode
+ CONVERT(VARCHAR(50), @lastInsertedid)
WHERE ID = @lastInsertedid
END;

---------------------------------------------------------------------------------------------

3) Last Insert and select Statement

INSERT INTO dbo.Products
( UserCode, ComputedValue )
VALUES ( 'UserCode','')

SELECT *
FROM [Products]

 

Hi Chenna,

 

I think here is your answer.

 

https://www.mssqltips.com/sqlservertip/2784/understanding-column-properties-for-a-sql-server-table/

 

Please mark as answer if it is useful to you. 

 

Pleaser mark as answer if you find it useful to you.