ÊÖ»ú¿ª·¢sqlserver ´´½¨·¢²¼
ÎÒÔÚѧϰʹÓÃSQL Server Compact Edition´´½¨Òƶ¯Ó¦ÓóÌÐò£¬¿ÉÊÇÔÚÊý¾Ý¿â´´½¨·¢²¼µÚÒ»²½Ê±Ìáʾ´íÎóÈçÏ£º
There are no publications to which you subscribe,either because this server has no publications or because you do not have sufficient privileges to access the publications.
Õâ¶ÎÓ¢ÎÄÎÒ¿ÉÒÔ¿´¶®£¬µ«ÊDz»ÖªµÀÔõô½â¾öÕâ¸öÎÊÌ⣬»¹Çë¸÷λ´óÏÀÃǰïæ¡£
..
¡£
лл´ó¼Ò¹Ø×¢
Ïà¹ØÎÊ´ð£º
import java.sql.Connection;
import java.sql.Date;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
public class QueryTest&n ......
ÔÚÊý¾Ý¿âÖÐÓÐÕÅ±í£¬ÓÐid,nameÁ½ÁУ¬id ÊÇÖ÷¼ü,ûÓÐÉèÖÃ×ÔÔöÊôÐÔ,ÔÚ³ÌÐòÖÐÈ¡³öÕâÕűí·ÅÈëdatatable£¬ÔÚÕâ¸ödatatableÖвåÈëÒ»Ìõ¼Ç¼£¬µ±¸üÐÂÊý¾Ý¿âʱÌáʾidÁв»ÄÜΪ¿Õ£¬ÇëÎʸÃÔõô½â¾ö£¿
¸øËüÒ»¸öÖµ£¡£¡Ö÷¼ü²»ÄÜΪ¿Õ ......
ÓÐÈËÊÔ¹ýÔÚwin7Éϰ²×°sqlserverÂð£¿
Ìý˵sql2000×°²»ÉÏÈ¥£¬²»ÖªµÀÆäËû°æ±¾Ðв»ÐС£
ºÃÏñ²»ÐÐ,²»¼æÈÝ,ÉÏ´ÎÒ²ÓÐÈËÎʹýѽ
ºÇºÇ£¬ÓÐÍøÓÑÓÐÏà¹ØµÄ¾ÑéÂð£¿
Õâ¸ösqlserverÒª¾¡Á¿×°ÔÚwin7ÉÏ¡£
SQLSERVER 2000Ã ......
ͬÑùµÄÊý¾Ýsqlserver¾¹ýÊÕËõ£¬Çå¿ÕÈÕÖ¾ ×îºó´óСÊÇ196M
ÆäÖÐÖ»ÓÐÒ»¸ö±íµÄÊý¾Ý¶àһЩ ´óÔ¼42ÍòÌõÊý¾Ý£¬µ¼³ö³ÉÎı¾ºóÊÐ62M
µ«ÎÒ°ÑÕû¸öÊý¾Ý¿âµ¼³öµ½ASAÊý¾Ý¿âºóÊý¾ÝÎļþÊÇ48M£¬ÈÕÖ¾ÎļþÊÇ40M£¬
Ϊʲô»á²î±ðÕâô´ó£ ......
±íA
id name time
1 '¶¼ÊÇ' 2010-03-22 00:42:47.293
2 '¶¼ÊÇ' 2010-04-22 00:43:33.187
3 '¶¼ÊÇ' 2010-04-23 00:43:37.280
4 '¶¼ÊÇ' 2010-05-22 00:43:39.450
5 '¶¼ÊÇ' 2010-06-22 00:43:40.543
6 '¶¼ÊÇ' ......