05 2016 档案

• 简单触发器
  摘要：create trigger triggerStudent on Student after insert as declare @ID int; select @ID=classID from inserted update class set num=num+1 where ID=@ID 阅读全文
  posted @ 2016-05-25 21:00 sccmfx
• sql分页
  摘要：declare @sizePage int=3 declare @currentPage int=2 select top 3 * from ( select ROW_NUMBER() over(order by ID asc) as RowNumber ,*from Product) as tem 阅读全文
  posted @ 2016-05-24 21:36 sccmfx 阅读(134) 评论(0) 推荐(0)