ÇóÒ»SQLÓï¾ä
±í½á¹¹ÈçÏÂ
guest_no emp_no bdate edate remark cb hdb ColLevel
018 0056 2010-01-18 00:00:00 NULL NULL H 14.00 A
018 0071 2009-09-19 00:00:00 NULL NULL Y 22.00 B
018 0071 2009-10-27 00:00:00 NULL NULL K 26.00 A
080 0020 2009-07-28 00:00:00 2009-07-31 00:00:00 NULL H 20.00 A
080 0020 2009-07-28 00:00:00 2009-07-31 00:00:00 NULL K 10.00 A
080 0035 2002-01-01 00:00:00 NULL NULL Y 10.00 B
080 0096 2009-08-01 00:00:00 NULL NULL H 17.00 A
080 0096 2009-08-01 00:00:00 NULL NULL K 27.00 A
080 0107 2007-03-28 00:00:00 2009-07-27 00:00:00 NULL H 20.00 B
080 0107 2007-08-23 00:00:00 2009-07-27 00:00:00 NULL K 10.00 A
171 0056 2009-06-09 00:00:00 NULL NULL H 14.00 A
171 0071 2009-03-13 00:00:00 NULL NULL K 25.00 A
171 0071 2009-03-24 00:00:00 NULL NULL Y 22.00 A
Ñ¡³öºìÉ«À¸,¼´bdate´óÓÚ2009-02-25×îСÈÕÆÚÇÒ֮ǰÎ޼ǼµÄÊý¾Ý.
SQL code:
----------------------------------------------------------------
-- Author :SQL77(ֻΪ˼ÆëÀÏ)
-- Date :2010-02-25 16:21:05
-- Version:
-- Microsoft SQL Server 2000 - 8.00.194 (Intel X86)
-- Aug 6 2000 00:57:48
-- Copyright (c
Ïà¹ØÎÊ´ð£º
select convert(varchar(50),cast(convert(numeric(18,2),1275674000000/100000000)as real))+'ÒÚ'
select cast(convert(numeric(18,2),1275674000000/100000000)as real)
ΪʲôÉÏÒ»¸öÓÃvarcharת»»ºó¾ÍÖ»±£ÁôÁËÒ ......
³¡¾°ÈçÏ£º
¿Í»§°Ñ±¸·ÝºÃµÄÊý¾Ý¿â£¬·¢¸øÎÒ£¬ÎÒÔÚ±¾»ú»¹Ôºó£¬ÔËÐÐдºÃµÄ´æ´¢¹ý³Ì£¬±È½Ï¿ì£¬²¢ÇÒÔÚʵʩÄDZßÔËÐÐͬÑù±È½Ï¿ì¡£µ«Êǵ±ÊµÊ©ÔÚ¿Í»§ÄDZßÔËÐеÄʱºòËٶȾͷdz£µÄÂý£¬Ê±¼ä³¬³öÁ˳ÌÐòµÄʱ¼äÏÞÖÆ¡£Ô¶³ÌÔÚ¿Í»§ÄÇ ......
ÈçºÎÔÚSQL2005ÖÐÉ趨¶¨Ê±×÷Òµ£¬±ÈÈç˵¶¨Ê±ÇåÀíijЩ±íµÄÊý¾Ý£¬
»òÕßÊǶ¨Ê±µÄ½«Ä³Ð©±íµÄÊý¾Ýµ¼³öexcel£¡
ÔÚÏߵȴý£¬¼±¼±¼±£¬×îºÃÊÇÏêϸ²½Ö裡
֮ǰÎÒ×öµÄ×÷ÒµÓеãÎÊÌ⣡
°ïUP
²Î¿¼:http://hi.baidu.com/toiota ......
tab1 ×Ö¶Î:billdate,goodsid,incount,inmoney,outcount,outmoney,endprice,endcount,endamt
tab2 ×Ö¶Î:goodsid,goodskind£¨ÉÌÆ·ÀàÐÍ£©
tab3 ×Ö¶Î:goodskind£¨ÉÌÆ·ÀàÐÍ£©,kindname
½á¹û£º
µÃµ½ÉÌÆ·ÀàÐÍÔÚÒ»¶Îʱ¼ä ......
¸Õ¸Õ½Ó´¥MySQL,²»ÖªµÀ¸ÃÈçºÎÈ¥²é¿´Êý¾Ý£¬²åÈëÊý¾Ý£¬´´½¨Êý¾Ý¿â¡¢±í£¬ÓÃÄÄΪǰ±²ÄÜÖ¸½ÌÒ»¶þ£¿
MySQL 5.1²Î¿¼ÊÖ²á
ÒýÓÃ
ÐÖµÜÄã»á½áÌùÂð£¿
mysql ²Î¿¼ÊÖ²á
baidu
MySQL¹Ù·½Îĵµ http://dev.mysql.com/doc ......