ÔÚsql serverÖÐÊäÈë'NULL'×Ö·û´®µÄÓÐȤ·¢ÏÖ£¡
Èçͼ1¡¢2£¬id=1µÄÊý¾ÝÊÇNULL£¬ÆäËûµÄΪ·ÇNULLµÄÊý¾Ý¡£
Ò»°ãÇé¿öÏ£¬»áÓÃÁ½ÖÖ·½·¨£¡
·½·¨1.t-sql£ºinsert into E values(1,'NULL')£¬²åÈëºó£¬ÔÚ´ò¿ª±íµÄÇé¿öÏ¿´µ½µÄ
ÊÇ'NULL'£¨ÎÒÏëÊÇΪÁËÇø·ÖNULL£¬²Å¼ÓµÄÒýºÅ£©£¬µ«ÊDzéѯµÄʱºò²»Ó°Ï죬ÏÔʾµÄÊÇNULL£¬
Èçͼ1¡¢2£¬idΪ6µÄÊý¾Ý¡£
Èç¹ûÒª²åÈë´øµ¥ÒýºÅµÄ'NULL'£¬insert into E values(1,'''NULL''')£¬ÔÚ´ò¿ª±íµÄÇé¿öÏ¿´µ½
µÄÊÇ'NULL'£¬²éѯµÄʱºò£¬ÏÔʾµÄÒ²ÊÇ'NULL'£¬Èçͼ1¡¢2£¬idΪ7µÄÊý¾Ý¡£
ÉÏÊö2ÖÖÇé¿ö£¬ÔÚ´ò¿ª±íµÄʱºò£¬ÏÔʾµÄÊÇÒ»ÑùµÄ£¡
·½·¨2.´ò¿ª±í£¬ÊÖ¶¯Ìí¼Ó£¬ÕâÀï»áÓöµ½ÎÊÌ⣬Èç¹ûÊäÈëNULL£¬Ôò»á·¢ÏÖ×Ô¶¯±ä³ÉбÌ壨±íʾ
²åÈëÁËNULL£¬¶ø²»ÊÇ'NULL'£¬id=1µÄÊý¾Ý£©£¬Èç¹ûÌí¼Ónull¡¢NULL1¡¢NullÀ×ͬµÄ¶¼ÊÇ¿ÉÒÔ
µÄÕý³£µÄ¡£id=5µÄÊý¾ÝÊǶàÌí¼ÓÁËÒ»¸ö¿Õ¸ñ¡£
´ËÍ⣬»¹·¢ÏÖ£¬Èç¹û¸ü¸Äid=7µÄÊý¾Ý£¬½«µ¥ÒýºÅÈ¥µô£¬¾Í»á±ä³ÉNULL£¬Èç¹û
ÔÙ½«µ¥ÒýºÅÌí¼ÓÉÏ£¬´ò¿ª±íµÄÇé¿öÊÇ'NULL'£¬µ«ÊDzéѯ³öÀ´¾Í±ä³ÉºÍid=6Ò»Ñù£¬±ä³ÉÁËNULL¡£
Õâʱ£¬³ýÁËÓÃt-sql¸ÄµÄ»°£¬MSÊÖ¶¯Ã»·¨Ð޸ijÉ'NULL'¡£
ͼ1£º´ò¿ª±íµÄÇé¿ö(Open Table)
ͼ2£º²éѯ±íµÄÇé¿ö£¨select * from E£©
Ïà¹ØÎĵµ£º
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 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
ÔÒò£º×ö°²È« ......
ÓÅ»¯µÄms sql server·ÖÒ³sqlÓï¾ä
·¢²¼Ê±¼ä: 2009-8-15 00:00 | ·¢²¼×÷Õß: hjh | | ²é¿´: 3´Î
ÌØµã£ºÒ»´Î²éѯ£¬Êý¾Ý¿âDatabnseÖ»·µ»ØÒ»Ò³µÄÊý¾Ý¡£¶ø·ñÔòÈ¡³öËùÓеÄÊý¾Ý¡£
˵Ã÷£º
pagesize£º ÿҳ³ÊÏּǼÊý
cureentpage£ºµ±Ç°Ò³Êý
select * from ( select TOP pagesize * from ( S ......
ÒÔϵļ¼ÇÉÖ»Õë¶ÔPL/SQL Developer 6ÒÔÉϰ汾£¬°æ±¾5Ö»ÓÐÆäÖеIJ¿·ÖÌØÐÔ¡£
1£¬ÓÒ¼ü²Ëµ¥
ÔÚPL/SQL Developer£¨ÏÂÃæ¼ò³ÆPLD£©ÖеÄÿһ¸öÎı¾±à¼´°¿Ú£¬ÈçSQL Window£¬Command WindowºÍPorgram Window£¬ÓÒ¼üµã»÷ij¸ö¶ÔÏóÃû³Æ£¬»áµ¯³öÒ»¸ö°üº¬²Ù×÷¶ÔÏóÃüÁîµÄ²Ëµ¥£¬ÎÒÃÇÕâÀï³ÆÖ®ÎªÓÒ¼ü²Ëµ¥¡£ÈçÏÂͼ£º
¶ÔÏóÀàÐÍ¿ÉÒÔÊÇ±í£¬ÊÓͼ£ ......
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[f_convert]') and xtype in (N'FN', N'IF', N'TF'))&n ......