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

SQL Server2005¶Áȡע²á±í

SQL Server2005¶Áȡע²á±í
DECLARE @result varchar(255)
EXEC master.dbo.xp_regread 'HKEY_LOCAL_MACHINE','SOFTWARE\OperationControlSystem\ClientID','Prefix',@result OUT ---×¢Òâ±ØÐëÓÐOUT·ñÔò@resultΪ¿Õ
SELECT @result
¼ÙÈçÔÚÖ´Ðйý³ÌÖгöÏÖ´íÎ󣬿ÉÄÜÊÇδÕÒµ½´æ´¢¹ý³Ì_master.dbo.xp_regread
Ô­Òò£º×ö°²È«´¦ÀíµÄʱɾ³ýÁËxp_regread¡£
½â¾ö°ì·¨£º
ÖØÐ´´½¨»ØÈ¥¼´¿É£¬ÕÒµ½ Êý¾Ý¿â——master——À©Õ¹´æ´¢¹ý³Ì£¬ÓÒ¼ü“н¨À©Õ¹´æ´¢¹ý³Ì”
£¨Ãû³Æ£ºxp_regread£¬Â·¾¶£ºxpstar.dll£©±£´æ¼´¿É¡£


Ïà¹ØÎĵµ£º

SQL Server2000 ½âÎöXML

DECLARE @HDOC INT --Îĵµ¾ä±ú
DECLARE @XMLSTRING VARCHAR(200) --XML×Ö·û´®
SET @xmlString ='<?xml version="1.0"?>
<ROOT>
<USER ID="1" Name="SBQCEL"/>
<USER ID="2" Name="PEACELI"/>
<USER ID="3" Name="SHEEPCHANG"/>
</ROOT>'
--ʹÓÃϵͳ´æ´¢ ......

Sql Server ¶ÔxmlÀàÐ͵IJÙ×÷

 declare @XML XML
SET @XML='<root>
 <OLDVALUE>
  <H_Action id="1130">030</H_Action>
  <D_Action>030</D_Action>
  <OrderCompany>00220</OrderCompany>
  <OrderNumber>10004035</OrderNumber> ......

ÓÃSQLÈ¡²¿·Ö¼Ç¼

´Ótablename ±íÖÐÈ¡³öµÚ n Ìõµ½µÚ m ÌõµÄ¼Ç¼
SQL SERVERµÄд·¨
SELECT TOP m-n+1 *
from tablename
WHERE (id NOT IN
(SELECT TOP n-1 id from tablename))
ÄãÕâÊÇÒ»¸ö·ÖÒ³Ëã·¨µÄ£¬ÎÒÌṩµÄ±È½Ï¼òµ¥£¬ÍøÉÏ»¹Óкܶ಻´íµÄ£¬Èç¹ûÄã¶ÔÕâ¸ö²»ÂúÒ⣬ÔÙÈ¥ÍøÉÏÕÒÕÒ ¹Ø¼ü×Ö “·ÖÒ³Ëã·¨”
ORACLEµÄ»°¸ÄһϠ......

»¹Ô­SQLʧ°Ü

Êý¾Ý¿âÖ´ÐÐexec sp_renamedb 'oldname','newname'Óï¾ä£¬ÖØÃüÃûºó£¬½«Êý¾Ý¿â±¸·ÝÎļþ»¹Ô­Ê±£¬»á³öÏÖ´íÎó£¬Èçͼ
ÒòÊýÊý¾ÝÎļþÓëÊý¾Ý¿âÃû³Æ²»Ò»Ö¡£
½â¾ö·½·¨£º¿ÉÒÔÕÒµ½Êý¾ÝÎļþµÄÃû³Æ£¬½«Êý¾Ý¿â»¹Ô­Ãû³Æ¸úÊý¾Ý¿âÎļþÒ»ÖµÄÃû³Æ£¬´Ëʱ»¹Ô­³É¹¦ºó£¬ÔÙÐÞ¸ÄÊý¾Ý¿âµÄÃû³Æ¡£
×¢£ºÊý¾Ý¿âÖØÃüʱ£¬Ð轫SQL·þÎñÆ÷Í£Ö¹£¬ÖØÃüÃûºóÔÙÖØÐ ......

SQLÓï¾äµÄMINUS,INTERSECTºÍUNION ALL

SQLÓï¾äÖеÄÈý¸ö¹Ø¼ü×Ö:MINUS(¼õÈ¥),INTERSECT(½»¼¯)ºÍUNION ALL(²¢¼¯);
¹ØÓÚ¼¯ºÏµÄ¸ÅÄî,ÖÐѧ¶¼Ó¦¸Ãѧ¹ý,¾Í²»¶à˵ÁË.ÕâÈý¸ö¹Ø¼ü×ÖÖ÷ÒªÊǶÔÊý¾Ý¿âµÄ²éѯ½á¹û½øÐвÙ×÷,ÕýÈçÆäÖÐÎĺ¬ÒåÒ»Ñù:Á½¸ö²éѯ,MINUSÊÇ´ÓµÚÒ»¸ö²éѯ½á¹û¼õÈ¥µÚ¶þ¸ö²éѯ½á¹û,Èç¹ûÓÐÏཻ²¿·Ö¾Í¼õÈ¥Ïཻ²¿·Ö;·ñÔòºÍµÚÒ»¸ö²éѯ½á¹ûûÓÐÇø±ð. INTERSECTÊÇÁ½¸ö² ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ