SqlDbType ö¾ÙÓë Microsoft SQL Server Êý¾ÝÀàÐÍ
³ÉÔ±Ãû³Æ˵Ã÷
BigInt
Int64¡£64 λµÄÓзûºÅÕûÊý¡£
Binary
Byte ÀàÐ굀 Array¡£¶þ½øÖÆÊý¾ÝµÄ¹Ì¶¨³¤¶ÈÁ÷£¬·¶Î§ÔÚ 1 µ½ 8,000 ¸ö×Ö½ÚÖ®¼ä¡£
Bit
Boolean¡£ÎÞ·ûºÅÊýÖµ£¬¿ÉÒÔÊÇ 0¡¢1 »ò ¿ÕÒýÓã¨ÔÚ Visual Basic ÖÐΪ Nothing£©¡£
Char
String¡£·Ç Unicode ×Ö·ûµÄ¹Ì¶¨³¤¶ÈÁ÷£¬·¶Î§ÔÚ 1 µ½ 8,000 ¸ö×Ö·ûÖ®¼ä¡£
DateTime
DateTime¡£ÈÕÆÚºÍʱ¼äÊý¾Ý£¬Öµ·¶Î§´Ó 1753 Äê 1 Ô 1 ÈÕµ½ 9999 Äê 12 Ô 31 ÈÕ£¬¾«¶ÈΪ 3.33 ºÁÃë¡£
Decimal
Decimal¡£¹Ì¶¨¾«¶ÈºÍСÊýλÊýÊýÖµ£¬ÔÚ -10 38 -1 ºÍ 10 38 -1 Ö®¼ä¡£
Float
Double¡£-1.79E +308 µ½ 1.79E +308 ·¶Î§Äڵĸ¡µãÊý¡£
Image
Byte ÀàÐ굀 Array¡£¶þ½øÖÆÊý¾ÝµÄ¿É±ä³¤¶ÈÁ÷£¬·¶Î§ÔÚ 0 µ½ 2 31 -1£¨¼´ 2,147,483,647£©×Ö½ÚÖ®¼ä¡£
Int
Int32¡£32 λµÄÓзûºÅÕûÊý¡£
Money
Decimal¡£»õ±ÒÖµ£¬·¶Î§ÔÚ -2 63£¨¼´ -922,337,203,685,477.5808£©µ½ 2 63 -1£¨¼´ +922,337,203,685,477.5807£©Ö®¼ä£¬¾«¶ÈΪǧ·Ö֮ʮ¸ö»õ±Òµ¥Î»¡£
NChar
String¡£Unicode ×Ö·ûµÄ¹Ì¶¨³¤¶ÈÁ÷£¬·¶Î§ÔÚ 1 µ½ 4,000 ¸ö×Ö·ûÖ®¼ä¡£
NText
String¡£Unicode Êý¾ÝµÄ¿É±ä³¤¶ÈÁ÷£¬×î´ó³¤¶ÈΪ 2 30 - 1£¨¼´ 1,073,741,823£©¸ö×Ö·û¡£
NVarChar
String¡£Unicode ×Ö·ûµÄ¿É±ä³¤¶ÈÁ÷£¬·¶Î§ÔÚ 1 µ½ 4,000 ¸ö×Ö·ûÖ®¼ä¡£Èç¹û×Ö·û´®´óÓÚ 4,000 ¸ö×Ö·û£¬Òþʽת»»»áʧ°Ü¡£ÔÚʹÓÃ±È 4,000 ¸ö×Ö·û¸ü³¤µÄ×Ö·û´®Ê±£¬ÇëÏÔʽÉèÖöÔÏó¡£
Real
Single¡£-3.40E +38 µ½ 3.40E +38 ·¶Î§Äڵĸ¡µãÊý¡£
SmallDateTime
DateTime¡£ÈÕÆÚºÍʱ¼äÊý¾Ý£¬Öµ·¶Î§´Ó 1900 Äê 1 Ô 1 ÈÕµ½ 2079 Äê 6 Ô 6 ÈÕ£¬¾«¶ÈΪ 1 ·ÖÖÓ¡£
SmallInt
Int16¡£16 λµÄÓзûºÅÕûÊý¡£
SmallMoney
Decimal¡£»õ±ÒÖµ£¬·¶Î§ÔÚ -214,748.3648 µ½ +214,748.3647 Ö®¼ä£¬¾«¶ÈΪǧ·Ö֮ʮ¸ö»õ±Òµ¥Î»¡£
Text
String¡£·Ç Unicode Êý¾ÝµÄ¿É±ä³¤¶ÈÁ÷£¬×î´ó³¤¶ÈΪ 2 31 -1£¨¼´ 2,147,483,647£©¸ö×Ö·û¡£
Timestamp
Byte ÀàÐ굀 Array¡£×Ô¶¯Éú³ÉµÄ¶þ½øÖÆÊý£¬²¢±£Ö¤ÆäÔÚÊý¾Ý¿âÖÐΨһ¡£timestamp ͨ³£ÓÃ×÷¶Ô±íÖи÷Ðеİ汾½øÐбê¼ÇµÄ»úÖÆ¡£´æ´¢´óСΪ 8 ×Ö½Ú¡£
TinyInt
Byte¡£8 λµÄÎÞ·ûºÅÕûÊý¡£
Udt
SQL Server 2005 Óû§¶¨ÒåµÄÀàÐÍ (UDT)¡£
UniqueIdentifier
Guid¡£È«¾ÖΨһ±êʶ·û£¨»ò GUID£©¡£
VarBinary
Byte ÀàÐ굀 Array¡£¶þ½øÖÆÊ
Ïà¹ØÎĵµ£º
·½·¨Ò»£º
DB1 tb1
DB2 tb2
Ñ¡ÔñDB1 µ½±íµÄÁбíÄÇÀï
Ñ¡Ôñtb1±í ÓÒ¼ü ËùÓÐÈÎÎñ Êý¾Ýµ¼³ö
ÏÂÒ»²½ Ñ¡ÔñÄãÒªµ¼³öµÄÊý¾Ý¿âDB1 ÏÂÒ»²½ Ñ¡ÔñÄãÒªµ¼ÈëµÄÊý¾Ý¿âDB2
ÏÂÒ»²½ Ñ¡ÔñÄãÒªµ¼µÄ±í£¨Ç°Ã滹´£©tb1£¬ ºóÃæ¶ÔÓ¦µÄÊÇÐÂÊý¾Ý¿âµÄ±íÃûtb2£¨Ä¬ÈÏÊÇÏàͬ±íÃû£¬¿ÉÐ޸ģ© ÏÂÒ»²½ ÍêÁË ......
·½°¸1 ÊÊÓÃÓÚoracle9iÒÔÉÏ£¡
select * from
(select row_number() over(order by sendid desc) rn,m.* from xxt_msgreceive m )
where rn <1010 and rn>=1000
·½°¸2
SELECT * from (SELECT A.*, ROWNUM RN from (SELECT * from xxt_msg where sendstatus=1 order by msgid desc) A WHERE ROWNUM < ......
ÔÚ´æ´¢¹ý³Ì»ò´¥·¢Æ÷ÖÐʹÓà Transact-SQL ÓαêµÄµäÐ͹ý³ÌΪ£º
ÉùÃ÷ Transact-SQL ±äÁ¿°üº¬Óα귵»ØµÄÊý¾Ý¡£ÎªÃ¿¸ö½á¹û¼¯ÁÐÉùÃ÷Ò»¸ö±äÁ¿¡£ÉùÃ÷×ã¹»´óµÄ±äÁ¿À´±£´æÁзµ»ØµÄÖµ£¬²¢ÉùÃ÷±äÁ¿µÄÀàÐÍΪ¿É´ÓÁÐÊý¾ÝÀàÐÍÒþʽת»»µÃµ½µÄÊý¾ÝÀàÐÍ¡£
ʹÓà DECLARE CURSOR Óï¾ä½« Transact-SQL ÓαêÓë SELECT Óï¾äÏà¹ØÁª¡£ÁíÍ⣬D ......
¶Ôhttp request¹ýÀ´µÄÊý¾Ý£¬·²ÊǺ¬Óе¥ÒýºÅ£¬Ë«ÒýºÅ£¬·´Ð±Ïߵȶ¼½øÐмÓбÏß´¦Àí¡£·ÀÖ¹½øÐÐ×¢Èë²Ù×÷¡£
/*
¶ÂSQL©¶´
*/
function quotes($content){
//Èç¹ûmagic_quotes_gpc=Off£¬ÄÇô¾Í¿ªÊ¼´¦Àí
if (!get_magic_quotes_gpc()) {
//ÅжÏ$contentÊÇ·ñΪÊý×é
if (is_array($content)) {
//Èç¹û$contentÊÇ ......