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 Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Dynamic SQL

Status
Not open for further replies.

Guest_imported

New member
Jan 1, 1970
0
Could anyone suggest me how to write dynamic SQL in Sybase 12.0 Server

Thanks.
 
Hi,

Try this simple one first:
============================
declare @mysql varchar(255)
select @mysql="create table tmp_xyz ( col1 int, col2 char(2))"

execcute(@mysql)
=============================
Once you get the feel of it, try the complex ones.

RajD
 
Is it possible to do this for SYBASE 10.x or 11.x?

Thanks.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top