SqlServerÖÐ×Ö·ûÐÍת»»ÎªÊý×ÖÐͳöÏîµÄÎÊÌâ
SqlServerÖÐ×Ö·ûÐÍת»»ÎªÊý×ÖÐͳöÏîµÄÎÊÌâ select @rno=rno from deleted; convert(numeric,@rno); @rno=@rno/1000; ÏûÏ¢ 156£¬¼¶±ð 15£¬×´Ì¬ 1£¬¹ý³Ì t2£¬µÚ 11 ÐÐ ¹Ø¼ü×Ö 'convert' ¸½½üÓÐÓï·¨´íÎó¡£
select @rno=rno from deleted; set @rno = cast(@rno as numeric) SQL code: select @rno=rno from deleted; SET @rno=convert(numeric,@rno); SET @rno=@rno/1000; SQL code: select @rno=rno from deleted; SET @rno=convert(numeric(18,5),@rno); SET @rno=@rno/1000; Éè¼ÆÒ»Ï¾«¶ÈÒýÓà select @rno=rno from deleted; set @rno = cast(@rno as numeric) Ŷ£¡ÔÀ´Èç´Ë£¡ÕâÑù²ÅÐУ¡ ¿ÉÊÇÕâÑùת¹ýÖ®ºóÓÖ³öÏÖ¸öÎÊÌâ ÏûÏ¢ 102£¬¼¶±ð 15£¬×´Ì¬ 1£¬¹ý³Ì t2£¬µÚ 12 ÐÐ '@rno' ¸½½üÓÐÓï·¨´íÎó¡£ ×ª»»³ÉÊýÖµÐÍÖ®ºóΪʲô²»ÄܽøÐÐÊýѧÔËËãÄØ£¿£¿ SQL code: declare @rno varchar(20) set @rno=convert(numeric(18,2),@rno); set @rno=@rno/1000; select @rno=rno from deleted; SQL code Code highlighting produced by
Ïà¹ØÎÊ´ð£º
sqlserver,Èç¹û¼Ó¸öÓû§,ȨÏÞÊǶÁËùÓÐ±í£¬µ«Ö»ÄÜÐÞ¸Äij¸ö±íµÄ×Ö¶ÎÊôÐÔ Ã»Õâ¸ö˵·¨. Ö»¸øSELECT , UPDATEµÄÖ»¸øÄ³Ð©±í ¸ö²»»á µ«Ö»ÄÜÐÞ¸Äij¸ö±íµÄ×Ö¶ÎÊôÐÔ Õâ¸öÄѸã Òª¼ÓȨÏÞµÃÕë¶Ôij¸öÊý¾Ý¿â
......
´ó¼ÒÓÐûÓÐ ´æ´¢¹ý³Ì·ÖÒ³µÄÀý×Ó£¬¹²Ïíһϣ¬Ð»Ð»£¡£¡£¡ http://wyf.javaeye.com/blog/462396 SET QUOTED_IDENTIFIER ON GO SET ANSI_NULLS ON GO /*--ʵÏÖ·ÖÒ³µÄͨÓô洢¹ý³Ì ......
ÊÇÕâÑùµÄ£¬ÎÒÓÃÊÇODBCÊý¾ÝÔ´Á¬½Ó·þÎñÆ÷µÄÊý¾Ý¿â£¬ÏÖÔÚÎÒ¾õµÃºÜÂé·³£¬ÒòΪҪΪÿÈç»úÌí¼Ó¶ÔÓ¦µÄÊý¾ÝÔ´£¬Ïë°ÑËû¸Ä³ÉADO·½·¨À´·ÃÎÊ·þÎñÆ÷µÄÊý¾Ý¿âÄÜʵÏÖÂð£¿ÒªÔõôд¡£ ±ÈÈç·þÎñÆ÷ÀïÓжþ¸öÊý¾Ý¿âdata1 ºÍdata2£¬¿Í»§ ......
½ñÌìÍøÉÏ¿´Ò»¸öÏîÄ¿£¨sqlserver£«¡£net£©·¢ÏÖËûµÄsqlÈ«²¿Óô洢¹ý³ÌʵÏÖ ÕâÀïÓкܴóµÄÒÉÎÊ¡£ Èç¹ûÊÇСÏîÄ¿£¬½ö½ö¹©Ð¡team¼¸¸öÈËÓã¬ÊÇÎÞËùνµÄ Èç¹û²¢·¢Óû§ÊýÊǺܴóµÄ ½¨ÒéÓÃweb·þÎñÆ÷À´Ôö¼Ó¸ºÔØ£¬²»Ó¦ ......
SqlServer´´½¨Óû§Ê±Ä¬ÈϾ͸³ÓèÁËÒ»¸öpublic½ÇÉ«¡£ ÎÒÊÇ·ñ¿ÉÒÔ´´½¨Ò»¸öÓû§£¬ÈÃÕâ¸öÓû§Ö»ÓеǼµÄȨÏÞ£¬Ã»ÓÐÆäËûµÄȨÏÞ£¡ ÎÒµÄÊý¾Ý¿âÊÇSqlServer2000 SQL code: --Ìí¼ÓµÇ¼ wh1,ÉèÖÃÃÜÂëΪ123,ĬÈÏÊý¾ ......