sql 如何声明变量?
来源:百度知道 编辑:UC知道 时间:2024/06/24 06:09:34
/*从一个账套中的存货档案触发到其他账套,减少重复录入的工作;*/
use ufdata_025_2009
if exists (select * from dbo.sysobjects
where id = object_id(N'[dbo].[Addinventory]') and OBJECTPROPERTY(id, N'IsTrigger') = 1)
drop trigger [dbo].[Addinventory]
GO
if exists (select * from dbo.sysobjects
where id = object_id(N'[dbo].[Delinventory]') and OBJECTPROPERTY(id, N'IsTrigger') = 1)
drop trigger [dbo].[Delinventory]
GO
--编码,代码,分类码,名称,规格,生产用,在制,外购,销售,自制,单位组,付计量,
CREATE TRIGGER Addinventory On Inventory
For Insert
As
Begin
Declare @cInvCode varchar(20),@cInvAddCode varchar(30),@cInvCCode varchar(12),@cInvName
varchar(60),@cInvStd varchar(60),@bComsume bit,
@bProducing bit,@bPurchase bit,@bSale bit,@bSelf bit,@cGroupCode
varchar(10),@cAssComUnitCode varchar(10),@cComUnitCode varchar(10),@dSDate Datetime
Select
@cInvCode=cInvCode,@cInvAddCode=cInvAddCode,@cInvCCode=cInvCCode,
use ufdata_025_2009
if exists (select * from dbo.sysobjects
where id = object_id(N'[dbo].[Addinventory]') and OBJECTPROPERTY(id, N'IsTrigger') = 1)
drop trigger [dbo].[Addinventory]
GO
if exists (select * from dbo.sysobjects
where id = object_id(N'[dbo].[Delinventory]') and OBJECTPROPERTY(id, N'IsTrigger') = 1)
drop trigger [dbo].[Delinventory]
GO
--编码,代码,分类码,名称,规格,生产用,在制,外购,销售,自制,单位组,付计量,
CREATE TRIGGER Addinventory On Inventory
For Insert
As
Begin
Declare @cInvCode varchar(20),@cInvAddCode varchar(30),@cInvCCode varchar(12),@cInvName
varchar(60),@cInvStd varchar(60),@bComsume bit,
@bProducing bit,@bPurchase bit,@bSale bit,@bSelf bit,@cGroupCode
varchar(10),@cAssComUnitCode varchar(10),@cComUnitCode varchar(10),@dSDate Datetime
Select
@cInvCode=cInvCode,@cInvAddCode=cInvAddCode,@cInvCCode=cInvCCode,
@bComsume=bComsume,@bProducing=bProducing,@bPurchase=bPurchase,@bSale=bSale,@bSelf=bSelf,@cG
roupCode=cGroupCode,
(@cInvCode,@cInvAddCode,@cInvCCode,@cInvName,@cInvStd,@bComsume,@bProducing,@bPurchase,@bSal
e,@bSelf,@cGroupCode,
你自己多了两个回车
复制来的程序,自己也要看看吧?
declare @cG 数据类型(数据长度)----长度只是字符数据要用到
刚再仔细看了下
都没这两个变量
@bPurchase,@bSal----这里错了 怎么变量名分家
e,@bSelf,@cGroupCode,
,@bSelf=bSelf,@cG----这里错了 怎么变量名分家
roupCode=cGroupCode
把这里错了的中间空格回车全部去掉就正确了!
DECLARE @cG 变量类型
DECLARE @bSal 变量类型