触发器和存储过程

最新推荐文章于 2024-11-15 17:35:31 发布

wzhxj

最新推荐文章于 2024-11-15 17:35:31 发布

阅读量612

点赞数

分类专栏： SQL转帖文章标签：存储 insert email go delete float

本文链接：https://blog.youkuaiyun.com/wzhxj/article/details/564098

版权

SQL转帖专栏收录该内容

2 篇文章

订阅专栏

这是注册：
CREATE PROCEDURE zc_in_company
@id float(10),@loginName varchar(100),@Email varchar(100),@CoName varchar(100),@dqbm varchar(100),
@hybm varchar(100),@LawPerson varchar(100), @Telephone varchar(100),
@IBC varchar(100),@zclx varchar(100),@youj varchar(100)
AS
insert into companytable (id,loginName,Email,CoName,地区编码,行业编码,LawPerson, Telephone,IBC码,zclx,有奖注册) values (@id,@loginName,@Email,@CoName,@dqbm,@hybm,@LawPerson, @Telephone,@IBC,@zclx,@youj)
GO

CREATE PROCEDURE default6 @rq DateTime
AS
select 交易额 from 交易额表
where 日期=@rq
GO

CREATE PROCEDURE default7
AS
select count(*) as cc from ProductsTable
GO

触发器：
CREATE TRIGGER bzjs ON [dbo].[cfq]
FOR INSERT, UPDATE, DELETE
AS
UPDATE cfq
SET bz1 = (Select Count(*) FROM CompanyTable WHERE (行业编码 LIKE 'A%')),
bz2 = (Select Count(*) FROM CompanyTable WHERE (行业编码 LIKE 'B%'))