ÊÖ»ú¿ª·¢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 ......
ÒÔÏ´úÂëÊÇÌí¼ÓÊý¾Ý°´Å¥µÄ´úÂ룬Ïë°Ñtestid£¬ºÍtestnameÁ½¸ötxt´«µÝµ½Êý¾Ý¿âÖÐ
Êý¾Ý¿âÁ¬½Ó¿Ï¶¨Ã»ÎÊÌâ
¾ÍÊǺìÉ«²¿·ÖÀϱ¨´í
²»ÖªµÀΪʲô-£¬-
Çë¸÷λ¸ßÈ˰ïæ¿´¿´£¡
лл£¡
Java code:
private void new ......
±¾ÈËÍü¼ÇÁËsaµÄÃÜÂë¡£
ÔÚ¡°°²È«ÐÔ¡±¡ú¡°µÇ¼¡±¡ú¡°saÊôÐÔ¡±¸ü¸ÄÃÜÂëÖ®ºó,ÔÚÖØÐµÇ½¡£
µÇ¼ʧ°Ü¡£
ÓÃwindowsÓû§µÇ½
´úÂë¸ü¸Ä£ºsp_password Null,'123456','sa' »¹ÊÇ
µÇ¼ʧ°Ü¡£
ÔÚ¡°·þÎñ¡±¡ú¡°ÊôÐÔ¡±¡ú¡°µ ......
sqlserverµÄ´æ´¢¹ý³ÌÓÐoracleµÄÄÇÖÖ°üµÄ¸ÅÄîô£¿
¾ÍÊǺܶà¸öÂß¼ÉÏÓÐÁªÏµµÄ´æ´¢¹ý³ÌÊÇ¿ÉÒÔ·ÅÔÚÒ»¸öpackageÀïÃæµÄ£¿
oracle²»¶®¡£
Ã»Íæ¹ýOµÄ£¬°ï¶¥¡£
ÄÇsqlserver µÄ´æ´¢¹ý³Ì¾ÍÊÇÒ»¸ö¸öµ¥¶ÀµÄÈ«²¿ÁÐÔÚ¡°´æ´¢¹ ......
SQLSERVER ÎÒÓÐÒ»¸ö±í£¬²é³öÀ´µÄÒ»¸ö×Ö¶ÎÊÇ×Ö·û´®±í´ïʽ
±ÈÈç
a b c 5*6-3
a be ce 15*(6-3)
a b c 36-3
a be ce 1*(9-8)
ÎÒÏëÔڴ˺óÃæÔö ......