kuailewangzi1212

摘要： create view SystemInfoasSELECT table_name,ordinal_position as colorder,column_name as colName, case extra when 'auto_increment' then 1 else 0 end as IsIdentity, case column_key when 'pri' then 1 else 0 end as isKey, data_type as type,0 as bits, case when character_maximum_length is N 阅读全文

摘要： 使用方法call USP_P_SPLITPAGE 'select * from tt',1,10;------------------------DELIMITER $$DROP PROCEDURE IF EXISTS `USP_P_SPLITPAGE` $$CREATE DEFINER=`root`@`localhost` PROCEDURE `USP_P_SPLITPAGE`(`sql` varchar(1024),pagesize int,CURRENTPAGE int)BEGIN SET @skip= (CURRENTPAGE - 1 )* pagesize ; SET 阅读全文

摘要： $PBExportHeader$uf_exesqlfile.srfglobal type uf_exesqlfile from function_objectend typeforward prototypesglobal function integer uf_exesqlfile (string astr_file, transaction atrs_sql)end prototypesglobal function integer uf_exesqlfile (string astr_file, transaction atrs_sql);int fstring ls_filels_fi 阅读全文

摘要： declare @i intselect @i=1while @i<=10begin print @i select @i=@i + 1end 阅读全文

摘要： //-----------------通过sql语句动态创建一个datastore对象//gf_getdsfromsql//datastore:adw_dw//string:as_sql//transaction:atrs_sqlcastring ERRORS, sql_syntaxstring presentation_str, dwsyntax_strsql_syntax = as_sqlpresentation_str = "style(type=grid)"dwsyntax_str = atrs_sqlca.SyntaxFromSQL(sql_syntax, pre 阅读全文

摘要： create function IsEmpty(@a varchar(200),@b varchar(200)) returns varchar(200)as/* */begin declare @rtn varchar(200) select @rtn='' select @a=isnull(@a,'') if @a='' begin select @rtn=@b end else begin select @rtn=@a end return @rtnend 阅读全文

摘要： create 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=ltrim(rtrim(@old_str))+@split select @li_p=0 w 阅读全文

摘要： getitemstatus和setitemstatusNotModified!:没有修改过DataModified!:修改过New!:数据时新增的还没有输入数据NewModified!:改行数据时新增的，且已经做了修改 阅读全文

摘要： 列的protect 属性case( flag when '0' then 1 else 0) 阅读全文

摘要： 数据结构 create table settlement_m ( settlement_bi char (12) not null , folio_ref char (10) null , supplier_id char (6) null , str_dt varchar(8), end_dt varchar(8), input_dt datetime null , inputter char (10) null , audite_dt datetime null , auditer char (10) null , status char (1) default ('0') 阅读全文