tsql - SQL - 从 INT(127 -> A000127) 创建固定长度的字符串
解决方案
我没有可用于检查语法的管理工作室,但它应该是这样的:
SELECT existing, [new] = CONCAT('A', RIGHT(CONCAT('000000', CAST(existing AS VARCHAR(6)), 6))
FROM tableName;
-- if you have table and want to add a column containing that data:
ALTER TABLE tableName ADD COLUMN [new] CHAR(7) NULL; -- should create new column
UPDATE tableName SET New = CONCAT('A', RIGHT(CONCAT('000000', CAST(existing AS VARCHAR(6)), 6))
原理是:
- 将数字转换为“127”之类的文本
- 追加到左边 6 '0' ('000000' + '127')
- 从该字符串'000000127'中取出最右边的6个字符('000127')
- 将“A”附加到左侧:“A000127”
推荐阅读
- javascript - 复杂数组的 Javascript 循环与 C 循环
- html - 添加 Html 标签使我的段落翻倍
- angular - Angular pass data to an imported module
- python - After scaling or normalizing values the graph is changed Python Sklearn pandas
- android - Migrate Intentservices to Workmanager
- django - How to use NTML Authentication in Angular 4 - Django REST project
- log4j - Hazelcast 日志模式解释
- angular - 离子从 URL 获取数据
- c++ - how can I bind a class member function with param as rvalue to boost::function?
- android - Is it possible to get SurfaceTexture dimensions?