cursor_proc.sql

来自「sybase linux or unix develope library pa」· SQL 代码 · 共 10 行

use tempdb
go
if exists ( select 1 from sysobjects where type = 'P' and name = 'testproc' )
	drop proc testproc
go
create proc testproc (@type char(5))
as
	select name from sysobjects where type = @type
go