-- sybase-sp -- template for creating a stored procedure
-- $Id$ 
-- Carlos Duarte <cgd@mail.teleweb.pt>, 990925

-- run: isql -U_USER_ -P_PASS_ -S_SERVER_ -i _THIS_FILE_

use _DATABASE_
go

if exists (
	select 1
	from sysobjects 
	where type = "P" 
	and name = "_PROCEDURE_NAME_"
) drop procedure _PROCEDURE_NAME_
go

create procedure _PROCEDURE_NAME_ (
	@arg1	datetime, 		-- input arg
	@arg2	char(10), 		-- input arg
	@arg2	numeric output		-- output arg
) as begin 

	declare @local1 char(12)
	declare @local2 numeric

	-- SQL code...

	return 
end
go