这是注册：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)ASinsert 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 ASselect 交易额 from 交易额表where 日期=@rqGO
CREATE PROCEDURE default7ASselect count(*) as cc from ProductsTableGO
触发器：CREATE TRIGGER bzjs ON [dbo].[cfq] FOR INSERT, UPDATE, DELETEASUPDATE cfqSET bz1 = (Select Count(*) FROM CompanyTable WHERE (行业编码 LIKE 'A%')),bz2 = (Select Count(*) FROM CompanyTable WHERE (行业编码 LIKE 'B%'))
