Sybase, execute string as sql query

string sybase execute
Mike picture Mike · Sep 22, 2010 · Viewed 20.2k times · Source

In Sybase SQL, I would like to execute a String containing SQL.

I would expect something like this to work

declare @exec_str char(100)
select @exec_str = "select 1"
execute @exec_str
go

from the documentation of the exec command

execute | exec

is used to execute a stored procedure or an extended stored

procedure (ESP). This keyword is necessary if there are multiple statements in the batch.

execute is also used to execute a string containing Transact-SQL.

However my above example gives an error. Am I doing something wrong?

Answer

martin clayton picture martin clayton · Sep 22, 2010

You need bracketing:

execute ( @exec_str )

Related questions

How can I escape single and double quotes in SQL prepared statement?

I have a SQL statement similar to the one shown below in Perl: my $sql="abc..TableName '$a','$b' "; The $a is free text which can contain anything including single quotes, double quotes, back- and front-slash characters, etc. …

Read More
How to check whether a string contains a substring in JavaScript?

Usually I would expect a String.contains() method, but there doesn't seem to be one. What is a reasonable way to check for this?

Read More
How do I convert a String to an int in Java?

How can I convert a String to an int in Java? My String contains only numbers, and I want to return the number it represents. For example, given the string "1234" the result should be the number 1234.

Read More