Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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 Server±¨´íChinese_PRC_90_CI_AS

SQL Server 2005±¨ÁËÕâô¸ö´í£ºCannot resolve the collation conflict between "Chinese_PRC_CI_AS" and "Chinese_PRC_90_CI_AS" in the like operation.
ºó²éÖ¤£¬ÕâÊÇÓÉÓÚÁ½¸ö×ö±È½ÏµÄÁеÄÅÅÐò·½Ê½²»Í¬£¬ÖÐÎÄÓкܶàÖÖÅÅÐò·½Ê½£¬¶ÔÓ¦ÈçÏ£º
ÖÐÎÄ£¨Ïã¸ÛÌØ±ðÐÐÕþÇø£©
Chinese_Hong_Kong_Stroke_90_CI_AS
ÖÐÎÄ£¨Ïã¸ÛÌØ±ðÐ ......

Sql Server²é¿´ËùÓÐÊý¾Ý¿âÃû,±íÃû,×Ö¶ÎÃûSQL

1.»ñÈ¡ËùÓÐÊý¾Ý¿âÃû:
SELECT Name from Master..SysDatabases ORDER BY Name
2.»ñÈ¡ËùÓбíÃû:
SELECT Name from DatabaseName..SysObjects Where XType='U' ORDER BY Name
XType='U':±íʾËùÓÐÓû§±í;
XType='S':±íʾËùÓÐϵͳ±í;
3.»ñÈ¡ËùÓÐ×Ö¶ÎÃû:
SELECT Name from SysColumns WHERE id=Object_Id('TableNam ......

SQL Server³£Óú¯Êý

ÔÚÊý¾Ý¿â²éѯÊý¾Ýʱ£¬ÎÒÃǾ­³£Ê¹ÓÃһЩº¯Êý£¬Ê¹ÎÒÃǵIJéѯ¸ü¼Ó·½±ã¿ì½Ý£¬ÏÂÃæ¾Í°ÑSQL ServerÖÐÎÒÃdz£Óõöº¯Êý¸øÁоٳöÀ´£¬¹©²Î¿¼¡£
1.×Ö·û´®º¯ÊýÓû§¿ØÖÆ·µ»Ø¸øÓû§µÄ×Ö·û´®£¬ÕâЩ¹¦ÄܽöÓÃÓÚ×Ö·ûÐÍÊý¾Ý¡£
2.ÈÕÆÚº¯ÊýÓÃÓÚ²Ù×÷ÈÕÆÚÖµ£¬ÎÒÃDz»ÄÜÖ±½Ó¶ÔÈÕÆÚÔËÓÃÊýѧº¯Êý¡£
3.Êýѧº¯ÊýÓÃÓÚ¶ÔÊýÖµ½øÐдúÊýÔËËã¡£
4.ϵͳº¯ ......

sql server·ÃÎÊÔ¶³ÌÊý¾Ý¿â

--´´½¨Á´½Ó·þÎñÆ÷
exec sp_addlinkedserver   'ITSV ', ' ', 'SQLOLEDB ', 'Ô¶³Ì·þÎñÆ÷Ãû»òipµØÖ· '
exec sp_addlinkedsrvlogin 'ITSV ', 'false ',null, 'Óû§Ãû ', 'ÃÜÂë '
--²éѯʾÀý
select * from ITSV.Êý¾Ý¿âÃû.dbo.±íÃû
--µ¼ÈëʾÀý
select * into ±í from ITSV.Êý¾Ý¿âÃû.dbo.±íÃû
--ÒÔºó²» ......

sqlÈÕÆÚÄ£ºý²éѯ SQLʱ¼äת»»¸ñʽ

Select * from t_user_profile where convert ( varchar ( 21 ),regDate, 120 ) like ' 2008-05-07% ' ±íÃû³Æ£ºt_user_profile ÈÕÆÚ×Ö¶ÎÃû³Æ£ºregDate
Select   *   from t_user_profile  where  convert(varchar(21),regDate,120) like '2008-05-07%'< ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ