sybase

sybase dynamic sql demo and quatation escape

if exists(select * from sysobjects where name = 'testjson' and type='P')
drop procedure testjson

setuser 'dbo'
go
create procedure testjson(@p varchar(200))
as
begin
print @p
select distinct siteId from AlertWebsiteTb
end
go

declare @pa varchar(10)
select @pa = 'hello'

declare @params varchar(300)
select @params = 'exec testjson @pa'
exec (@params)

-- if the params is hard-coded
declare @params varchar(300)
-- select @params = 'exec testjson "hello"'
-- select @params = "exec testjson 'hello'"
-- select @params = "exec testjson ""hello"""
select @params = 'exec testjson ''hello'''
exec (@params)

if exists(select * from sysobjects where name = 'testjson' and type='P')
drop procedure testjson