declare @allProvinceId varchar(1000)
set @allProvinceId=''
select @allProvinceId=@allProvinceId+CONVERT(varchar(10),ProvinceID)+',' from dbo.PROVINCE order by ProvinceID asc
select @allProvinceId查询结果为:
110000,120000,130000,140000,150000,210000,220000,230000,310000,320000,330000,340000,350000,360000,370000,410000,420000,430000,440000,450000,460000,500000,510000,520000,530000,540000,610000,620000,630000,640000,650000,710000,810000,820000,
set @allProvinceId=''
select @allProvinceId=@allProvinceId+CONVERT(varchar(10),ProvinceID)+',' from dbo.PROVINCE order by ProvinceID asc
select @allProvinceId查询结果为:
110000,120000,130000,140000,150000,210000,220000,230000,310000,320000,330000,340000,350000,360000,370000,410000,420000,430000,440000,450000,460000,500000,510000,520000,530000,540000,610000,620000,630000,640000,650000,710000,810000,820000,
只要字符不超过varchar(1000)
这个就行