精选 SQL 脚本

//----- 自动设置商品编号

SELECT ID, right( '100000'+ row_number()OVER(ORDER BY ID) ,6 ) AS maxBHao FROM Cloud_ChpInfo
ORDER BY ID