1.返回 刚插入数据的Id id为自增的,不是自增也不用查
 ①。INSERT INTO 表(字段名...) VALUES (...) SET NOCOUNT OFF SELECT id=@@IDENTITY
 ②。create table gr_sendmessage(mobile char(11),message varchar(100),createtime datetime)
     create table gr_sendmessage_bak(mobile char(11),message varchar(100))
     --创建触发器messageinsert
     create trigger messageinsert
     on gr_sendmessage
     for insert
     as
     begin
      insert into gr_sendmessage_bak(mobile,message)
      select inserted.mobile,inserted.message from inserted
    end
   --插入数据测试
   insert into gr_sendmessage values('13305931245','测试信息',getdate())
2.查询 某个字段【左/右】起 N个字符一样的数据
  select * from Table where convert(varchar,left(loginname,N))='aaaaa'
  select * from Table where convert(varchar,left(loginname,N))='aaaaa'
3.去掉网页左右滚动条
   overflow-x:hidden;
  菜单栏置顶固定位置