- 博客(4)
- 收藏
- 关注
RSS订阅原创 金蝶恢复数据信息
declare record cursor for select name from sysobjects where name like ‘ICClassMCRecord%’ declare @tablename nvarchar(1000) declare @f nvarchar(2000) open record fetch from record into @tablename whil...
2019-08-07 15:02:51
380
原创 金蝶系统删除审核信息
eclare record cursor for select name from sysobjects where name like ‘ICClassMCRecord%’ declare @tablename nvarchar(1000) open record fetch from record into @tablename while @@fetch_status=0 begin if...
2019-08-07 15:02:01
232
原创 流水号-sql触发器
DECLARE @DATE VARCHAR(20) DECLARE @MAXORDER INT DECLARE @SN INT SELECT @DATE=SUBSTRING(CONVERT(VARCHAR(20),GETDATE(),112),1,6)–201611 SELECT @MAXORDER=MAX(CAST(SUBSTRING(RecordId,LEN(RecordId)-3,4) AS...
2019-08-07 15:00:28
155
原创 压缩代码记录
using System; using System.Collections.Generic; using System.Text; using System.IO; using ICSharpCode.SharpZipLib; using ICSharpCode.SharpZipLib.Zip; using ICSharpCode.SharpZipLib.Checksums; namespace...
2019-08-07 14:59:11
91
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人