SQLTeam.com | Weblogs | Forums

How to add single cot in bunch of values instanly

3000
160
50
80
any way to do as follows instantly without manual add
'3000'
'160'
'50'
'80'

sample data script

drop table #Temp
create table #Temp(No int)

insert into #Temp select 3000
insert into #Temp select 160
insert into #Temp select 50
insert into #Temp select 80

select * from #Temp

select 
  QUOTENAME(No,'''') 
from 
  #Temp

image

why do you want to do that?

there are more than 100000 values to get in to select Q

Not sure I understand. What will ise this data or are you just learning