Editing ray

Title / Description

Code
DECLARE @i INT,@page varchar(25),@coll varchar(50) SET @i = 1 WHILE (@i <= @count_add) BEGIN set @page= cast(@i as varchar(10))+'стр. клиентов: '; set @coll=(select COUNT(acc) from #TEMP where pages =@i) print @page+@coll exec('insert into dbo.Client (*) select * from #TEMP where pages >'+@i+'') SET @i = @i + 1 END SET @count_con=(select COUNT(1) from ctk_UserData) PRINT '_______________' PRINT 'Итого конвертов: '+@count_con PRINT '**************************************************'

Author

Highlight as C C++ CSS Clojure Delphi ERb Groovy (beta) HAML HTML JSON Java JavaScript PHP Plain text Python Ruby SQL XML YAML diff code