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

sqlº¯Êý¡¡

1¡¢ISNULL ( check_expression , replacement_value )
²ÎÊý
check_expression
½«±»¼ì²éÊÇ·ñΪ NULLµÄ±í´ïʽ¡£check_expression ¿ÉÒÔÊÇÈκÎÀàÐ͵ġ£
replacement_valueÔÚ check_expressionΪNULLʱ½«·µ»ØµÄ±í´ïʽ¡£replacement_value ±ØÐëÓë check_expresssion ¾ßÓÐÏàͬµÄÀàÐÍ¡£
·µ»ØÀàÐÍ
·µ»ØÓë check_expression ÏàͬµÄÀàÐÍ¡£
×¢ÊÍ
Èç¹û check_expression ²»Îª NULL£¬ÄÇô·µ»Ø¸Ã±í´ïʽµÄÖµ£»·ñÔò·µ»Ø replacement_value¡£
2¡¢SUBSTRING ( expression , start , length )
²ÎÊý
expressionÊÇ×Ö·û´®¡¢¶þ½øÖÆ×Ö·û´®¡¢text¡¢image¡¢Áлò°üº¬Áеıí´ïʽ¡£²»ÒªÊ¹Óðüº¬¾ÛºÏº¯ÊýµÄ±í´ïʽ¡£
startÊÇÒ»¸öÕûÊý£¬Ö¸¶¨×Ó´®µÄ¿ªÊ¼Î»Öá£
lengthÊÇÒ»¸öÕûÊý£¬Ö¸¶¨×Ó´®µÄ³¤¶È£¨Òª·µ»ØµÄ×Ö·ûÊý»ò×Ö½ÚÊý£©¡£
˵Ã÷  ÓÉÓÚÔÚ text Êý¾ÝÉÏʹÓà SUBSTRING ʱ start ºÍ length Ö¸¶¨×Ö½ÚÊý£¬Òò´Ë DBCS Êý¾Ý£¨ÈçÈÕ±¾ºº×Ö£©¿ÉÄܵ¼ÖÂÔÚ½á¹ûµÄ¿ªÊ¼»ò½áÊøÎ»Öòð·Ö×Ö·û¡£´ËÐÐΪÓë READTEXT ´¦Àí DBCS µÄ·½Ê½Ò»Ö¡£È»¶ø£¬ÓÉÓÚż¶ø»á³öÏÖÆæ¹ÖµÄ½á¹û£¬½¨Òé¶Ô DBCS ×Ö·ûʹÓà ntext ¶ø·Ç text¡£
·µ»ØÀàÐÍ
Èç¹û expression ÊÇÖ§³ÖµÄ×Ö·ûÊý¾ÝÀàÐÍ£¬Ôò·µ»Ø×Ö·ûÊý¾Ý¡£Èç¹û expression ÊÇÖ§³ÖµÄ binary Êý¾ÝÀàÐÍ£¬Ôò·µ»Ø¶þ½øÖÆÊý¾Ý¡£
3¡¢OBJECT_ID
·µ»ØÊý¾Ý¿â¶ÔÏó±êʶºÅ¡£
Óï·¨
OBJECT_ID ( 'object' )
²ÎÊý
'object'
ҪʹÓõĶÔÏó¡£object µÄÊý¾ÝÀàÐÍΪ char »ò nchar¡£Èç¹û object µÄÊý¾ÝÀàÐÍÊÇ char£¬ÄÇôÒþÐÔ½«Æäת»»³É nchar¡£
·µ»ØÀàÐÍ
int
×¢ÊÍ
µ±¸Ã²ÎÊý¶Ôϵͳº¯Êý¿Éѡʱ£¬Ôòϵͳ²ÉÓõ±Ç°Êý¾Ý¿â¡¢Ö÷»ú¡¢·þÎñÆ÷Óû§»òÊý¾Ý¿âÓû§¡£ÄÚÖú¯ÊýºóÃæ±ØÐë¸úÔ²À¨ºÅ¡£
Èç¹ûÖ¸¶¨Ò»¸öÁÙʱ±íÃû£¬Ôò±ØÐëÔÚÁÙʱ±íÃûÇ°Ãæ¼ÓÉÏÊý¾Ý¿âÃû£¬ÀýÈ磺
SELECT OBJECT_ID('tempdb..#mytemptable')
4¡¢BETWEEN
Ö¸¶¨²âÊÔ·¶Î§¡£
Óï·¨
test_expression [ NOT ] BETWEEN begin_expression AND end_expression
²ÎÊý
test_expression
ÊÇÓÃÀ´ÔÚÓÉ begin_expression ºÍ end_expression ¶¨ÒåµÄ·¶Î§ÄÚ½øÐвâÊԵıí´ïʽ¡£test_expression ±ØÐëÓë begin_expression ºÍ end_expression ¾ßÓÐÏàͬµÄÊý¾ÝÀàÐÍ¡£
NOT
Ö¸¶¨Î½´ÊµÄ½á¹û±»È¡·´¡£
begin_expression
ÊÇÈκÎÓÐЧµÄ Microsoft? SQL Server? ±í´ïʽ¡£begin_expression ±ØÐëÓë test_expression ºÍ end_expression ¾ßÓÐÏàͬµÄÊý¾ÝÀàÐÍ¡£
end_expression
ÊÇÈκÎÓÐЧµÄ SQL Server ±í´ïʽ¡£end_expression ±ØÐëÓë test_expressio


Ïà¹ØÎĵµ£º

SQLÓï¾ä²éѯÊÇ·ñΪ¿Õ =null¼°null

  a                  b                             c&nb ......

.net³ÌÐòÔ±ËùÐèÕÆÎÕµÄsql£¬»ù±¾¼¼ÇÉ(1)

1¡¢SessionÓÐÊ²Ã´ÖØ´óBUG£¬Î¢ÈíÌá³öÁËʲô·½·¨¼ÓÒÔ½â¾ö£¿
  ´ð£ºÊÇiisÖÐÓÉÓÚÓнø³Ì»ØÊÕ»úÖÆ£¬ÏµÍ³·±Ã¦µÄ»°Session»á¶ªÊ§£¬¿ÉÒÔÓÃSate server»òSQL ServerÊý¾Ý
¿âµÄ·½Ê½´æ´¢Session²»¹ýÕâÖÖ·½Ê½±È½ÏÂý£¬¶øÇÒÎÞ·¨²¶»ñSessionµÄENDʼþ¡£
2.²úÉúÒ»¸öintÊý×飬³¤¶ÈΪ100£¬²¢ÏòÆäÖÐËæ»ú²åÈë1-100£¬²¢ÇÒ²»ÄÜÖØ¸´¡£
C# ......

.net³ÌÐòÔ±ËùÐèÕÆÎÕµÄsql£¬»ù±¾¼¼ÇÉ(2)

1. ¼òÊö private¡¢ protected¡¢ public¡¢ internal ÐÞÊηûµÄ·ÃÎÊȨÏÞ¡£
´ð . private :  ˽ÓгÉÔ±, ÔÚÀàµÄÄÚ²¿²Å¿ÉÒÔ·ÃÎÊ¡£
    protected : ±£»¤³ÉÔ±£¬¸ÃÀàÄÚ²¿ºÍ¼Ì³ÐÀàÖпÉÒÔ·ÃÎÊ¡£
    public :    ¹«¹²³ÉÔ±£¬ÍêÈ«¹«¿ª£¬Ã»ÓзÃÎÊÏÞÖÆ¡£
    internal:  ÔÚÍ¬Ò ......

Sql ServerÖÐÈçºÎÅжϱí»òÕßÊý¾Ý¿âµÄ´æÔÚ

sql serverÖÐÈçºÎÅжϱí»òÕßÊý¾Ý¿âµÄ´æÔÚ£¬µ«ÔÚʵ¼ÊʹÓÃÖУ¬ÐèÅжÏStatus״̬λ£º
ÆäÖÐijЩ״̬λ¿ÉÓÉÓû§Ê¹Óà sp_dboption£¨read only¡¢dbo use only¡¢single user µÈ£©½øÐÐÉèÖãº
1 = autoclose£»Ê¹Óà sp_dboption ÉèÖᣠÊý¾Ý¿âÍêÈ«¹Ø±Õ£¬Æä×ÊÔ´ÔÚ×îºóÒ»¸öÓû§×¢ÏúºóÊÍ·Å¡£
4 = select into/bulkcopy£»Ê¹Óà sp_dbopti ......

³¬¼¶SQL——ÔÚSQLÖÐÀÛ¼Ó

´ËΪתÌù£¬µ«ÊÇ´ÓÁ¬¸öÌû×ÓÖÐÊÕ¼¯¶øÀ´
ÏÂÃæÀ´Ò»Æð¿´¿´ÂÛ̳ÀïµÄÒ»¸öoracle·½ÃæµÄÎÊÌ⣺
====================Question
=========================
  jmbdat         dayt           y           &n ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ