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

ÔÚ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£©


Ïà¹ØÎĵµ£º

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 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
Ô­Òò£º×ö°²È« ......

ÓÅ»¯µÄms sql server·ÖÒ³sqlÓï¾ä

ÓÅ»¯µÄms sql server·ÖÒ³sqlÓï¾ä
·¢²¼Ê±¼ä: 2009-8-15 00:00 |  ·¢²¼×÷Õß: hjh |   |  ²é¿´: 3´Î
ÌØµã£ºÒ»´Î²éѯ£¬Êý¾Ý¿âDatabnseÖ»·µ»ØÒ»Ò³µÄÊý¾Ý¡£¶ø·ñÔòÈ¡³öËùÓеÄÊý¾Ý¡£
˵Ã÷£º
pagesize£º ÿҳ³ÊÏּǼÊý
cureentpage£ºµ±Ç°Ò³Êý
select * from ( select TOP pagesize * from ( S ......

PL/SQL Developer ʹÓü¼ÇÉС½á

ÒÔϵļ¼ÇÉÖ»Õë¶ÔPL/SQL Developer 6ÒÔÉϰ汾£¬°æ±¾5Ö»ÓÐÆäÖеIJ¿·ÖÌØÐÔ¡£
1£¬ÓÒ¼ü²Ëµ¥
ÔÚPL/SQL Developer£¨ÏÂÃæ¼ò³ÆPLD£©ÖеÄÿһ¸öÎı¾±à¼­´°¿Ú£¬ÈçSQL Window£¬Command WindowºÍPorgram Window£¬ÓÒ¼üµã»÷ij¸ö¶ÔÏóÃû³Æ£¬»áµ¯³öÒ»¸ö°üº¬²Ù×÷¶ÔÏóÃüÁîµÄ²Ëµ¥£¬ÎÒÃÇÕâÀï³ÆÖ®ÎªÓÒ¼ü²Ëµ¥¡£ÈçÏÂͼ£º
¶ÔÏóÀàÐÍ¿ÉÒÔÊÇ±í£¬ÊÓͼ£ ......

Ö彨ÀÏʦµÄSQLÈ«½Ç/°ë½Çת»»

if   exists   (select   *   from   dbo.sysobjects   where   id   =   object_id(N'[dbo].[f_convert]')   and   xtype   in   (N'FN',   N'IF',   N'TF'))&n ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ