?? ?-i
字號(hào):
IF EXISTS(SELECT NAME FROM SYSOBJECTS WHERE NAME='應(yīng)收發(fā)票_PROC' AND TYPE='P')
DROP PROC 應(yīng)收發(fā)票_PROC
GO
CREATE PROC 應(yīng)收發(fā)票_PROC
@CUST_TO VARCHAR(10),
@CUST_FR VARCHAR(10)
AS
CREATE TABLE [#銷售發(fā)票]
(
[銷售單號(hào)] [int] ,
[客戶碼] [varchar] (10),
[上次發(fā)票號(hào)] [varchar] (30) ,
[上次發(fā)票日期] [datetime],
[本次發(fā)票號(hào)] [varchar] (30),
[本次發(fā)票日期] [datetime],
[增值稅金額] [numeric](18, 6) DEFAULT (0) ,
[發(fā)票金額] [numeric](18, 6) DEFAULT (0) ,
[已分配發(fā)票金額] [numeric](18, 6) DEFAULT (0),
[已分配增值稅] [numeric](18, 6) DEFAULT (0),
[剩余發(fā)票金額] [numeric](18, 6) DEFAULT (0),
[剩余增值稅金額] [numeric](18, 6) DEFAULT (0))
INSERT INTO #銷售發(fā)票 SELECT* FROM 銷售發(fā)票
WHERE 客戶碼>=@CUST_TO AND 客戶碼<=@CUST_FR
SELECT *FROM #銷售發(fā)票
-- EXEC 應(yīng)收發(fā)票_PROC 'C01','C01'
?? 快捷鍵說明
復(fù)制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號(hào)
Ctrl + =
減小字號(hào)
Ctrl + -