chujiazhen的专栏

[b]sp debug method[/b] create table SPOptimizationTb ( spName varchar(100) not null , seq int ...

SYBASE ISSUSES sybase 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...

sybase dynamic sql demo and quatation escape if exists(select * from sysobjects where name = 'testjson' and type='P') drop procedure testjson setuser 'dbo' go create procedure testjson(@p...

/** * a sql test template */ create table #a(id int, name varchar(10) ) select * into #b from #a insert into #a values(4,'a1') insert into #a values(5,'a2') insert into #a values(6,'a3') ...

select 1 as seq, a.* into SelCommentaryList_jason from SelCommentaryList_terry_res1 a declare cursor_t cursor for select sp_name,run_time,distance,counts from SelCommentaryList_jason order ...