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

ÊÖ»ú¿ª·¢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»ÖªµÀÔõô½â¾öÕâ¸öÎÊÌ⣬»¹Çë¸÷λ´óÏÀÃǰïæ¡£




..

¡£


лл´ó¼Ò¹Ø×¢


Ïà¹ØÎÊ´ð£º

Çë½ÌSQLSERVERµÄÁ½¸öÎÊÌâ - MS-SQL Server / ÒÉÄÑÎÊÌâ

1¡£ÔõÑùʹxp_cmdshellÄÜÍêÕûÊä³ö³¬¹ý255¸ö×Ö·ûµÄ×Ö·û´®¡£
2¡£select ʱ£¬¼ìË÷ËÙ¶ÈÊÇÓëfromºóµÄ TABLE˳ÐòÓйأ¬»¹ÊÇÓëwhereÌõ¼þµÄ˳ÐòÓйØ(TABLEÊý¾Ý¶àÉÙ )
ÔÚϵͳÊôÐÔÉ趨ÀïÓиöÑ¡Ïî,¿ÉÒÔÐ޸ĵ¥×Ö¶ÎÊä³ö×ÖÊýÏÞÖÆ. ......

sqlserverÊý¾Ý¿âµÄ´óС - MS-SQL Server / »ù´¡Àà

ͬÑùµÄÊý¾Ýsqlserver¾­¹ýÊÕËõ£¬Çå¿ÕÈÕÖ¾ ×îºó´óСÊÇ196M
ÆäÖÐÖ»ÓÐÒ»¸ö±íµÄÊý¾Ý¶àһЩ ´óÔ¼42ÍòÌõÊý¾Ý£¬µ¼³ö³ÉÎı¾ºóÊÐ62M
µ«ÎÒ°ÑÕû¸öÊý¾Ý¿âµ¼³öµ½ASAÊý¾Ý¿âºóÊý¾ÝÎļþÊÇ48M£¬ÈÕÖ¾ÎļþÊÇ40M£¬
Ϊʲô»á²î±ðÕâô´ó£ ......

ado sqlserver ´æ´¢¹ý³Ì - MS-SQL Server / ÒÉÄÑÎÊÌâ

Õâ¸öÀý³ÌÊý¾Ý¿âpubs´æ´¢¹ý³Ìreptq1ÄÜÕýÈ·Ö´ÐУ¬
¸Ä³É×Ô¼ºµÄÊý¾Ý¿âºÍ´æ´¢¹ý³Ì¾Í±¨´í3704£¨Ó¦ÓóÌÐò¶¨Òå»ò¶ÔÏó¶¨Òå´íÎó£©
´æ´¢¹ý³ÌÔÚ²éѯ·ÖÎöÆ÷ÄÜÕýÈ·Ö´ÐУ¬¶øÇÒÒ»Ö±ÔÚÓõģ¬ÕæÊÇÔÎËÀ¡£
Private Sub CommandButton5 ......

C# Ïòsqlserver²åÈëÊý¾ÝÎÊÌâ - .NET¼¼Êõ / C#

C# code:
string strCmd = "SELECT Top 0 * from tabAreaStationData";
SqlDataAdapter sqlAdapter = new SqlDataAdapter(strCmd, sqlCn);
DataTable dt = new DataTable(); ......

¼±¾È£¡£¡£¡£¡sqlserver - .NET¼¼Êõ / C#

ÔÚÒ»¸ö±íͬʱ¸üжàÌõÊý¾Ý ²»ÒªËµÓÃin
¸÷λ´óϺ°ï°ïæ
ʲôÒâ˼?ÐèҪʲôÌõ¼þ?²»ÐèÒªÌõ¼þÄǾÍÖ±½Ó¸üÐÂßÂ
update xxx set yyy=zzz

Ò»´ÎUpdateÓï¾ä£¬Ö»ÄܸüÐÂÒ»¸ö£¬ÒªÃ´¶à´ÎUpdate,Ҫôдһ¸ö´æ´¢¹ý³Ì£¬´æ´¢¹ý³Ì ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ