摘要: SET QUOTED_IDENTIFIER ONGOSET ANSI_NULLS ONGOALTER function uf_getStrBySplit(@old_str varchar(8000),@split varchar(50),@pos int) returns varchar(200)as/* 功能描述:返回分割后的字符串的第几个字符串 参数说明:@old_str:原字符串 @split:分隔符 @pos:第几个*/begin declare @rtn varchar(200), @li_p int select @rtn='' select @old_str=lt 阅读全文
posted @ 2011-03-31 16:09 kuailewangzi1212 阅读(527) 评论(0) 推荐(0)
摘要: $PBExportHeader$uf_stringsplit.srfglobal type uf_stringsplit from function_objectend typeforward prototypesglobal function integer uf_stringsplit (string astr_str, string astr_split, ref string astr_rtn[])end prototypesglobal function integer uf_stringsplit (string astr_str, string astr_split, ref s 阅读全文
posted @ 2011-03-31 15:11 kuailewangzi1212 阅读(221) 评论(0) 推荐(0)
摘要: $PBExportHeader$gf_getmoney.srf$PBExportComments$获取金额的大写格式global type gf_getmoney from function_objectend typeforward prototypesglobal function string gf_getmoney (decimal dsum)end prototypesglobal function string gf_getmoney (decimal dsum);/*-----------------------------------功能描述:获取一个金额的大写格式--参数及返 阅读全文
posted @ 2011-03-31 15:10 kuailewangzi1212 阅读(274) 评论(0) 推荐(0)
摘要: $PBExportHeader$uf_replace.srfglobal type uf_replace from function_objectend typeforward prototypesglobal function string uf_replace (string astr_str, string astr_old, string astr_new)end prototypesglobal function string uf_replace (string astr_str, string astr_old, string astr_new);string old_str, 阅读全文
posted @ 2011-03-31 15:10 kuailewangzi1212 阅读(150) 评论(0) 推荐(0)