Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

ɾ³ýSQLServer²éѯ·ÖÎöÆ÷ÖеÄÁ¬½Ó¼Ç¼

SQLSERVER 2000
ÿ´Î´ò¿ªSQLServer²éѯ·ÖÎöÆ÷ºó£¬ÔÚÁ¬½Ó´°¿ÚÀïµÄSQLServer·þÎñÆ÷Ñ¡ÔñÏÂÀ­¿òºÍµÇ¼Óû§ÃûÊäÈë¿òÀï¶¼»áÁôÓÐÀúÊ·µÇ¼µÄ¼Ç¼£¬ÓÐʱºòÎÒÃÇÊDz»Ï£ÍûÕâÑùµÄ£¬±ÈÈçÔÚÒ»¸ö·Ç˽ÓÐÁìµØ×öÁËÔÝʱµÄ¿ª·¢ºó£¬²»ÏëÁôÏÂÈκÎÁ¬½ÓÔ¶³ÌÊý¾Ý¿âµÄ¼Ç¼£¬ÈçºÎɾ³ýÄØ£¿»¹ÊÇ×¢²á±í£¬ÕÒµ½ÒÔÏ·¾¶£º
HKEY_CURRENT_USER\Software\Microsoft\Microsoft  SQL  Server\80\Tools\Client\PrefServers
¶ÔÓÚ2005ϵÄstudioÈçºÎɾ³ý
ɾ³ýC:\Documents and Settings\{User}\Application Data\Microsoft\Microsoft SQL Server\90\Tools\ShellϵÄmru.dat


Ïà¹ØÎĵµ£º

sqlserverÓαêʹÓÃ

/***
ÓαêµÄʹÓÃ
½²ÁËÕâ¸ö¶àÓαêµÄÓŵ㣬ÏÖÔÚÎÒÃǾÍÇ××ÔÀ´½Ò¿ªÓαêµÄÉñÃØµÄÃæÉ´¡£
ʹÓÃÓαêµÄ˳Ðò£º ÉùÃûÓαꡢ´ò¿ªÓαꡢ¶ÁÈ¡Êý¾Ý¡¢¹Ø±ÕÓαꡢɾ³ýÓαꡣ
1.3.1ÉùÃ÷Óαê
×î¼òµ¥ÓαêÉùÃ÷£ºDECLARE <ÓαêÃû>CURSOR FOR<SELECTÓï¾ä>£»
ÆäÖÐselectÓï¾ä¿ÉÒÔÊǼòµ¥²éѯ£¬Ò²¿ÉÒÔÊǸ´ÔӵĽÓÁ¬²éѯºÍǶÌײéѯ
......

SQLServer´æ´¢¶àÓïÑÔÊý¾ÝµÄ¼¸ÖÖ·½·¨

SQLServer´æ´¢¶àÓïÑÔÊý¾ÝµÄ¼¸ÖÖ·½·¨
http://www.examda.com/ncre/three/db/fudao/20100111/102352311.html
±¾ÎĸÅÊöÁËÔÚÊý¾Ý¿âÉè¼ÆÖУ¬ÈçºÎ´¦Àí¶à¹úÓïÑÔµÄÎÊÌ⣬ÕâÀïµÄ¶à¹úÓïÑÔÊÇÖ¸ÖîÈçÕâÑùµÄÒµÎñ£ºÔÚERPÈí¼þÖУ¬ÎÒÃÇÔÚÌîд¿Í»§Ãû³ÆÊ±£¬³ýÁËÐèÒªÌîд¿Í»§µÄÖÐÎÄÃû³Æ£¬»¹ÐèÒªÌîдËûµÄÓ¢ÎÄÃû³Æ¡£ Ò»°ãµÄ£¬Èç¹ûÊÇÆÕͨµÄÏîÄ¿ÐÍ ......

SqlServer²Ù×÷XMLѧϰ


ÔÚ SQLServer2005 ÖжԠXML µÄ´¦Àí¹¦ÄÜÏÔÈ»ÔöÇ¿Á˺ܶ࣬ÌṩÁË query(),value(),exist(),modify(),nodes() µÈº¯Êý¡£
¹ØÓÚ xml £¬ÄÑÒÔÀí½âµÄ²»ÊÇ SQLServer ÌṩµÄº¯Êý£¬¶øÊǶԠxml ±¾ÉíµÄÀí½â£¬¿´Ëƺܼòµ¥µÄÎļþ¸ñʽ£¬´¦ÀíÆðÀ´È´ÊǷdz£À§Äѵġ£±¾ÎÄÖ»ÊdzõÌ ......

JAVA Á¬½Ó SQLServer 2000.

JAVA Á¬½Ó SQLServer 2000 ËùÐèÒªµÄÈý¸öJAR°ü¡£
http://download.csdn.net/source/2283940
----------------
Code:
------------------------
  Connection conn = null;
  Statement sta = null;
  try {
   Class.forName("com.microsoft.jdbc.sqlserver.SQLServer ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ