USE [MaBase] GO DECLARE @SQLCMD AS VARCHAR(8000) DECLARE @DBName AS VARCHAR(255) SET @DBName = 'MaBase' DECLARE CURSORLISTCHEMA CURSOR FOR SELECT 'UPDATE ['+ @DBName +'].['+ Usr.name +'].['+ Obj.name +'] SET ['+ Col.name +']=RTRIM(['+ Col.name +'])' FROM dbo.syscolumns Col INNER JOIN dbo.sysobjects Obj ON Col.id = Obj.id INNER JOIN dbo.sysusers Usr ON Obj.uid = Usr.uid WHERE (Col.xtype=231 OR Col.xtype=167) AND Obj.xtype ='U' OPEN CURSORLISTCHEMA FETCH NEXT FROM CURSORLISTCHEMA INTO @SQLCMD WHILE (@@fetch_status >= 0) BEGIN PRINT @SQLCMD --EXECUTE(@SQLCMD) FETCH NEXT FROM CURSORLISTCHEMA INTO @SQLCMD END CLOSE CURSORLISTCHEMA DEALLOCATE CURSORLISTCHEMA
Se souvenir du profil
Mot de passe oublié ? / Activation de compteCréer un compte
1 873 723 membres 17 nouveaux aujourd'hui 16 151 membres club