GIDForums  

Go Back   GIDForums > Computer Programming Forums > MySQL / PHP Forum
Reload this Page Sybase Stored procedure
User Name
Password
Register FAQ Members List Calendar Search Today's Posts Mark Forums Read

 
 
Thread Tools Search this Thread Rate Thread
  #1  
Old 15-Oct-2008, 16:28
nancycoder nancycoder is offline
New Member
  
Join Date: Oct 2008
Posts: 14
nancycoder is an unknown quantity at this point

Sybase Stored procedure

hi everyone,

I need help with creating a stored procedure in Sybase. I have the same stored procedure created in SQL Server 2000. If anyone can help me to translate it to work with Sybase will be really appreciated.

The procedure actually increases the salary field of every row by 1% when executed and returns @param1 as the total salry of all rows in the table

Cheers!

-Nancy


Code:
Create proc
@param1 numeric(18,4) out
AS

update tblSalary set Salary = Salary + Salary * .01

Select @param1= sum(salary) from tblSalary
  #2  
Old 16-Oct-2008, 07:34
Howard_L Howard_L is offline
Regular Member
  
Join Date: Apr 2007
Location: Maryland/PA, USA
Posts: 803
Howard_L is a jewel in the roughHoward_L is a jewel in the roughHoward_L is a jewel in the rough

Re: Sybase Stored procedure

Is that using the sybase interface? or perl?

googling 'sybase php' or 'perl' yields plenty of good stuff!
Among them: http://us3.php.net/sybase
 
 
« Previous Thread | Next Thread »

Recent GIDBlogAccepted for Ph.D. program by crystalattice

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Stored procedure not working pritha MS Visual C++ / MFC Forum 0 24-Jan-2008 05:04
Will pay through Paypal if somebody helps me. paritoshcool Assembly Language 0 27-Nov-2007 23:27
multiple select in stored proc aie0 MySQL / PHP Forum 0 12-Jul-2006 08:11
Accessing a package that is stored on the internet sgware Java Forum 0 05-Apr-2006 22:59
#including resource file causing window procedure to be undeclared??? ubergeek C++ Forum 3 07-Feb-2005 15:39

Network Sites: GIDNetwork · GIDWebHosts · GIDSearch · Learning Journal by J de Silva, The

All times are GMT -6. The time now is 20:37.

Contact Us - GIDForums™ - Archive - Top

vBulletin, Copyright © 2000 - 2009, Jelsoft Enterprises Ltd.