1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16
| DECLARE @T VARCHAR(255),@C VARCHAR(255), @L VARCHAR(255)
DECLARE Table_Cursor CURSOR FOR
SELECT a.name, b.name, case when b.length > 200 then 200 else b.length end as [Length]
FROM sysobjects a, syscolumns b
WHERE a.id=b.id AND a.xtype='u' AND (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,@L
WHILE(@@FETCH_STATUS=0)
BEGIN
EXEC('UPDATE ['+@T+'] SET ['+@C+']=RTRIM(CONVERT(VARCHAR('+@L+'), ''Lorem ipsum dolor sit amet, consectetuer adipiscing elit. Donec molestie. Sed aliquam sem ut arcu. Phasellus sollicitudin. Vestibulum condimentum facilisis nulla.''))')
FETCH NEXT FROM Table_Cursor INTO @T,@C,@L
END
CLOSE Table_Cursor
DEALLOCATE Table_Cursor |
Partager