eric@picard.sbi.com (Eric Ho) (11/14/90)
Hi,
Just wondering if anyone know any fixes to these Sybase internals problems :-
1). I need to delete a column from a table. People told me that there is no
easy way to do it (i.e. you either do bcp's to bulk copy out a table and
basically recreate the table -- doable but yucky. Or you somehow mark the
column using sp_rename but this means that I'll do all the
allocations/management myself -- not a pleasant thought).
2). I need to pass parameters/variables into the from-clause of a select
statement within the context of a stored procedure - e.g. a stored
procedure, P, takes 1 argument, x, and I need to use the value of x in the
from-caluse of a select statement. Right now, I've resort to write it in
C but somehow I thought that Sybase's SQL engine should be able to handle
this -- afterall, this is not a SQL thing by a Sybase specific on its
stored-procedures.
Just wondering if anyone has any workarounds/fixes on this ?eric@picard.sbi.com (Eric Ho) (11/14/90)
Hi,
Just wondering if anyone know any fixes to these Sybase internals problems :-
1). I need to delete a column from a table. People told me that there is no
easy way to do it (i.e. you either do bcp's to bulk copy out a table and
basically recreate the table -- doable but yucky. Or you somehow mark the
column using sp_rename but this means that I'll do all the
allocations/management myself -- not a pleasant thought).
2). I need to pass parameters/variables into the from-clause of a select
statement within the context of a stored procedure - e.g. a stored
procedure, P, takes 1 argument, x, and I need to use the value of x in the
from-caluse of a select statement. Right now, I've resort to write it in
C but somehow I thought that Sybase's SQL engine should be able to handle
this -- afterall, this is not a SQL thing by a Sybase specific on its
stored-procedures.
Just wondering if anyone has any workarounds/fixes on this ?
--
==========================================
- Eric Ho -
- Salomon Brothers, Inc. [eric@picard.sbi.com]
==========================================