不忿贴
http://topic.csdn.net/u/20120223/16/aa3db3f9-6f08-4798-bd60-ae60f99f1145.html?seed=1826980186&r=77651073#r_77651073
有很多txt文件,命名乱七八糟的,有几百个,
我现在想将这些文件重命名,用数字代替,1,2,3,4......这样,这个批处理怎么写呢?
有谁会,教教我,谢谢大家!
还想问个问题...专家分多少分才能穿4个裤衩..我左等右盼专家分到了1001 ,结果还是三个裤衩????? 唉??
--用windows 批出来还不会写类...用sql解决了! 我刚写好,你丫就结贴了...我亏啊!DECLARE @a AS INT=1,@b AS INT,@c AS VARCHAR(200)DECLARE @t AS TABLE(sn int IDENTITY(1,1),fname varchar(200))INSERT INTO @t EXEC xp_cmdshell 'dir D:\ll\ /o-d /b'SELECT * FROM @tSELECT @b=MAX(sn) FROM @tWHILE @a<@bBEGIN SELECT @c=fname FROM @t WHERE sn=@a DECLARE @q AS VARCHAR(1000)='xp_cmdshell ''rename D:\ll\'+@c+' '+CONVERT(VARCHAR(200),@a)+'.txt''' PRINT @q EXEC (@q) SET @a=@a+1END