寻找被遗忘的记忆

<br /> <br />/****<br />  单据去号之用。@sCharater表示单据号码的特性编号，@sBranchNo代表机构编号，  @sFunc_Name为该作业显示的名称，<br />  @sSheet_No为返回的单据号码。<br />  本过程系以xt_bmqh为单据号码的中心,以此找出符合条件的作大数号码加一或取新的从一开始的单号.<br />****/<br />CREATE procedure spGet_Sheet_No(<br />@sCharater VarChar(5),

<br />/*********************************************************************<br />  InstallSqlState.SQL                                                <br />                                                                    <br />  Installs the tables, an

<br />/*********************************************************************<br />  InstallSqlState.SQL                                                <br />                                                                    <br />  Installs the tables, an

<br />/*********************************************************************<br />  InstallSqlState.SQL                                                <br />                                                                    <br />  Installs the tables, an

<br />CREATE   PROC  proc_sale_beihuo  <br />   @sheet_no varchar(20)  <br />as  <br />  <br />set nocount on  <br />  <br />CREATE TABLE #tmp_sale (ID int IDENTITY(1,1) NOT NULL,客户货号 varchar(50),客户货号名 varchar(100),恒立货号 varchar(100),恒立名称 varchar(100),  <br

CREATE PROC GetPage       (         @sheetno  varchar(14),       @indexPage int ,       @pagesize int ,       @numberCount numeric(9,0) output ,       @itemno varchar(10)      )       AS       begin          DECLARE @culomns varchar(8000)          select  

<br />SELECT kp_order_number, kp_codeand_color AS kp_item_code , kp_yltype_name  AS '类别' ,kp_item_name as '名称' ,kp_item_size as '规格' ,kp_color as '颜色', kp_unit_no as '单位',kp_waster as '损耗',kp_waster_qty          <br />into #t FROM jb_fw_detail a ,jb_bagylt

<br /> <br /><br /><br />select   convert(char(10),dateadd(d,-1,convert(char(7),dateadd(m,1,getdate()),120)+'-01'),120)

<br />SELECT kp_item_no FROM pf_dj_detail b  <br /> WHERE  NOT EXISTS(SELECT 1 FROM jb_spzl a WHERE a.kp_item_no=b.kp_item_no)

<br />CREATE PROCEDURE proc_sale_branch_month  <br />(  <br />@startdate datetime,  <br />@enddate datetime,  <br />@branch_no varchar(6)  <br />)  <br /> AS  <br />declare @sumAmount numeric(16,6)  <br />set @sumAmount=<br />(select sum(case kp_trans_no w

<br />CREATE PROCEDURE AspNetPager  <br />(  <br /> @TableName  nvarchar(50),   -- 表名  <br /> @ReturnFields nvarchar(2000) = '*', -- 需要返回的列