摘要： set ANSI_NULLS ONset QUOTED_IDENTIFIER ONgo--[QN_FAVBOOKS_LIST] 5,'5,',''-- =============================================-- Author: <shixiaokang>-- Create date: <2010-8-20>-- Description: <收藏夹详情>-- =============================================ALTER proc [dbo].[QN_FA 阅读全文

摘要： set ANSI_NULLS ONset QUOTED_IDENTIFIER ONgo -- ============================================= -- Author: <Author,,Name> -- Create date: <Create Date,,> -- Description: <Description,,> --QN_GOODS_ADJUST_LIST 1,'grsssss',',15,1,'-- ===================================== 阅读全文

摘要： alter proc songhaitao @UserID varchar(100),@Items varhcar(2000),@OpCode int,@Root=''as begin set nocount on declare @hdoc varchar(1000) declare @ret int declare @retmsg varchar(2000) exec @ret=sp_xml_preparedocument @hdoc output,@Root if @ret!=1 begin set @ret=-1234 set @retmsg='读取 xml文件 阅读全文

摘要： update BDO_GOODSCLASS set SpellCode =(select 药学分类编码from BDO_GOODSCLASS_TEMP b where b.药学分类ID=BDO_GOODSCLASS.ClassID)from BDO_GOODSCLASS 阅读全文