how to wirte a stored procedure which takes query as parameter

mohanrao · #1 (**permalink**) 04-29-08, 02:45

Hi,
Can some one help me to write a Sybase stored procedure, which takes sql query as parameter.The procedure should execute that query.

For this i am wonder is there any function in sybase which takes sql query as query and executes it..

mike_bike_kite · #2 (**permalink**) 04-29-08, 05:25

Code:

declare @s varchar(255)
select @s = "select 25 * 5"
exec (@s)

Just google for dynamic sql. Passing the sql string (or building it in the stored proc) should be the same as passing any string to a stored proc.

Mike

mohanrao · #3 (**permalink**) 04-29-08, 08:43

thank you..

stuarta · #4 (**permalink**) 04-30-08, 09:50

USE sybsystemprocs
go
IF OBJECT_ID('dbo.sp_dba_dynaSQL') IS NOT NULL
BEGIN
DROP PROCEDURE dbo.sp_dba_dynaSQL
IF OBJECT_ID('dbo.sp_dba_dynaSQL') IS NOT NULL
PRINT '<<< FAILED DROPPING PROCEDURE dbo.sp_dba_dynaSQL >>>'
ELSE
PRINT '<<< DROPPED PROCEDURE dbo.sp_dba_dynaSQL >>>'
END
go
create proc sp_dba_dynaSQL @sqlstring varchar(1000)
as
exec (@sqlstring)
go
EXEC sp_procxmode 'dbo.sp_dba_dynaSQL','unchained'
go
IF OBJECT_ID('dbo.sp_dba_dynaSQL') IS NOT NULL
PRINT '<<< CREATED PROCEDURE dbo.sp_dba_dynaSQL >>>'
ELSE
PRINT '<<< FAILED CREATING PROCEDURE dbo.sp_dba_dynaSQL >>>'
go

Internet Services

Web Development

Digital Marketing

Consumer Tech