Using Case in SQL Insert Statement

11y1.3kCode

This code snippet gives an example for using case inside insert statement.

Code snippet for using CASE inseide value part of insert statement:

INSERT INTO [DTWL].[dbo].[Transation_Log_Master]
([Description]
,[TranDate]
,[TranByUser]
,[TableName]
,[RowID])
VALUES
( CASE @Operation
WHEN 1 THEN 'New Addes'
WHEN 2 THEN 'Updated'
ELSE 'Deleted'
END
,Getdate()
,@UserID
,'DistributorPoint'
,@ID)