Using Single Quotes in a dynamic SQL

[SnehaAgrawal]

Hi I want to know how can we use single quotted string as a part of dynamic sql
Consider the following code

exec('select branchid from '+@tablename+' where Entrystatus='NEW' AND BranchName= '+@branchname')
In the above query New is string like 'NEW'and BranchName is also a string so how am I suppose to write single quotes?
wht is the main funda behind using them?
thnks

[Uncle Dickie]

Does this article help?

[jvskarthick]

exec('select branchid from '+@tablename+' where Entrystatus=''NEW'' AND BranchName= '+@branchname')

Just change 'NEW' to ''NEW'' and try it...

Reg,
JK

[Delerna]

exec(
   'select branchid 
   from '+@tablename+' 
   where Entrystatus=' + char(39)+'NEW' +char(39) +'
   AND BranchName= '+ char(39) + @branchname + char(39)
)
 

or this might look cleaner to read

 
declare @New
set @New=char(39) + 'NEW' + char(39)
set @branchname=char(39) + @branchname + char(39)
exec('select branchid from ' + @tablename + ' where Entrystatus=' + @New +' AND BranchName= ' + @branchname)
 

39 is the ASCII code for a single quote

[Delerna]

and as Uncle dickie highlights

this
select 'test '''+'hello'+''' test'

also works
interresting !

[SnehaAgrawal]

thnks for the solution