Get Updated Row Data

I never knew that such kind of things are there in SQL Server. Its amazing every person who works on SQL should know that. Its awesome.

 

Try those below queries with your table and columns 

/****** Script for SelectTopNRows command from SSMS  ******/

SELECT TOP 1000 [ID]

      ,[tblname]

      ,[UpdateTime]

  FROM [SQLToLinq].[dbo].[tblMNames]

  

  UPDATE 

                 tblMNames

  SET 

                 tblname='tblMnames'

  OUTPUT 

                INSERTED.UpdateTime , INSERTED.tblname

  WHERE 

                  tblname='tblMName'