1.ԶؼԶϢ¼ίе.
2.Ajax
3.ģʽ,˽O/R Mappingܹ.
4.NETֲ㿪ͷֲʽϵṹ.
5.XML
6.ͨWEBSERVICE.
7.ģʽ.
8.htcxml/xslt 
9.дҵ߼.
realname.webbrowser.smartpv.cn

CREATE TRIGGER  usertj  ON [dbo].[contact] 
FOR INSERT
AS
declare @num int
set @num=(select count(*) from contact  where  custid=(select custid from inserted))
if @num<=1
update  tj set mbcust =(select mbcust from tj where  username=(select conman from inserted))+1 where username=(select conman from inserted)



CREATE TRIGGER  usertjj  ON [dbo].[contact]   
FOR INSERT
AS
declare @num int    
declare @num2 int

set @num=(select count(*) from contact  where  custid=(select custid from inserted))
if @num<=1
 begin
 
set @num2=(select count(*) from  deptj  where  dtime=(select contactdate from inserted))
if  @num2<>0
 begin
   insert into deptj(username,branch,dtime)  select  conman,belong,contactdate from inserted
end 
else
begin
update   deptj  set mbcust =(select mbcust from tj where  username=(select conman from inserted))+1 where username=(select conman from inserted)
end
end


