sql字符自动填充

Question

sql字符自动填充

Answer 1

mysql 里可以用select lpad（id,10,'0')实现sql serverselect REPLICATE('0',10-len(id))+cast(id as varchar) from tmp