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
Ïà¹ØÎĵµ£º
http://inthirties.com:90/thread-1202-1-1.html
v$sqltext
´æ´¢µÄÊÇÍêÕûµÄSQL,SQL±»·Ö¸î
SQL> desc v$sqltext
Name Null? Type
----------------------------------------- -------- ----------------------------
ADDRESS ......
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
ÖÐÎÄ£¨Ïã¸ÛÌرðÐ ......
1¡¢SessionÓÐʲôÖØ´óBUG£¬Î¢ÈíÌá³öÁËʲô·½·¨¼ÓÒÔ½â¾ö£¿
´ð£ºÊÇiisÖÐÓÉÓÚÓнø³Ì»ØÊÕ»úÖÆ£¬ÏµÍ³·±Ã¦µÄ»°Session»á¶ªÊ§£¬¿ÉÒÔÓÃSate server»òSQL ServerÊý¾Ý
¿âµÄ·½Ê½´æ´¢Session²»¹ýÕâÖÖ·½Ê½±È½ÏÂý£¬¶øÇÒÎÞ·¨²¶»ñSessionµÄENDʼþ¡£
2.²úÉúÒ»¸öintÊý×飬³¤¶ÈΪ100£¬²¢ÏòÆäÖÐËæ»ú²åÈë1-100£¬²¢ÇÒ²»ÄÜÖظ´¡£
C# ......
set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
go
ALTER PROCEDURE [dbo].[pagination]
@tblName varchar(255), -- ±íÃû
@strGetFields varchar(1000), -- ÐèÒª·µ»ØµÄÁÐ
@fldName varchar(255), -- ÅÅÐòµÄ×Ö¶ÎÃû
@PageSize int, -- Ò³³ß´ç
@PageIndex int, -- Ò³Âë
@OrderType bit, -- ÉèÖÃÅÅÐòÀàÐÍ, ·Ç 0 Öµ ......