Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

ÔÚSQLÖÐʹÓÃconvertº¯Êý½øÐÐÈÕÆÚµÄ²éѯ

Ôø¾­Óöµ½ÕâÑùµÄÇé¿ö,ÔÚÊý¾Ý¿âµÄMeeting±íÖÐÓÐPublishTime (DateTime,8)×Ö¶Î,ÓÃÀ´´æ´¢Ò»¸ö¿ª»áʱ¼ä,ÔÚ´æÈëʱÓÉÓÚÒªÖ¸Ã÷¿ª»á¾ßÌåʱ¼ä,¹Ê¸ñʽΪyyyy-mm-dd hh:mm:ss,¶øÎÒÃDzéѯʱÊÇͨ¹ýyyyy-mm-ddÀ´½øÐеÄ,¼´²éѯijһÌìµÄËùÓлáÒéÐÅÏ¢,ÕâÑùÈç¹ûͨ¹ýselect * from Meeting where PublishTime=@PublishTime (²ÎÊý@PublishTimeΪyyyy-mm-dd¸ñʽ)Óï¾ä½øÐвéѯ½«ÎÞ·¨µÃµ½ÕýÈ·½á¹û,±ÈÈçÎÒÃÇÒª²éѯ2004Äê12ÔÂ1ÈյĻáÒéÐÅÏ¢,ÔÚÊäÈë2004-12-01ʱ¾Í²»Äܵõ½²éѯ½á¹û,¶øÕâÖÖ²éѯÓÖ²»ÄÜÒªÇóÊäÈë¾ßÌåµÄhh:mm:ss.
¡¡¡¡´ËʱÎÒÃÇÐèҪʹÓÃconvertº¯Êý,Ëü¿ÉÒÔ½«Ò»ÖÖÊý¾ÝÀàÐ͵ıí´ïʽת»»ÎªÁíÒ»ÖÖÊý¾ÝÀàÐ͵ıí´ïʽ.´Ë´¦ÎÒÃÇÏȽ«Êý¾Ý¿âÄÚµÄdatetimeÀàÐÍת»»ÎªcharÀàÐÍ,ÓÉÓÚÊäÈëµÄ²ÎÊýÊÇ10λµÄ,ËùÒÔд³É
¡¡¡¡select * from Meeting where convert(varchar(10),PublishTime,121))=@PublishTime,ÕâÑùÔÚ²éѯʱÊý¾Ý¿âµÃµ½²ÎÊýºóÏÈ×Ô¶¯½«Êý¾Ý¿âÄÚµÄÐÅϢת»»Îªyyyy-mm-dd¸ñʽµÄ10λ×Ö·û,Ö»ÒªÓë²ÎÊýÏàͬ¼´¿É·µ»Ø²éѯ½á¹û.¶øconvertÖеÄ121ÊÇÖ¸½«datetimeÀàÐÍת»»ÎªcharÀàÐÍʱ»ñµÃ°üÀ¨ÊÀ¼ÍλÊýµÄ4λÄê·Ý
¡¡¡¡ÒÔÉÏÊÇÎÒÔÚ¿ª·¢ÖÐÓöµ½µÄСÀ§ÄѵÄ×ܽá,Èç¹ûдµÄÓв»ÕýÈ·µÄµØ·½»¶Ó­´ó¼ÒÖ¸½Ì!


Ïà¹ØÎĵµ£º

SQL Server ¹ÜÀí³£ÓõÄSQLºÍT SQL

1. ²é¿´Êý¾Ý¿âµÄ°æ±¾  
  select @@version
 
  ³£¼ûµÄ¼¸ÖÖSQL SERVER´ò²¹¶¡ºóµÄ°æ±¾ºÅ:
 
  8.00.194   Microsoft SQL Server 2000
  8.00.384   Microsoft SQL Server 2000 SP1
  8.00.532   Microsoft SQL Server 2000 SP2
  8.00.760 &nb ......

PL/SQL ÖÐÎÄÂÒÂë½â¾ö·½°¸

1. ʹÓõÄÊÇ·þÎñÆ÷Éϵ쬲»ÊDZ¾»úµÄOracle£¬°´ÏÂÃæ×ö¾Í¿ÉÒÔÁË£º
    ÉèÖû·¾³±äÁ¿:NLS_LANG£¬¾ßÌåÖµÓÃÏÂÃæ²éѯµÄÖµ:
SELECT 'AMERICAN_AMERICA.' || PROPERTY_VALUE
from DATABASE_PROPERTIES
WHERE PROPERTY_NAME = 'NLS_CHARACTERSET';
2. Èç¹ûÊDZ¾»úµÄOracle¾ÍÐèÒªÔÚOracleµÄ°²×°Ä¿Â¼ÏÂÃæ¸ÄÉèÖãº
......

[SQL]SQLÐÔÄܵ÷ÓÅ

³õ¼¶Æª —— ¼òµ¥²éѯÓï¾äµÄµ÷ÓÅ ÀîÃ÷»Û , Èí¼þ¹¤³Ìʦ, IBM­
ÀîÃ÷»Û£¬ÔÚ IBM ÖйúÈí¼þ¿ª·¢ÖÐÐÄ Data Studio ÍŶӹ¤×÷´ÓÊ InfoSphere Warehouse Administration Console µÄ¹¦ÄܲâÊÔ¹¤×÷¡£ÔøÔÚ developerWorks ·¢±í¡¶½« DB2 DWE 9.1.X Ç¨ÒÆµ½ DB2 Warehouse 9.5¡·¡¢¡¶InfoSphere Warehouse SQL ²Ö´¢ÃüÁîÐнӿ ......

ʵÏÖ¶àÐкϲ¢Ò»ÐеÄSQL [MSSQL2005]д·¨

--1. ´´½¨±í£¬Ìí¼Ó²âÊÔÊý¾Ý
CREATE TABLE tb(id int, [value] varchar(10))
INSERT tb SELECT 1, 'aa'
UNION ALL SELECT 1, 'bb'
UNION ALL SELECT 2, 'aaa'
UNION ALL SELECT 2, 'bbb'
UNION ALL SELECT 2, 'ccc'
--SELECT * from tb
/**//*
id value
----------- ----------
1 aa
1 bb
2 aaa ......

Java Á¬½Ó SQL Server 2000ʾÀý´úÂë

ÄãµÄSQL Server 2000±ØÐë´òÉÏSP3µÄ²¹,È»ºó°²×°MicrosoftµÄJDBCÇý¶¯,½«ÒÔÏÂÈý¸öjar°ü¸´ÖƵ½WebContent\WEB-INF\lib
msbase.jar
mssqlserver.jar
msutil.jar
ÏÂÃæÊDzâÊÔ´úÂ룬ûÓб¨´íÊý¾Ý¿â¾ÍÄÜÕý³£Á¬½Ó
 public class DbcTest {
/**
* @param args
*/
public static void main(String[] args) {
Str ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ