22,209
社区成员
发帖
与我相关
我的任务
分享
--1
select max(数量) from tablea
--2
select stuff((select ','+rtrim(数量) from tablea for xml path('')),1,1,'')
--3
declare @str varchar(100)
set @str='2000,4000,2500,4800,3800,4500,8990'
select substring(stuff(','+@str+',',1,number,''),1,charindex(',',stuff(','+@str+',',1,number,''))-1) from master..spt_values where type='p' and number between 1 and len(@str)+1 and substring(','+@str+',',number,1)=','
--4
select 次序=row_number()over(order by getdate()),* from tablea