这是注册:
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%'))