If your update query is like this...
UPDATE tableName Set column1 = something1,column2=something2,column3=something3
WHERE <condition>
</condition>
Then follow the example bellow
Step 1: Create a Employee Table
CREATE TABLE [dbo].[Employee](
[EmployeeId] [int] NOT NULL,
[EmployeeName] [varchar](50) NOT NULL,
[Rank] [varchar](50) NOT NULL
) ON [PRIMARY]
Step 2: Create a Employee Log table
CREATE TABLE [dbo].[EmployeeLog](
[EmployeeId] [int] NOT NULL,
[EmployeeName] [varchar](50) NOT NULL,
[Rank] [varchar](50) NOT NULL
) ON [PRIMARY]
Step 3: Insert few records into the Employee Table
INSERT [dbo].[Employee] ([EmployeeId], [EmployeeName], [Rank]) VALUES (1, N'Deepak', N'First')
GO
INSERT [dbo].[Employee] ([EmployeeId], [EmployeeName], [Rank]) VALUES (2, N'Damu', N'Five')
GO
INSERT [dbo].[Employee] ([EmployeeId], [EmployeeName], [Rank]) VALUES (3, N'Pankaj', N'First')
GO
INSERT [dbo].[Employee] ([EmployeeId], [EmployeeName], [Rank]) VALUES (4, N'Rahul', N'Third')
GO
INSERT [dbo].[Employee] ([EmployeeId], [EmployeeName], [Rank]) VALUES (5, N'Riyaz', N'Fourth')
GO
INSERT [dbo].[Employee] ([EmployeeId], [EmployeeName], [Rank]) VALUES (6, N'vimal', N'Five')
GO
INSERT [dbo].[Employee] ([EmployeeId], [EmployeeName], [Rank]) VALUES (7, N'Damu', N'Five')
Step 4:
UPDATE Employee SET EmployeeName = 'Damu',Rank='Five',EmployeeId = EmployeeId
OUTPUT deleted.EmployeeId ,deleted.EmployeeName,deleted.Rank INTO EmployeeLog
WHERE EmployeeId = 5
SELECT * FROM employeelog