sqlserver·ÖÒ³
ÏÖÔÚÒ»°ã³£ÓõÄÓÐÒÔÏÂ2ÖÖ·½·¨:
1. select top @pagesize * from table1 where id not in (select top @pagesize*(@page-1) id from table1 order by id) order by id
2. select * from (select top @pagesize * from (select top @pagesize*@page * from table1 order by id) a order by id desc) b order by id
Ïà¹ØÎĵµ£º
18¾ä»°ÈëÃÅSQLServer XML ÊÕ²Ø
/*
sql xml ÈëÃÅ:
--by jinjazz
--http://blog.csdn.net/jinjazz
1¡¢xml: ÄÜÈÏÊ¶ÔªËØ¡¢ÊôÐÔºÍÖµ
2¡¢xpath: ......
SQL-Structured Query Language
--(¿ªÆôSQL·þÎñ£ºnet start mssqlserver)
--(ÔÚÃüÁîÐÐÖÐÊäÈë'sqlwb'ÃüÁî¿É´ò¿ªSQL¹ÜÀíÆ÷ )
--(Èç¹ûÒªÖ´ÐжàÌõÃüÁîÖеÄÒ»Ìõ,Êó±êÑ¡¶¨ºóÔÙ°´F5Ö´ÐÐ)
create database sales --´´½¨Ò»¸öÃûΪsalesµÄÊý¾Ý¿â
on
(
name='sales_dat ......
Ò»¡¢SQLServer ͨÓÃË÷Òý×Ö¶Î
1¡¢Primary Key's Ö÷¼ü
2¡¢Foreign Key's Íâ¼ü
3¡¢Ö§³ÖSELECT¡¢INSERT¡¢UPDATEºÍDELETEÃüÁîµÄ×Ö¶Î :
(1)¡¢INNER JOIN
(£²)¡¢RIGHT | LEFT OUTER JOIN
(£³)¡¢WHERE
(£´)¡¢ORDER BY
(£µ)¡¢GROUP BY
(£¶)¡¢HAVING
¶þ¡¢´´½¨Ë÷ÒýµÄÆäËûÒòËØ(Ö÷ÒªÒòËØ¶¼ÒòΪË÷ÒýÊÇÊý¾Ý±íÍⲿ ......
using System;
using System.Collections;
using System.Configuration;
using System.Data;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Data.SqlClient; ......
1.¾ø¶ÔÖµ
S:select abs(-1) value
O:select abs(-1) value from dual
2.È¡Õû(´ó)
S:select ceiling(-1.001) value
O:select ceil(-1.001) value from dual
3.È¡Õû£¨Ð¡£©
S:select floor(-1.001) value
O:select floor(-1.001) value from dual
4.È ......