create table #quotetable
(
name varchar(100)
)
insert into #quotetable
select 'Anurag'
select quotename(name) from #quotetable-----[Anurag]
select quotename(name,'<') from #quotetable--<Anurag>
select quotename(name,'(') from #quotetable--(Anurag)
select quotename(name,'"') from #quotetable--"Anurag"
(
name varchar(100)
)
insert into #quotetable
select 'Anurag'
select quotename(name) from #quotetable-----[Anurag]
select quotename(name,'<') from #quotetable--<Anurag>
select quotename(name,'(') from #quotetable--(Anurag)
select quotename(name,'"') from #quotetable--"Anurag"
No comments:
Post a Comment