DECLARE @sql varchar(2000);
DECLARE @tableName sysname;
DECLARE @columnName sysname;

DECLARE theCursor CURSOR FOR
SELECT TABLE_NAME, COLUMN_NAME
FROM INFORMATION_SCHEMA.COLUMNS
WHERE
DATA_TYPE = 'date' or DATA_TYPE = 'datetime'
OPEN theCursor;
FETCH NEXT FROM theCursor INTO @tableName, @columnName;
WHILE @@FETCH_STATUS = 0
BEGIN
SET @sql = 'SELECT ''' + @tableName + ''' as [TabelName], ' +
           '''' + @columnName + ''' AS [ColumnName], ' +
           'DATEPART(yy, ' + QUOTENAME(@columnName) +
           ') AS [Year], COUNT(1) AS [NumberofRows] FROM ' + QUOTENAME(@tableName) +
           ' GROUP BY DATEPART(yy, ' + QUOTENAME(@columnName) + ')';
PRINT @sql;
EXEC (@sql);
FETCH NEXT FROM theCursor INTO @tableName, @columnName;
END
CLOSE theCursor
DEALLOCATE theCursor;