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

eclipse ¹ØÁª sql server µÄJDBCÎÊÌâ

eclipse ¹ØÁª sql server µÄJDBCÎÊÌâ
±à³ÌÔËÐкóÌáʾ£º
java.lang.ClassNotFoundException: com.microsoft.jdbc.sqlserver.SQLServerDriver
ÉÏÍø²éÁË£¬ÓеÄ˵ÔÚ»·¾³±äÁ¿ÀïµÄclasspathÌí¼Ó JDBCÀïµÄ3¸öjarÎļþ¾Í¿ÉÒÔ£¬µ«ÊÇʹÓúó»¹ÊDz»ÐС£
ºóÀ´²ÅÖªµÀ½â¾ö·½·¨£º
°ü×ÊÔ´¹ÜÀíÆ÷-->°üÃûÓÒ¼ü"¹¹½¨Â·¾¶"-->ÅäÖù¹½¨Â·¾¶-->java¹¹½¨Â·¾¶-->¿â-->Ìí¼ÓÍⲿJAR
°ÑÄÇÈý¸öJARÑ¡Ôñ½øÈ¥¾Í¿ÉÒÔÁË.
           
Ìí¼ÓºóÈý¸öJDBCÎļþ¾ÍÓÐÁË.
               


Ïà¹ØÎĵµ£º

SQLÀúÊ·ÓëʵÏÖ

 
ÔÚ20ÊÀ¼Í70Äê´ú³õÆÚ£¬IBMÑо¿Ô±E. F. Codd²©Ê¿¿ª´´ÐÔµØÑо¿¿ª·¢Á˹ØÏµÊý¾ÝÄ£ÐͲúÆ·SEQUEL£¬¼´½á¹¹»¯Ó¢Óï²éѯÓïÑÔ£¨Structured English Query Language£©¡£SEQUEL×îÖÕ±ä³ÉÁËSQL£¬»ò½á¹¹»¯²éѯÓïÑÔ£¨Structured Query Language£¬SQL£©¡£
IBM¼°ÆäËû¹ØÏµÊý¾Ý¿âµÄ¿ª·¢³§É̶¼Ï£ÍûÓÐÒ»Ì×ÄÜ·ÃÎʲ¢²Ù×ݹØÏµÊý¾Ý¿âµÄ±ê×¼»¯·½ ......

sql server 2005°²×°¹ý³ÌÖÐÓöµ½µÄһЩÎÊÌâ

°²×°µÄ×é¼þºÍ°æ±¾µÄÐÅÏ¢
Microsoft SQL Server Management Studio      9.00.1399.00
Microsoft Analysis Services ¿Í»§¶Ë¹¤¾ß      2005.090.1399.00
Microsoft Êý¾Ý·ÃÎÊ×é¼þ (MDAC)      6.1.7600.16385 (win7_rtm.090713 ......

SQL Server

²éѯ card µÄ¼Ç¼ΪÁ½´ÎÒÔÉ쵀 card£¬¼Ç¼Êý:
select count(card), card from TableName group by card having count(card) > 1
¼¶Áª¸üУ¬¼¶ÁªÉ¾³ý:
ColumnName type not null constraint FK_Name foreign key(ColumnName) references PrimaryTable(ColumnName) on update/delete cascade
×Ô¶¯¼ÆËãÁÐ:
create tabl ......

ÔÚSQLÖÐʹÓÃnow()µ¼ÖµÄÐÔÄÜϽµ(MySQL)

×öÊý¾Ý¿âµ÷ÓÅ£¬Ò»¸ö¼òµ¥µÄtip¾ÍʹÐÔÄÜÌáÉýÒ»´ó¿éʱ£¬±»°ïÖúµÄÈË×ÔÈ»ÊǸßÐ˶øÇҸм¤£¬ÎÒÒ²ÊÇÂúÐÄ»¶Ï²¡£ÓÃËùѧ°ïÖúÁËËûÈË£¬Ò²ËµÃ÷»¹ÊÇÓÐÒ»¼¼Ö®³¤µÄ£¬ÓÐÒ»ÃÅÄܹ»Ñø»î×Ô¼ºµÄÊÖÒÕ¡£Ò²ËãÊÇÊÖÒÕÈ˰¡¡£
ͬÊÂÈÃÎÒ°ïÖúÓÅ»¯£¬ÔÚslow query logÀï·¢ÏÖÓÐÁ½¸öSQLÖ´ÐеĴÎÊý×î¶à£¬²¢ÇÒÿ´Î¶¼ÔÚÁ½ÃëÒÔÉÏ¡£ÓÃexplain¿´ÁË£¬Ò²Î´·¢ÏÖË÷ÒýʹÓ÷ ......

liq to sql union

Union All/Union/Intersect²Ù×÷
ÊÊÓó¡¾°£º¶ÔÁ½¸ö¼¯ºÏµÄ´¦Àí£¬ÀýÈç×·¼Ó¡¢ºÏ²¢¡¢È¡ÏàͬÏî¡¢ÏཻÏîµÈµÈ¡£
Concat£¨Á¬½Ó£©
˵Ã÷£ºÁ¬½Ó²»Í¬µÄ¼¯ºÏ£¬²»»á×Ô¶¯¹ýÂËÏàͬÏÑÓ³Ù¡£
1.¼òµ¥ÐÎʽ£º
var q = (
from c in db.Customers
select c.Phone
).Concat(
from c in db.Customers
......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ