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; 菜单栏置顶固定位置