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

mssql ¶Ì·ÅжÏÄÜʵÏÖÂð

cÓïÑÔÖеÄ&ºÍ&&£¬ÆäÖÐ&&¾ßÓжÌ·ÅжϹ¦ÄÜ£¬ÔÚmssqlÖÐÓжÌ·ÅжÏÂÎÒÓÃand²»ÐУ¬°Ñand»»³É&&±¨´íÁË
MSSQLÖÐûÓÐ&&

½«nvarchar Öµ '1g' ת»»ÎªÊý¾ÝÀàÐÍΪ int µÄÁÐʱ·¢ÉúÓï·¨´íÎó£¬Äܲ»ÄÜÈÃÕâ¸öÌø¹ý£¬¾ÍÊÇ˵²éÕÒµ½²»ÄÜת»»µÄ¾Í²»¹ÜËüÁË


Õâ¸ö£¬Ó¦¸ÃÊÇ¿ÉÒÔÓбä֮ͨ·¨µÄ

ÒýÓÃ
½«nvarchar Öµ '1g' ת»»ÎªÊý¾ÝÀàÐÍΪ int µÄÁÐʱ·¢ÉúÓï·¨´íÎó£¬Äܲ»ÄÜÈÃÕâ¸öÌø¹ý£¬¾ÍÊÇ˵²éÕÒµ½²»ÄÜת»»µÄ¾Í²»¹ÜËüÁË


ÕâÖÖ¶¼ÊÇÓÃwhereÌõ¼þ¹ýÂ˵ôµÄ£¬¾ÍÏñ2Â¥Ëù˵µÄwhere isnumeric(×Ö¶Î)=1


Ïà¹ØÎÊ´ð£º

MSSQL¿Í»§»úÉϽ»Êý¾Ý

Ö÷»ú
¿Í»§»úc1,c2,c3,c4,c5............
ÒªÇóÈçºÎ±£Ö¤¿Í»§»úÏòÖ÷»úÌá½»Êý¾Ý¾¡Á¿ÊµÊ±.¿ìËÙ.ÍêÕû
Ö±½ÓÓÃinsert ʱ,Ëø×¡Ö÷»úµÄ±í.ËùÒÔ´Ë·½·¨²»¿ÉÐÐ
Çë¸ßÊÖÖ§ÕÐ..
Èç¹ûÖ»²åÈë¶ø²»¶Á£¬Óõ͸ôÀë¼¶±ð

Äã²åÄãµÄ,Ëû²å ......

ÔÚMSSQLÖÐдһ¸ö´¥·¢Æ÷

±íµÄ½á¹¹ÈçÏ£º

±í1£ºtb_big
×ֶΣºfalseid Öµ£º1£¬2£¬
×ֶΣºbigtype Öµ£ºA£¬B£¨ÓëfalseidµÄÖµµÄλÖÃÒ»Ò»¶ÔÓ¦£¬¼´1¶ÔÓ¦A£¬2¶ÔÓ¦B£©

±í2£ºtb_small
×ֶΣºfalseid£¨Óëtb_bigµÄfalseid_1¹ØÁªµ ......

delphiÈçºÎ»ñÈ¡mssql´æ´¢¹ý³ÌµÄ·µ»ØÖµ

´æ´¢¹ý³ÌÊÇÕâôдµÄ£¬
Declare @id int
    BEGIN TRANSACTION
 
      Insert into xxxxxTable(f1,f2)values(@a,@b)
      Select @id=@@identit ......

MSSQLÖÐÈçºÎÑ¡ÔñÒ»ÐÐÖÐ×îСµÄʱ¼ä£¿

Ò»ÕÅ±í£¬×ֶηÖΪid,time1,time2,time3,time4,time5 
ÇëÎÊÎÒÓ¦¸ÃÈçºÎÑ¡ÔñIDΪ1µÄÄÇÌõ¼Ç¼ÖÐtimeʱ¼ä×îСµÄֵĨ£¿
UP!

[code=SQL][/code]select min(t) from 
(select time1 as t from t1 where id ......

mssqlתmysql

ÎÒµÄÒ»°Ù¶àÍòÊý¾ÝÄÚ´æÏûºÄÌ«´óÁË Á½Ìì²»ÖØÆôsql·þÎñÖ±½Ó±Ä3GÁË  ÎÒ·þÎñÆ÷×ܹ²²Å4G ²»ÄÜÈÃËûÕâôÕÛÌÚ¡£


mysqlÖ§³Ö·ÖÇøÂ𣿣¿£¿

ÓÐʲôÈí¼þ¿ÉÒÔ±ã½ÝµÄ°Ñmssql2005Êý¾Ý¿âתµ½mysqlÀ£¿£¿Ð»Ð»´ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ