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£©±£´æ¼´¿É¡£
Ïà¹ØÎĵµ£º
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>'
--ʹÓÃϵͳ´æ´¢ ......
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> ......
´Ótablename ±íÖÐÈ¡³öµÚ n Ìõµ½µÚ m ÌõµÄ¼Ç¼
SQL SERVERµÄд·¨
SELECT TOP m-n+1 *
from tablename
WHERE (id NOT IN
(SELECT TOP n-1 id from tablename))
ÄãÕâÊÇÒ»¸ö·ÖÒ³Ëã·¨µÄ£¬ÎÒÌṩµÄ±È½Ï¼òµ¥£¬ÍøÉÏ»¹Óкܶ಻´íµÄ£¬Èç¹ûÄã¶ÔÕâ¸ö²»ÂúÒ⣬ÔÙÈ¥ÍøÉÏÕÒÕÒ ¹Ø¼ü×Ö “·ÖÒ³Ëã·¨”
ORACLEµÄ»°¸ÄһϠ......
Êý¾Ý¿âÖ´ÐÐexec sp_renamedb 'oldname','newname'Óï¾ä£¬ÖØÃüÃûºó£¬½«Êý¾Ý¿â±¸·ÝÎļþ»¹Ôʱ£¬»á³öÏÖ´íÎó£¬Èçͼ
ÒòÊýÊý¾ÝÎļþÓëÊý¾Ý¿âÃû³Æ²»Ò»Ö¡£
½â¾ö·½·¨£º¿ÉÒÔÕÒµ½Êý¾ÝÎļþµÄÃû³Æ£¬½«Êý¾Ý¿â»¹ÔÃû³Æ¸úÊý¾Ý¿âÎļþÒ»ÖµÄÃû³Æ£¬´Ëʱ»¹Ô³É¹¦ºó£¬ÔÙÐÞ¸ÄÊý¾Ý¿âµÄÃû³Æ¡£
×¢£ºÊý¾Ý¿âÖØÃüʱ£¬Ð轫SQL·þÎñÆ÷Í£Ö¹£¬ÖØÃüÃûºóÔÙÖØÐ ......
SQLÓï¾äÖеÄÈý¸ö¹Ø¼ü×Ö:MINUS(¼õÈ¥),INTERSECT(½»¼¯)ºÍUNION ALL(²¢¼¯);
¹ØÓÚ¼¯ºÏµÄ¸ÅÄî,ÖÐѧ¶¼Ó¦¸Ãѧ¹ý,¾Í²»¶à˵ÁË.ÕâÈý¸ö¹Ø¼ü×ÖÖ÷ÒªÊǶÔÊý¾Ý¿âµÄ²éѯ½á¹û½øÐвÙ×÷,ÕýÈçÆäÖÐÎĺ¬ÒåÒ»Ñù:Á½¸ö²éѯ,MINUSÊÇ´ÓµÚÒ»¸ö²éѯ½á¹û¼õÈ¥µÚ¶þ¸ö²éѯ½á¹û,Èç¹ûÓÐÏཻ²¿·Ö¾Í¼õÈ¥Ïཻ²¿·Ö;·ñÔòºÍµÚÒ»¸ö²éѯ½á¹ûûÓÐÇø±ð. INTERSECTÊÇÁ½¸ö² ......