Wiki встроена в DVCS? [закрытый]

use BRSDATA;

begin try drop table #temp end try begin catch end catch ;

DECLARE @TableName nvarchar(250); 
DECLARE @ColumnName nvarchar(250); 

declare @x int;

DECLARE @FLOATV as float = 3.141592653;--searching for this in all float vals in all tables

SELECT t.name,c.name colname 
    into #temp
  FROM sys.tables AS t
  INNER JOIN sys.schemas AS s
  ON t.[schema_id] = s.[schema_id]
  inner join sys.columns AS c
  on c.object_id = t.object_id
  WHERE s.name = 'dbo'
  and type_desc = 'USER_TABLE'
  and exists(select * from  sys.types where name = 'float' and system_type_id = c.system_type_id);

  SET Nocount on;

  DECLARE FLOAT_TAB CURSOR FOR
    SELECT DISTINCT [name] from #temp;
        OPEN FLOAT_TAB;
        FETCH NEXT FROM FLOAT_TAB
        INTO @TableName;

        WHILE @@FETCH_STATUS = 0
        BEGIN
            DECLARE @SQL nvarchar(max) = '';
            DECLARE @COND nvarchar(max) = '';
            SET  @SQL = 'SELECT ';

             DECLARE COL_TAB CURSOR FOR
                SELECT colname from #temp where name = @TableName;
                    OPEN COL_TAB;
                    FETCH NEXT FROM COL_TAB
                        INTO @ColumnName;

                WHILE @@FETCH_STATUS = 0
                BEGIN

                    SET @SQL = @SQL + ' ' + @ColumnName + ',';
                    SET @COND = @COND + @ColumnName + ' = ' + cast(@floatv as nvarchar(60)) + ' OR ' ;
                    FETCH NEXT FROM col_tab INTO @ColumnName

                END

                SET @SQL = LEFT(@SQL, len(@sql) - 1) + ' FROM ' + @TableName +  ' WHERE ' + LEFT(@COND, LEN(@COND) - 3);
                print @sql;
                EXECUTE ( @SQL);
                close col_tab;
                deallocate col_tab;
                --waitfor  delay '00:05';
            FETCH NEXT FROM FLOAT_TAB into @tablename;
        END
        close float_tab
        deallocate float_tab;