随笔分类 -  数据库

摘要：<%@ Page Language="C#" %><%@ import Namespace="System.Data" %><%@ import Namespace="System.Data.SqlClient" %><script runat="server">protected void Page_Load(Object sender, EventArgs e){int intPageNo,intPageSize,intPageCount;intPageSize 阅读全文

摘要：create proc Page(@PageIndex int)as declare @page intdeclare @sql varchar(1000)set @page=@PageIndex*5set @sql='select top 5 Brand.BrandID,Brand.BrandName,Brand.HtmlUrl,Brand.TypeID,Brand.LogoUrl2,Brand_Type.BrandTypeNamefrom Brand,Brand_Type where convert(int,substring(Brand.TypeID,2,1))=Brand_Ty 阅读全文