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

Çë°ïæ½âÊÍÒ»ÏÂsqlserver¿Í»§¶Ëͳ¼ÆµÄÐÅÏ¢

ÏÂÃæÊÇÎÒµÄͳ¼ÆÐÅÏ¢£º

¿Í»§¶ËÖ´ÐÐʱ¼ä 10:28:48
²éѯÅäÖÃÎļþͳ¼ÆÐÅÏ¢
  INSERT¡¢DELETE ºÍ UPDATE Óï¾äµÄÊýÄ¿ 0 0.0000
  INSERT¡¢DELETE »ò UPDATE Óï¾äÓ°ÏìµÄÐÐÊý 0 0.0000
  SELECT Óï¾äµÄÊýÄ¿ 1 1.0000
  SELECT Óï¾ä·µ»ØµÄÐÐÊý 264 264.0000
  ÊÂÎñÊý 0 0.0000
ÍøÂçͳ¼ÆÐÅÏ¢
  ·þÎñÆ÷Íù·µµÄ´ÎÊý 1 1.0000
  ´Ó¿Í»§¶Ë·¢Ë굀 TDS Êý¾Ý°ü 1 1.0000
  ´Ó·þÎñÆ÷½ÓÊÕµÄ TDS Êý¾Ý°ü 9 9.0000
  ´Ó¿Í»§¶Ë·¢Ë͵Ä×Ö½ÚÊý 90 90.0000
  ´Ó·þÎñÆ÷½ÓÊÕµÄ×Ö½ÚÊý 35554 35554.0000
ʱ¼äͳ¼ÆÐÅÏ¢
  ¿Í»§¶Ë´¦Àíʱ¼ä 31 31.0000
  ×ÜÖ´ÐÐʱ¼ä 1421 1421.0000
  ·þÎñÆ÷Ó¦´ðµÈ´ýʱ¼ä 1390 1390.0000


ÇëÎÊ´ó¼Ò ¿Í»§¶ËÖ´ÐÐʱ¼ä 10:28:48 ÊÇʲôÒâ˼£¬ÊÇÓÃÁË10СʱÂ𣿻¹ÊÇָʲô£¿
»¹ÓÐ×îÏÂÃæµÄ

¿Í»§¶Ë´¦Àíʱ¼ä 31 31.0000
  ×ÜÖ´ÐÐʱ¼ä 1421 1421.0000
  ·þÎñÆ÷Ó¦´ðµÈ´ýʱ¼ä 1390 1390.0000

Ó¦¸ÃÊÇÖ¸ºÁÃë°É£¿



ÄĸöµØ·½µÄͳ¼Æ?¿´²»Ã÷°×.

¿Í»§¶ËÖ´ÐÐʱ¼ä 10:28:48 ÊÇʲôÒâ˼

Êǿͻ§Á¬½ÓÉÏÄãµÄ»úÆ÷ Õâô³¤µÄʱ¼äÁË

Êǿͻ§¶ËÓë·þÎñÆ÷¶Ë±£³ÖÁ¬½ÓµÄʱ¼ä

лл~

Ó¦¸ÃÊÇÄãÖ´Ðиùý³ÌµÄʱ¼ä


Ïà¹ØÎÊ´ð£º

Óг¥ÇósqlserverÊý¾Ý¿âÉè¼Æ:ÓÐÏßµçÊÓ

ÐèҪʹÓÃSQL Server2000»ò2005
ÐèÒªÉè¼ÆÊý¾ÝÓÐЧÑéÖ¤,·Àֹ¼Èë²»ºÏ·¨Êý¾Ý
ÐèÒªÉè¼Æ´æ´¢¹ý³Ì»ò×Ô¶¨Ò庯ÊýÍê³ÉÊý¾ÝµÄ¼Èë\ÐÞ¸Ä\ɾ³ý\ͳ¼Æ\²éѯ

Êý¾Ý¿â´ó²¿·Ö±íÎÒÒѾ­½¨Á¢,Ö»ÊǸ¨ÖúÐÔµÄС±í½¨Á¢µÄ»¹²»È« ......

Çó½«EXCELÀïµÄÊý¾Ýµ¼Èëµ½SqlServerµÄsqlÓï¾ä

SqlServerÀïÒÑÓÐÒ»¸ö±í¸ñ×Ö¶ÎΪAºÍB£¬
excelÀïµÄÊý¾ÝÈçÏÂ

  ÈçͼËùʾ£¬ÓÐһЩµ¥Ôª¸ñÊǺϲ¢µÄ£¬ÕâÖÖÇé¿öÒªÈçºÎдSQL°¡
×Ô¼º¶¥Ï£¡

ÕâÑù²»ÐаÉ
°ÑºÏ²¢µÄ¸ø·Ö¿ª°É

SQL code:
SELECT *
fro ......

¡¾ÇóÖú¡¿sqlserver¿ÉÒÔ´´½¨Ö»ÓеǼȨÏÞµÄÓû§Âð

SqlServer´´½¨Óû§Ê±Ä¬ÈϾ͸³ÓèÁËÒ»¸öpublic½ÇÉ«¡£
ÎÒÊÇ·ñ¿ÉÒÔ´´½¨Ò»¸öÓû§£¬ÈÃÕâ¸öÓû§Ö»ÓеǼµÄȨÏÞ£¬Ã»ÓÐÆäËûµÄȨÏÞ£¡

ÎÒµÄÊý¾Ý¿âÊÇSqlServer2000

SQL code:
--Ìí¼ÓµÇ¼ wh1,ÉèÖÃÃÜÂëΪ123,ĬÈÏÊý¾ ......

vs Á¬½Ó sqlserver ²åÈëÊý¾Ý´úÂë¡¢¡¢¡¢¡¢¡¢Çó¾È

C# code:

//Ôö¼ÓÒ»ÌõÊý¾Ý¡£¡£¡£¡£¡£
public int AddAdmin(string UID, string PWD)
{
string sql = "insert into Admin(_uid,_pwd)values(@UID,@PWD)";
SqlParameter[] p ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ