Forum Replies Created

Viewing post 1 (of 1 total)

  • RE: Update All Null of Field (data Tape "Bit") To False

    DECLARE

    @Table NVARCHAR(MAX),

    @Col NVARCHAR(MAX)

    DECLARE Table_Cursor CURSOR

    FOR

    SELECT a.name,b.name

    FROM sysobjects a,syscolumns b

    WHERE a.id = b.id

    AND a.xtype = 'u'

    AND (

    b.xtype = 104

    )

    OPEN Table_Cursor FETCH NEXT FROM Table_Cursor INTO @Table,@Col

    WHILE (@@FETCH_STATUS = 0)

    BEGIN

    EXEC

    (

    'update ['...

Viewing post 1 (of 1 total)