Iterate through all tables in the database, updating the values of the columns that are datetime types

declare @tablename nvarchar (80)
declare @cloumn nvarchar (80)
declare @sql nvarchar (400)
DECLARE c1 cursor Scroll for
Select Table_name,column_name from Information_schema.columns where data_type= ' datetime '
Open C1
Fetch first from C1 to @tablename, @cloumn
While @ @fetch_status =0
Begin

Set @sql = ' Update '[email protected]+ ' Set '[email protected]+ ' =dateadd (yy,10, '[email protected]+ ') where '[email protected]+ ' is not NULL ';
EXEC (@sql)
FETCH NEXT from C1 to @tablename, @cloumn
End
Close C1

Iterate through all tables in the database, updating the values of the columns that are datetime types