Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Exec Command Stored Procedure
- Thread starter ghost2
- Start date
MartinCroft
Programmer
Hi
if your building dynamic sql within a string and want ' to be displayed as ' then add addtional ''
E.G
DECLARE @test varchar(100)
DECLARE @text varchar(100)
SET @text='microsoft'
SET @test ='Select * from orders where company = ' +
'''' +@text+''''
PRINT @test
if your building dynamic sql within a string and want ' to be displayed as ' then add addtional ''
E.G
DECLARE @test varchar(100)
DECLARE @text varchar(100)
SET @text='microsoft'
SET @test ='Select * from orders where company = ' +
'''' +@text+''''
PRINT @test
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question
- Locked
- Question