SQLÈçºÎÓÅ»¯ÎÊÌâ - MS-SQL Server / ÒÉÄÑÎÊÌâ
½ñÌì×öÁËÒ»¸ö´æ´¢¹ý³Ì »·¾³ÊÇSQL2000Êý¾Ý¿â
´óÖÂÈçÏÂ
½¨Á¢ÁÙʱ±í
¶¨ÒåÔ±¹¤Óαê
Ñ»·Ô±¹¤£¨ÊôÓÚ1¸ö¹«Ë¾)
¶¨Ò幫˾¹¤×ÊÏîÄ¿Óαê
Ñ»·¸Ã¹«Ë¾¹¤×ÊÏîÄ¿(ÓÐ50¸ö×óÓÒ¹¤×ÊÏîÄ¿)
£¨ÓÐЩ¿ÉÒÔÖ±½Ó´Ó¹¤×ʱíÀïÃæÖ±½ÓÈ¡³öÀ´ ±ÈÈçÌõ¼þÊǹ¤×ÊÏîÄ¿±àºÅ=2
µ«ÊÇÓÐЩ²»ÄÜÖ±½ÓÈ¡ ±ÈÈ繤×ÊÏîÄ¿±àºÅ2+ ¹¤×ʱàºÅ3µÈµÈ
¼ÆËãÁ¿¿ÉÄܱȽϴó ÕâÀïµÄSQL¶¼ÊǶ¯Ì¬Éú³É³öÀ´µÄ£©
ÿ´ÎÓÃexec sp_executesql ¼ÆËã½á¹û
½áÊøÑ»·¸Ã¹«Ë¾
Ïà¹ØÎÊ´ð£º
±íÈçÏÂ
½ÌÊÒID ×ùλÊý ¿ªÊ¼Ê±¼ä ½áÊøÊ±¼ä 2009Äê1ÔÂ1ÈÕ 2009Äê1ÔÂ2ÈÕ 2009Äê1ÔÂ3ÈÕ
101 50 08£º00 08£º30 30 40 50
101 50 09£º00 ......
select convert(varchar(50),cast(convert(numeric(18,2),1275674000000/100000000)as real))+'ÒÚ'
select cast(convert(numeric(18,2),1275674000000/100000000)as real)
ΪʲôÉÏÒ»¸öÓÃvarcharת»»ºó¾ÍÖ»±£ÁôÁËÒ ......
ÎÒµÄTblworkbill±íµÄÊý¾ÝÈçÏÂ:
id workbillno ..................
1 1
2 6
3 a1
4 c2
5 2
6 aa
7 ......
³¡¾°ÈçÏ£º
¿Í»§°Ñ±¸·ÝºÃµÄÊý¾Ý¿â£¬·¢¸øÎÒ£¬ÎÒÔÚ±¾»ú»¹Ôºó£¬ÔËÐÐдºÃµÄ´æ´¢¹ý³Ì£¬±È½Ï¿ì£¬²¢ÇÒÔÚʵʩÄDZßÔËÐÐͬÑù±È½Ï¿ì¡£µ«Êǵ±ÊµÊ©ÔÚ¿Í»§ÄDZßÔËÐеÄʱºòËٶȾͷdz£µÄÂý£¬Ê±¼ä³¬³öÁ˳ÌÐòµÄʱ¼äÏÞÖÆ¡£Ô¶³ÌÔÚ¿Í»§ÄÇ ......
<table style="width: 1000px"><tr>
<td style="height: 38px; width: 35px;">
ÐÕÃû</td>
......