行列互转[代码]sql替换字符串 substring replace[代码]SQL查询一个表内相同纪录 having如果一个ID可以区分的话,可以这么写[代码]如果几个ID才能区分的话,可以这么写[代码]其他回答:数据表是zy_bho,想找出ZYH字段名相同的记录[代码]把多行SQL数据变成一条多列数据,即新增列[代码]表复制[代码]语法1:Insert INTO table(field1,field2,...) values(value1,value2,...)语法2:Insert into Table2(field1,field2,...) select value1,value2,... Read More
posted @ 2010-12-05 23:05 Fandy Xie Views(361) Comments(0) Diggs(0) Edit
Using x++ code export AOT's Jobs path treenode to the disk wrote by Jimmy onDEC.5th 2010Export Tree node to the disk Read More
posted @ 2010-12-05 18:24 Fandy Xie Views(197) Comments(0) Diggs(0) Edit
http://files.cnblogs.com/Jimmyx/Class_SysMultiTableLookup.rarThe SysMultiTableLookup.rar is a class to show multi table information.When you want to create a sales line in SO, You can selet an item and see some information of item. Those information is from invent table.But sometimes you want those Read More
posted @ 2010-12-05 16:29 Fandy Xie Views(620) Comments(0) Diggs(0) Edit