mssql ¶Ì·ÅжÏÄÜʵÏÖÂð
cÓïÑÔÖеÄ&ºÍ&&£¬ÆäÖÐ&&¾ßÓжÌ·ÅжϹ¦ÄÜ£¬ÔÚmssqlÖÐÓжÌ·ÅжÏÂÎÒÓÃand²»ÐУ¬°Ñand»»³É&&±¨´íÁË
MSSQLÖÐûÓÐ&&
½«nvarchar Öµ '1g' ת»»ÎªÊý¾ÝÀàÐÍΪ int µÄÁÐʱ·¢ÉúÓï·¨´íÎó£¬Äܲ»ÄÜÈÃÕâ¸öÌø¹ý£¬¾ÍÊÇ˵²éÕÒµ½²»ÄÜת»»µÄ¾Í²»¹ÜËüÁË
Õâ¸ö£¬Ó¦¸ÃÊÇ¿ÉÒÔÓбä֮ͨ·¨µÄ
ÕâÖÖ¶¼ÊÇÓÃwhereÌõ¼þ¹ýÂ˵ôµÄ£¬¾ÍÏñ2Â¥Ëù˵µÄwhere isnumeric(×Ö¶Î)=1
Ïà¹ØÎÊ´ð£º
Ö÷»ú
¿Í»§»úc1,c2,c3,c4,c5............
ÒªÇóÈçºÎ±£Ö¤¿Í»§»úÏòÖ÷»úÌá½»Êý¾Ý¾¡Á¿ÊµÊ±.¿ìËÙ.ÍêÕû
Ö±½ÓÓÃinsert ʱ,Ëø×¡Ö÷»úµÄ±í.ËùÒÔ´Ë·½·¨²»¿ÉÐÐ
Çë¸ßÊÖÖ§ÕÐ..
Èç¹ûÖ»²åÈë¶ø²»¶Á£¬Óõ͸ôÀë¼¶±ð
Äã²åÄãµÄ,Ëû²å ......
±íµÄ½á¹¹ÈçÏ£º
±í1£ºtb_big
×ֶΣºfalseid Öµ£º1£¬2£¬
×ֶΣºbigtype Öµ£ºA£¬B£¨ÓëfalseidµÄÖµµÄλÖÃÒ»Ò»¶ÔÓ¦£¬¼´1¶ÔÓ¦A£¬2¶ÔÓ¦B£©
±í2£ºtb_small
×ֶΣºfalseid£¨Óëtb_bigµÄfalseid_1¹ØÁªµ ......
´æ´¢¹ý³ÌÊÇÕâôдµÄ£¬
Declare @id int
BEGIN TRANSACTION
Insert into xxxxxTable(f1,f2)values(@a,@b)
Select @id=@@identit ......
Ò»ÕÅ±í£¬×ֶηÖΪ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 ......
ÎÒµÄÒ»°Ù¶àÍòÊý¾ÝÄÚ´æÏûºÄÌ«´óÁË Á½Ìì²»ÖØÆôsql·þÎñÖ±½Ó±Ä3GÁË ÎÒ·þÎñÆ÷×ܹ²²Å4G ²»ÄÜÈÃËûÕâôÕÛÌÚ¡£
mysqlÖ§³Ö·ÖÇøÂ𣿣¿£¿
ÓÐʲôÈí¼þ¿ÉÒÔ±ã½ÝµÄ°Ñmssql2005Êý¾Ý¿âתµ½mysqlÀ£¿£¿Ð»Ð»´ ......