Path: utzoo!utgpu!news-server.csri.toronto.edu!cs.utexas.edu!uunet!sbi!zeus!joule!picard.sbi.com!eric From: eric@picard.sbi.com (Eric Ho) Newsgroups: comp.databases Subject: Sybase internals (question + suggestion) ... Message-ID: Date: 13 Nov 90 21:19:01 GMT Sender: news@joule.Sbi.COM Distribution: comp Organization: Salomon Brothers Inc. Lines: 25 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] ==========================================