CREATE PROCEDURE finduser @username char(30)
AS
select * from userinfo where username=@username
update userinfo set u_look_num=u_look_num+1 where username=@username
GO
AS
select * from userinfo where username=@username
update userinfo set u_look_num=u_look_num+1 where username=@username
GO