... DECLATE @Sql nvarchar(4000) SET @Sql = 'select IDENTITY (tinyint, ' + CAST(@Num) AS nvrachar(3) + ',1 ) AS id_num, ' + 'MZ into aa from driverTemp ' + 'where MZ IS NOT NULL group by MZ order by MZ' EXECUTE (@Sql) ...>Hello ,everyone!
>use taxi >IF EXISTS(SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES > WHERE TABLE_NAME = 'aa') > DROP TABLE aa >GO > >declare @Num as tinyint >select @Num=max(CodeId) from c_mz > >select IDENTITY (tinyint,@Num ,1 ) AS id_num, MZ into aa from driverTemp where MZ IS NOT NULL group by MZ order by MZ > >go>