SQL ServerÊÓͼʹÓÃ
ÊÓͼ¿ÉÒÔ±»¿´³ÉÊÇÐéÄâ±í»ò´æ´¢²éѯ¡£¿Éͨ¹ýÊÓͼ·ÃÎʵÄÊý¾Ý²»×÷Ϊ¶ÀÌصĶÔÏó´æ´¢ÔÚÊý¾Ý¿âÄÚ¡£Êý¾Ý¿âÄÚ´æ´¢µÄÊÇ SELECT Óï¾ä¡£SELECT Óï¾äµÄ½á¹û¼¯¹¹³ÉÊÓͼËù·µ»ØµÄÐéÄâ±í¡£Óû§¿ÉÒÔÓÃÒýÓñíʱËùʹÓõķ½·¨£¬ÔÚ Transact-SQL Óï¾äÖÐͨ¹ýÒýÓÃÊÓͼÃû³ÆÀ´Ê¹ÓÃÐéÄâ±í¡£Ê¹ÓÃÊÓͼ¿ÉÒÔʵÏÖÏÂÁÐÈÎÒ»»òËùÓй¦ÄÜ£º
¡¡¡¡½«Óû§ÏÞ¶¨ÔÚ±íÖеÄÌض¨ÐÐÉÏ¡£
¡¡¡¡ÀýÈ磬ֻÔÊÐí¹ÍÔ±¿´¼û¹¤×÷¸ú×Ù±íÄڼǼÆ乤×÷µÄÐС£
¡¡¡¡½«Óû§ÏÞ¶¨ÔÚÌض¨ÁÐÉÏ¡£
¡¡¡¡ÀýÈ磬¶ÔÓÚÄÇЩ²»¸ºÔð´¦Àí¹¤×ʵ¥µÄ¹ÍÔ±£¬Ö»ÔÊÐíËûÃÇ¿´¼û¹ÍÔ±±íÖеÄÐÕÃûÁС¢°ì¹«ÊÒÁС¢¹¤×÷µç»°ÁкͲ¿ÃÅÁУ¬¶ø²»ÄÜ¿´¼ûÈκΰüº¬¹¤×ÊÐÅÏ¢»ò¸öÈËÐÅÏ¢µÄÁС£
¡¡¡¡½«¶à¸ö±íÖеÄÁÐÁª½ÓÆðÀ´£¬Ê¹ËüÃÇ¿´ÆðÀ´ÏóÒ»¸ö±í¡£
¡¡¡¡¾ÛºÏÐÅÏ¢¶ø·ÇÌṩÏêϸÐÅÏ¢¡£
¡¡¡¡ÀýÈ磬ÏÔʾһ¸öÁеĺͣ¬»òÁеÄ×î´óÖµºÍ×îСֵ¡£
¡¡¡¡Í¨¹ý¶¨Òå SELECT Óï¾äÒÔ¼ìË÷½«ÔÚÊÓͼÖÐÏÔʾµÄÊý¾ÝÀ´´´½¨ÊÓͼ¡£SELECT Óï¾äÒýÓõÄÊý¾Ý±í³ÆΪÊÓͼµÄ»ù±í¡£ÔÚÏÂÀýÖУ¬pubs Êý¾Ý¿âÖÐµÄ titleview ÊÇÒ»¸öÊÓͼ£¬¸ÃÊÓͼѡÔñÈý¸ö»ù±íÖеÄÊý¾ÝÀ´ÏÔʾ°üº¬³£ÓÃÊý¾ÝµÄÐéÄâ±í£º
CREATE VIEW titleview
AS
SELECT title, au_ord, au_lname, price, ytd_sales, pub_id
from authors AS a
JOIN titleauthor AS ta ON (a.au_id = ta.au_id)
JOIN titles AS t ON (t.title_id = ta.title_id)
Ö®ºó£¬¿ÉÒÔÓÃÒýÓñíʱËùʹÓõķ½·¨ÔÚÓï¾äÖÐÒýÓà titleview¡£
SELECT * from titleview
¡¡¡¡Ò»¸öÊÓͼ¿ÉÒÔÒýÓÃÁíÒ»¸öÊÓͼ¡£ÀýÈ磬titleview ÏÔʾµÄÐÅÏ¢¶Ô¹ÜÀíÈËÔ±ºÜÓÐÓ㬵«¹«Ë¾Í¨³£Ö»ÔÚ¼¾¶È»òÄê¶È²ÆÎñ±¨±íÖвŹ«²¼±¾Äê¶È½ØÖ¹µ½ÏÖÔڵIJÆÕþÊý×Ö¡£¿ÉÒÔ½¨Á¢Ò»¸öÊÓͼ£¬ÔÚÆäÖаüº¬³ý au_ord ºÍ ytd_sales ÍâµÄËùÓÐ titleview ÁС£Ê¹ÓÃÕâ¸öÐÂÊÓͼ£¬¿Í»§¿ÉÒÔ»ñµÃÒÑÉÏÊеÄÊé¼®Áбí¶ø²»»á¿´µ½²ÆÎñÐÅÏ¢£º
CREATE VIEW Cust_titleview
AS
SELECT title, au_lname, price, pub_id
from titleview
¡¡¡¡ÊÓͼ¿ÉÓÃÓÚÔÚ¶à¸öÊý¾Ý¿â»ò Microsoft? SQL Server? 2000 ʵÀý¼ä¶ÔÊý¾Ý½øÐзÖÇø¡£·ÖÇøÊÓͼ¿ÉÓÃÓÚÔÚÕû¸ö·þÎñÆ÷×éÄÚ·Ö²¼Êý¾Ý¿â´¦Àí¡£·þÎñÆ÷×é¾ßÓÐÓë·þÎñÆ÷¾Û¼¯ÏàͬµÄÐÔÄÜÓŵ㣬²¢¿ÉÓÃÓÚÖ§³Ö×î´óµÄ Web Õ¾µã»ò¹«Ë¾Êý¾ÝÖÐÐĵĴ¦ÀíÐèÇó¡£Ôʼ±í±»Ï¸·ÖΪ¶à¸ö³ÉÔ±±í£¬Ã¿¸ö³ÉÔ±±í°üº¬Ôʼ±íµÄÐÐ×Ó¼¯¡£Ã¿¸ö³ÉÔ±±í¿É·ÅÖÃÔÚ²»Í¬·þÎñÆ÷µÄÊý¾Ý¿âÖС£Ã¿¸ö·þÎñÆ÷Ò²¿ÉµÃµ½·ÖÇøÊÓͼ¡£·ÖÇøÊÓͼʹÓà Transact-SQL UNION ÔËËã·û£¬½«ÔÚËùÓгÉÔ±±íÉÏÑ¡ÔñµÄ½á¹ûºÏ²¢Îªµ¥¸ö½á¹û¼¯£¬¸Ã½á¹û¼¯µÄÐÐΪÓëÕû¸öÔʼ
Ïà¹ØÎĵµ£º
create PROCEDURE pagelist
@tablename nvarchar(50),
@fieldname nvarchar(50)='*',
@pagesize int output,--ÿҳÏÔʾ¼Ç¼ÌõÊý
@currentpage int output,--µÚ¼¸Ò³
@orderid nvarchar(50),--Ö÷¼üÅÅÐò
@sort int,--ÅÅÐò·½Ê½£¬1±íʾÉýÐò£¬0±íʾ½µÐòÅÅÁÐ
......
×î½üÔÚºÍÒ»¸ö¹«Ë¾ºÏ×÷ÏîÄ¿£¬Óв¿·ÖÁ´½ÓÊÇÓÉËûÃǹ«Ë¾ÌṩµÄ£¬ÓÉÓÚµ±Ê±»¹Ã»ÓÐÉêÇëÓòÃû£¬Ö±½ÓÌṩ¸øÎÒÃǵÄÊÇipµØÖ·£¬ÏÖÔÚÕýʽÉÏÏߺó£¬ÐèÒªÎÒÃǽ«ÔÀ´µÄipµØÖ·Ì滻ΪÓòÃû£¬Èç¹ûÒ»¸ö¸öÌæ»»ÆðÀ´ÌرðÂé·³£¬¶øÇÒ¿ÉÄܳöÏÖÎÊÌ⣬Òò´ËÕÒÁËÏÂoracleÖÐsqlÅúÁ¿Ìæ»»µÄ¹¦ÄÜ£¬Ê¹ÓÃÆðÀ´Ì«·½±ãÁË£¬ÔÚÕâÀï¼Ç¼Ï£¬±ãÓÚÒÔºó²éÕÒ¡£¾ßÌåʹÓÃ˵Ã÷ÈçÏ ......
3¡£±íÄÚÈÝÈçÏÂ
¡¡¡¡-----------------------------
¡¡¡¡ID LogTime
¡¡¡¡1 2008/10/10 10:00:00
¡¡¡¡1 2008/10/10 10:03:00
¡¡¡¡1 2008/10/10 10:09:00
¡¡¡¡2 2008/10/10 10:10:00
¡¡¡¡2 2008/10/10 10:11:00
¡¡¡¡......
¡¡¡¡-----------------------------
¡¡¡¡ÇëÎʸ÷λ¸ßÊÖ£¬ÈçºÎ²éѯµÇ½ʱ¼ä¼ä¸ô²»³¬ ......
ºÍÊý¾Ý¿â´ò½»µÀҪƵ·±µØÓõ½SQLÓï¾ä£¬³ý·ÇÄãÊÇÈ«²¿Óÿؼþ°ó¶¨µÄ·½Ê½£¬µ«²ÉÓÿؼþ°ó¶¨µÄ·½Ê½´æÔÚ×ÅÁé»îÐԲЧÂʵ͡¢¹¦ÄÜÈõµÈµÈȱµã¡£Òò´Ë£¬´ó¶àÊýµÄ³ÌÐòÔ±¼«ÉÙ»ò½ÏÉÙÓÃÕâÖְ󶨵ķ½Ê½¡£¶ø²ÉÓ÷ǰ󶨷½Ê½Ê±Ðí¶à³ÌÐòÔ±´ó¶¼ºöÂÔÁ˶Ե¥ÒýºÅµÄÌØÊâ´¦Àí£¬Ò»µ©SQLÓï¾äµÄ²éѯÌõ¼þµÄ±äÁ¿Óе¥ÒýºÅ³öÏÖ£¬Êý¾Ý¿âÒýÇæ¾Í»á±¨´íÖ¸³öSQLÓ ......
package cn.com.hbivt.util;
/**
* <p>Title: </p>
*
* <p>Description: </p>
*
* <p>Copyright: Copyright (c) 2005</p>
*
* <p>Company: </p>
*
* @author not attributable
* @version 1.0
*/
public class StringUtils {
//¹ýÂËͨ¹ýÒ³Ãæ±íµ¥Ìá½» ......