SQL SERVER TUTORIAL IN DEPTH

The blog is to help users about sql server

Others

LightBlog

Breaking

Saturday, 21 December 2013

Quotename in sql

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"


No comments:

Post a Comment

 test