ID Name ShuLiang
1 上衣 3
查询结果
ID Name
1 上衣
1 上衣
1 上衣
把数量改为查询的记录数量
------解决方案--------------------
- SQL code
use Tempdbgo--> --> if not object_id(N'Tempdb..#T1') is null drop table #T1GoCreate table #T1([ID] int,[Name] nvarchar(2),[ShuLiang] int)Insert #T1select 1,N'上衣',3GoSelect a.[ID],a.Namefrom #T1 AS aINNER JOIN master.dbo.spt_values AS b ON b.type='P' AND b.number<a.[ShuLiang]/*ID Name1 上衣1 上衣1 上衣*/