sybase
chujiazhen
coder
展开
-
sp debug
[b]sp debug method[/b]create table SPOptimizationTb ( spName varchar(100) not null , seq int ...原创 2011-08-16 11:20:42 · 150 阅读 · 0 评论 -
Sybase procedure output parameter
SYBASE ISSUSESsybase output parameter: declare @msg varchar(1024) set @msg = 'dsaf' exec CMUserSearch_jason 'xs05319', 'LS', @msg output select @msg if you want to get output param in...原创 2011-08-25 18:11:22 · 156 阅读 · 0 评论 -
sybase
sybase dynamic sql demo and quatation escapeif exists(select * from sysobjects where name = 'testjson' and type='P') drop procedure testjsonsetuser 'dbo'gocreate procedure testjson(@p...原创 2011-08-02 12:26:20 · 67 阅读 · 0 评论 -
sybase sql test template
/*** a sql test template*/create table #a(id int,name varchar(10))select * into #b from #ainsert into #a values(4,'a1')insert into #a values(5,'a2')insert into #a values(6,'a3')...原创 2011-08-02 12:30:14 · 86 阅读 · 0 评论 -
sybase cursor and report
select 1 as seq, a.* into SelCommentaryList_jason from SelCommentaryList_terry_res1 a declare cursor_t cursorfor select sp_name,run_time,distance,counts from SelCommentaryList_jason order ...原创 2011-08-02 12:33:32 · 110 阅读 · 0 评论