sqlserver»ñÈ¡µÚnÐÐÊý¾Ý
ÈçºÎÔÚÒ»¸öûÓÐÖ÷¼üµÄ±íÖлñÈ¡µÚnÐÐÊý¾Ý£¬ÔÚsql2005ÖпÉÒÔÓÃrow_number£¬µ«ÊDZØÐëÖ¸¶¨ÅÅÐòÁУ¬·ñÔòÄã¾Í²»µÃ²»ÓÃselect intoÀ´¹ý¶Éµ½ÁÙʱ±í²¢Ôö¼ÓÒ»¸öÅÅÐò×ֶΡ£
ÓÃÓαêµÄfetch absoluteÓï¾ä¿ÉÒÔ»ñÈ¡¾ø¶ÔÐÐÊýϵÄijÐÐÊý¾Ý,²âÊÔ´úÂëÈçÏÂ:
set nocount on
--½¨Á¢²âÊÔ»·¾³²¢²åÈëÊý¾Ý£¬²¢ÇÒ±íûÓÐÖ÷¼ü
create table test(id int ,name varchar(10))
insert into test select 999,'jinjazz'
insert into test select 888,'csdn'
insert into test select 999,'sqlserver'
--ͨ¹ýÓαê»ñÈ¡¾ø¶ÔÐÐÊý
declare myCursor scroll cursor for select * from test
open myCursor
fetch absolute 3 from myCursor
close myCursor
deallocate myCursor
--ɾ³ý²âÊÔ»·¾³
drop table test
set nocount off
/*--
id name
----------- ----------
999 sqlserver
--*/
Ïà¹ØÎĵµ£º
ÉÏһƪ·ÖÒ³ÎÄÕ£¬ÊÇÓÃÓÚmysql£¬ÉÔ΢ÐÞ¸ÄÏ£¬ÓÃÓÚSqlserver2005/2008£¬Ã»ÓÐÒì³£´¦Àí¡£Ã»Óп¼ÂÇÐÔÄܵȡ£
ÏÖ½«´úÂëÌù³ö£¬ÒÔ¹©³õѧÕ߲ο¼£º
×¢£ºÑûÔÂʹÓû·¾³Eclipse 3.4.2+Tomcat 6.18+Sqlserver2005 sp3µ÷ÊԳɹ¦¡£
Ò³ÃæpagelistDemo.jspÄÚÈÝ£º
Code
<%@ page language="java" contentType="text/html; ......
Ò»¡¢AccessÓëSqlServerÊý¾ÝÀàÐÍ±È½Ï Microsoft Access Êý¾ÝÀàÐÍ SQL Server Êý¾ÝÀàÐÍ ÊÇ/·ñ£¬£¨0ºÍ-1£©
1 룬²»ÔÊÐíÓÐ Null Öµ¡£ bit(1¡¢0 »ò NULL) Êý×Ö£¨×Ö½Ú£©£ ......
¡¡¡¡ÊÂʵ±í
¡¡¡¡Ã¿¸öÊý¾Ý²Ö¿â¶¼°üº¬Ò»¸ö»òÕß¶à¸öÊÂʵÊý¾Ý±í¡£ÊÂʵÊý¾Ý±í¿ÉÄܰüº¬ÒµÎñÏúÊÛÊý¾Ý£¬ÈçÏÖ½ðµÇ¼ÇÊÂÎñ
¡¡¡¡Ëù²úÉúµÄÊý¾Ý£¬ÊÂʵÊý¾Ý±íͨ³£°üº¬´óÁ¿µÄÐС£ÊÂʵÊý¾Ý±íµÄÖ÷ÒªÌØµãÊǰüº¬Êý×ÖÊý¾Ý(ÊÂʵ)£¬²¢ÇÒÕâЩÊý×ÖÐÅÏ¢¿ÉÒÔ»ã×Ü£¬ÒÔÌṩÓйص¥Î»×÷ΪÀúÊ·µÄÊý¾Ý£¬Ã¿¸öÊÂʵÊý¾Ý±í°üº¬Ò»¸öÓɶà¸ö²¿·Ö×é³ÉµÄË÷Òý£¬¸ÃË÷Òý ......
SQLÓï¾äÈçÏÂ:
CREATE TABLE [dbo].[test_table] (
[ID] [int] IDENTITY (1, 1) NOT NULL ,
[NAME] [varchar] (80)
)
Éè¼ÆÊÓͼÏÂ,ÔÚÌí¼ÓÒ»¸öINTÐ͵Ä×Ö¶ÎÊÇ,Ñ¡ÖÐÏ·½µÄ"±êʶ"Ϊ"ÊÇ",ÏÂÃæÓÐ"±êʶÖÖ×Ó"ºÍ"±êʶ×ÔÔöÁ¿",¿ÉÒÔ×Ô¼ºÉèÖÃ,ĬÈ϶¼Îª1
µ«ÊDz»ÖªµÀΪʲô,ʹÓÃÈÎÎ ......
SQLServerÖÐÓÐÁ½¸öÀ©Õ¹´æ´¢¹ý³ÌʵÏÖScanfºÍPrintf¹¦ÄÜ£¬Ç¡µ±µÄʹÓÃËüÃÇ¿ÉÒÔÔÚÌáÈ¡ºÍÆ´½Ó×Ö·û´®Ê±´ó·ù¶È¼ò»¯SQL´úÂë¡£
1¡¢xp_sscanf£¬ÓÃËü¿ÉÒÔ·Ö½â¸ñʽÏà¶Ô¹Ì¶¨µÄ×Ö·û´®£¬Õâ¶ÔÓÚÑá¾ëʹÓÃÒ»¶ÑsubstringºÍcharindexµÄÅóÓÑÀ´Ëµ²»´í¡£±ÈÈçǰ¼¸ÌìµÄÒ»¸öÌû×ÓÖÐÌá³öµÄÈçºÎ·Ö½âipµØÖ·£¬Ïà¶Ô¼òÁ·ÇÒͨÓõĴúÂëÓ¦¸ÃÊÇÏÂÃæÕâÑù
------- ......