--> 数据库版本: --> Microsoft SQL Server 2008 (RTM) - 10.0.1600.22 --> 测试数据:[TB] IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[TB]') AND type in (N'U')) DROP TABLE [TB] GO---->建表 create table [TB](id int) insert [TB] select 1 union all select 2 union all select 3 union all select 4 GO-- 品名 品号 价格 --1 aa 111 16 --2 bb 222 20 --3 cc 333 32 --> 查询结果select right('0000'+cast(id as varchar),5) from TB --> 删除表格 --DROP TABLE [TB]
--> 数据库版本:
--> Microsoft SQL Server 2008 (RTM) - 10.0.1600.22
--> 测试数据:[TB]
IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[TB]')
AND type in (N'U'))
DROP TABLE [TB]
GO---->建表
create table [TB](id int)
insert [TB]
select 1 union all
select 2 union all
select 3 union all
select 4
GO-- 品名 品号 价格
--1 aa 111 16
--2 bb 222 20
--3 cc 333 32
--> 查询结果select right('0000'+cast(id as varchar),5) from TB
--> 删除表格
--DROP TABLE [TB]