SQL Server
文章平均质量分 71
sumeing
这个作者很懒,什么都没留下…
展开
-
删除数据库中重复数据的几个方法
<br /><br />方法一<br />declare @max integer,@id integer<br />declare cur_rows cursor local for select 主字段,count(*) from 表名 group by 主字段 having count(*) > 1<br />open cur_rows<br />fetch cur_rows into @id,@max<br />while @@fetch_status=0<br />begin<br />selec转载 2010-10-21 11:26:00 · 396 阅读 · 0 评论 -
常用金蝶表单查询
BillTypeIDFNameFTypeIDFTemplateIDFDataSqlFTableName1外购入库158SELECT * FROM vwStockBills WHERE FTranType=1ICStockBill2产品入库255SELECT * FROM vwStockBills WHERE FTranType=2ICStockBill5委外加工入库556SELECT * FROM vwStockBills WHERE FTranType=5ICStockBill7其他入库1057SELEC原创 2010-11-18 19:13:00 · 2431 阅读 · 0 评论 -
常用金蝶表单查询
BillTypeIDFNameFTypeIDFTemplateIDFDataSqlFTableName1外购入库158SELECT * FROM vwStockBills WHERE FTranType=1ICStockBill2产品入库255SELECT * FROM vwStockBills WHERE FTranType=2ICStockBill5委外加工入库556SELECT * FROM vwStockBills WHERE FTranType=5ICStockBill7其他入库1057SELEC原创 2010-11-18 19:13:00 · 2099 阅读 · 0 评论 -
采购限价触发器(K310.3)
create trigger [poorder_insert_01] on [dbo].[poorder]<br />for insert<br />as <br />declare @poorder_interid int <br />select @poorder_interid=finterid from inserted<br />if IF EXISTS ( SELECT 1 FROM poorder p1 inner join poorderentry p2 on <br />p1.finter原创 2010-11-18 19:11:00 · 873 阅读 · 0 评论 -
常用金蝶表单查询
BillTypeIDFNameFTypeIDFTemplateIDFDataSqlFTableName1外购入库158SELECT * FROM vwStockBills WHERE FTranType=1ICStockBill2产品入库255SELECT * FROM vwStockBills WHERE FTranType=2ICStockBill5委外加工入库556SELECT * FROM vwStockBills WHERE FTranType=5ICStockBill7其他入库1057SELEC原创 2010-11-18 19:13:00 · 2058 阅读 · 0 评论 -
向八张出入库老单据体中插入同一个字段k3
<br /> <br />/* 向八张出入库老单据体中插入/"销售合约'/"这个字段FEntryCode, 销售合约是核算项目,类别是3003 */ <br />Insert Into ICTemplateEntry(FID,FCtlIndex,FCtlOrder,FHeadCaption,FHeadCaption_CHT,FHeadCaption_EN,FCtlType,FLookUpCls,FNeedSave,FValueType,FSaveValue,FFieldName,FWidth,FEnable原创 2010-10-25 17:13:00 · 1246 阅读 · 0 评论 -
金蝶K3 10.3sp1应收款管理反结账代码
<br /><br />Update t_subsys set Fused = -1 , FPeriodSynch = 0 , FCheckout = 0 where Fsubsysid = 5 and Fyear= 2009 and Fperiod = 12;<br />Update t_RP_SystemProfile Set FValue = '12' Where FCategory = 'ARP' And FKey = 'FARCurPeriod';<br />Update t_RP_Syst原创 2010-10-25 17:11:00 · 3063 阅读 · 0 评论 -
存储过程_采购入库购货发票、费用发票跟踪表
<br /> <br /><br />CREATE PROCEDURE [FuRuiBuy]<br />@Bdate as datetime,<br />@Edate as datetime,<br />@SuppName as nvarchar(100), --客户名称<br />@EmpName as nvarchar(100), --业务员<br />@ItemName as nvarchar(100), -- 商品名称<br />@ZhangTao as nvarchar(100), --帐套0<b转载 2010-10-25 17:06:00 · 1694 阅读 · 0 评论 -
金蝶K3付款单代码
<br /> <br /><br />SELECT t_Currency3.FScale AS FCurrencyID_Decimal,t_currency4.FScale AS FReceiveCyID_Decimal,t_currency5.FScale AS FSettleCyID_Decimal,t_RP_NewReceiveBill.FMulCy,t_RP_NewReceiveBill.FNumber,t_RP_NewReceiveBill.FDate,<br />t_RP_NewReceiveB原创 2010-10-25 16:17:00 · 3568 阅读 · 0 评论 -
销售合同执行一览表-存储过程版
<br />转自:救火论坛<br /><br />CREATE PROCEDURE [MyContractSale] <br />@Bdate as datetime,<br />@Edate as datetime,<br />@CustName as nvarchar(100)<br />AS<br />功能:销售合同执行汇总表,一览方式查询<br />制作:救火<br />日期:2009-07-23<br />修改:<br />版本:0.0<br />set nocount off<br />sele转载 2010-10-25 16:01:00 · 2082 阅读 · 0 评论 -
采购合同执行跟踪表
<br /> <br /> <br />CREATE PROCEDURE [MyContractReport2] AS<br />/**合同跟踪表**/<br />set nocount on<br />Create Table #t_Phase(<br /> FPhaseName varchar(355), <br /> FTypeID int not null default(0)) <br />Insert into #t_Phase values('采购订单',1) <br />Insert原创 2010-10-25 16:00:00 · 3648 阅读 · 0 评论 -
转贴 :sql数据库置疑:Sql Server数据库置疑的解决
<br />sql数据库置疑:Sql Server数据库置疑的解决<br />办法<br /><br />原因:<br />通常这个问题是由于硬盘空间不够或硬盘读写错误造成的。<br />现象:<br />数据库后面有“置疑”字样,查看系统事务日记出现以下错误:<br />错误1---------------------------------------------<br />错误: 823,严重度: 24,状态: 2<br />I/O error 23(数据错误 (循环冗余检查)。) detected转载 2010-10-21 10:59:00 · 984 阅读 · 0 评论 -
常用SQL系统表
<br />常用SQL系统表 1、系统表 t_tabledescription<br />2、字段表 t_fielddescription<br />3、基础资料表(版本:10.3) t_item 其中fitemclassid值表示<br /> 1-客户;2-部门;3-职员;4-商品;5-仓位;7-单位;8-供应商。<br />部门 t_department;职员 t_emp;商品 t_icitem;仓库 t_stock;单位 t_measureunit<br />4、客户资料表 t_org原创 2010-11-23 09:01:00 · 2503 阅读 · 1 评论