Sorry lupa ngasih contohnya.

declare sp_outputprm PROCEDURE FOR 
 @rc = dbo.sp_output
 @tgl_skr = :tgl_sys,
 @param1 = 0 output,
 @param2 = 0 output
USING SQLCA;

EXECUTE sp_outputprm;

if SQLCA.sqlcode = 0 then
 
fetch closebranch into :ll_return,:ll_param1,:ll_param2;



  -----Original Message-----
  From: kalam-ian [mailto:[EMAIL PROTECTED]


  Hi PBers,

  Database SQLServer 7,
  Saya punya stored procedure seperti ini :
  create procedure sp_GetDateChar
     @@TGL char(10) OUTPUT
  as
  begin
    select @@TGL=Convert(char(10),Getdate(),111)
  end


[Non-text portions of this message have been removed]



------------------------ Yahoo! Groups Sponsor --------------------~--> 
$9.95 domain names from Yahoo!. Register anything.
http://us.click.yahoo.com/J8kdrA/y20IAA/yQLSAA/NhFolB/TM
--------------------------------------------------------------------~-> 

IndoPB - Indonesia PB User Group 
To Post a message, send it to: [EMAIL PROTECTED]
To Unsubscribe,send a blank message to: [EMAIL PROTECTED] 
Yahoo! Groups Links

<*> To visit your group on the web, go to:
    http://groups.yahoo.com/group/indopb/

<*> To unsubscribe from this group, send an email to:
    [EMAIL PROTECTED]

<*> Your use of Yahoo! Groups is subject to:
    http://docs.yahoo.com/info/terms/
 

Kirim email ke