ÓйØSQL server2005
ÔõôÓ𡣿²éѯ·ÖÎöÆ÷¶¼ÕÒ²»µ½..555
Â¥Ö÷±ð¼±ÂýÂýÀ´¡£¸Õ½Ó´¥ÐÂÈí¼þ¶¼ÕâÑù¡¡
¿´×ŽçÃæÆ«×óÉÏÄÇÀïÓÐÒ»¸ö°´Å¥ÊÇ¡°Ð½¨²éѯ¡± È»ºóÑ¡ÔñÁ¬½Ó ¾Í¿ÉÒÔÁË
²éѯ·ÖÎöÆ÷,Äãµã¿ª¾ÍÌáʾÁ¬½Ó,ĬÈÏÊÇLOCALÖ±½ÓÁ¬½Óѽ,È»ºóÑ¡ÔñÊý¾Ý¿â,д²éѯѽ
´ò¿ª
SQL SERVER MANAGEMENT STUDIO
¿ªÊ¼²Ëµ¥µÄ Microsoft SQL Server 2005 ÏÂÃæÓиö SQL Server Management Studio
¶¼ÊÇÇ¿ÈË.ɶ¶¼¶®.
ҪôûװSQL2005¿Í»§¶Ë¹¤¾ß
×°Á˵ϰֱ½ÓÆô¶¯SSMS
Ïà¹ØÎÊ´ð£º
»·¾³£º1.win2003server+oracle9i
2.oracle9i×Ö·û¼¯ÎªAMERICAN_AMERICA.WE8ISO8859P1
3.oracle sql developer°æ±¾ 1.5.5
ÏÖÏóÃèÊö: 1.ÔÚsql developer ÖвéѯoracleÖеÄij¸ö±í£¬ÖÐÎÄÈ«²¿ÏÔʾΪÂÒÂë¡£
......
select convert(varchar(50),cast(convert(numeric(18,2),1275674000000/100000000)as real))+'ÒÚ'
select cast(convert(numeric(18,2),1275674000000/100000000)as real)
ΪʲôÉÏÒ»¸öÓÃvarcharת»»ºó¾ÍÖ»±£ÁôÁËÒ ......
¸÷λ´óÏÀ¾ÈÃü°¡ £¡£¡
¸Õ×°ÁËSQL2000 sp3
ÏëÓÃJSPÁ¬½ÓÊý¾Ý¿âµ«ÊdzöÏÖÎÊÌâÁË
ÎÒÓõÄÊÇJDK6.0+tomcat5.0+SQL2000 SP3+JDBC sp3
ËüÏÔʾµÄÊÇ
javax.servlet.ServletException: [Microsoft][SQLServer 2000 Driver fo ......
ÏÖÔÚÓÐa1,a2Á½±í
a1
id name aa cc
001 aaaa bbb cc
002 bbb bbb bbb
003 ccc ccc ccc
004 ddd ddd ddd
005 eee eee eee
a2
id ida2 ff b ......
Ò»Õűítable×Ö¶ÎF1ºÍF2
F1 F2
1 a
2 ......