摘要：
declare @updatecount int begin TRANDECLARE @tbid INTSELECT @tbid=iMax FROM tbID WHERE strName='ipcclid'INSERT into pccl(ipcid,cph,crkdbh,drq,iywdwid,c... 阅读全文
posted @ 2016-01-06 17:11 ╰★张志峰★╮ 阅读(352) 评论(0) 推荐(0)
摘要：
IF OBJECT_ID ('skBuyProduct_Materiel_iMaterialType','TR') IS NOT NULLDROP TRIGGER skBuyProduct_Materiel_iMaterialType;GOCREATE TRIGGER skBuyProduct_Ma... 阅读全文
posted @ 2015-12-29 18:50 ╰★张志峰★╮ 阅读(309) 评论(0) 推荐(0)
摘要：
create trigger TR_MasterTable_Updateon MasterTableafter updateasif update ([Type])--当Type字段被更新时，才会触发此触发器insert into MasterLogTableselectId,(Case [Type... 阅读全文
posted @ 2015-12-29 15:58 ╰★张志峰★╮ 阅读(922) 评论(0) 推荐(0)
摘要：
-------------------------------------MyEclipse 快捷键1(CTRL)-------------------------------------Ctrl+1 快速修复Ctrl+D: 删除当前行Ctrl+Q 定位到最后编辑的地方Ctrl+L 定位在某行Ctr... 阅读全文
posted @ 2015-12-28 17:42 ╰★张志峰★╮ 阅读(175) 评论(0) 推荐(0)
摘要：
http://my.oschina.net/u/1383439/blog/224448http://blog.csdn.net/guihaijinfen/article/details/8363839 阅读全文
posted @ 2015-12-28 17:36 ╰★张志峰★╮ 阅读(164) 评论(0) 推荐(0)
摘要：
http://zhidao.baidu.com/link?url=9SVKBDXABmrEq04mUum_9iwb0B_UzX-8iPXAkS6fZRpuvsEkVMS_blnKiR0nTf_NKam6Hiv6pa1QM4x78l-Qc84605tDoTyLL6v04dfBP0S 阅读全文
posted @ 2015-12-26 22:17 ╰★张志峰★╮ 阅读(177) 评论(0) 推荐(0)
摘要：
IF OBJECT_ID ('ppSDetail_PPIn','TR') IS NOT NULL DROP TRIGGER ppSDetail_PPIn;GOCREATE TRIGGER ppSDetail_PPIn ON ppSDetailAFTER INSERTASDECLARE @iBil... 阅读全文
posted @ 2015-12-25 17:58 ╰★张志峰★╮ 阅读(183) 评论(0) 推荐(0)
myeclipse2015不能启动tomcat，提示： Several ports (8005, 8080, 8009) required by Tomcat v7.0 Server at local
摘要：
myeclipse2015不能启动tomcat，提示：Several ports (8005, 8080, 8009) required by Tomcat v7.0 Server at localhost are already in use.The server may already be r... 阅读全文
posted @ 2015-12-23 16:25 ╰★张志峰★╮ 阅读(23296) 评论(1) 推荐(1)
摘要：
@echo 开始注册copy dcc70.dll %windir%\system32\regsvr32 %windir%\system32\dcc70.dll /s@echo dcc70.dll注册成功@pause@echo 开始注册copy dcc70.dll %windir%\SysWOW64\... 阅读全文
posted @ 2015-12-21 16:32 ╰★张志峰★╮ 阅读(630) 评论(0) 推荐(0)
摘要：
2014-07-05 12:586445人阅读评论(1)收藏举报This Android SDK requires Android Developer Toolkit version23.0.0or above. Current version is 12.0.0.v201106281929-138... 阅读全文
posted @ 2015-12-17 14:38 ╰★张志峰★╮ 阅读(258) 评论(0) 推荐(0)
浙公网安备 33010602011771号