?? 應(yīng)收賬明細(xì)_客戶_proc.sql
字號:
IF EXISTS(SELECT NAME FROM SYSOBJECTS WHERE NAME='應(yīng)收賬明細(xì)_客戶_PROC' AND TYPE='P')
DROP PROC 應(yīng)收賬明細(xì)_客戶_PROC
GO
create PROC 應(yīng)收賬明細(xì)_客戶_PROC
@CUST_TO varchar(10),
@CUST_FR varchar(10)
AS
CREATE TABLE [#應(yīng)收賬款明細(xì)賬] (
[客戶編碼] [varchar] (10) ,
[銷售單] [int] ,
[貨幣] [varchar] (10) ,
[憑證號] [int],
[發(fā)票號碼] [varchar] (20) ,
[發(fā)票日期] [datetime] ,
[借方金額] [numeric](18, 6),
[貸方金額] [numeric](18, 6),
[余額] [numeric](18, 6))
INSERT INTO #應(yīng)收賬款明細(xì)賬 SELECT* FROM 應(yīng)收賬款明細(xì)賬
WHERE 客戶編碼>=@CUST_TO AND 客戶編碼<=@CUST_FR
SELECT *FROM #應(yīng)收賬款明細(xì)賬
?? 快捷鍵說明
復(fù)制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -