Çë°ïæ½âÊÍÒ»ÏÂ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 ÊÇʲôÒâ˼
Êǿͻ§Á¬½ÓÉÏÄãµÄ»úÆ÷ Õâô³¤µÄʱ¼äÁË
Êǿͻ§¶ËÓë·þÎñÆ÷¶Ë±£³ÖÁ¬½ÓµÄʱ¼ä
лл~
Ó¦¸ÃÊÇÄãÖ´Ðиùý³ÌµÄʱ¼ä
Ïà¹ØÎÊ´ð£º
ÐèҪʹÓÃSQL Server2000»ò2005
ÐèÒªÉè¼ÆÊý¾ÝÓÐЧÑéÖ¤,·Àֹ¼Èë²»ºÏ·¨Êý¾Ý
ÐèÒªÉè¼Æ´æ´¢¹ý³Ì»ò×Ô¶¨Ò庯ÊýÍê³ÉÊý¾ÝµÄ¼Èë\ÐÞ¸Ä\ɾ³ý\ͳ¼Æ\²éѯ
Êý¾Ý¿â´ó²¿·Ö±íÎÒÒѾ½¨Á¢,Ö»ÊǸ¨ÖúÐÔµÄС±í½¨Á¢µÄ»¹²»È«
......
SqlServerÀïÒÑÓÐÒ»¸ö±í¸ñ×Ö¶ÎΪAºÍB£¬
excelÀïµÄÊý¾ÝÈçÏÂ
ÈçͼËùʾ£¬ÓÐһЩµ¥Ôª¸ñÊǺϲ¢µÄ£¬ÕâÖÖÇé¿öÒªÈçºÎдSQL°¡
×Ô¼º¶¥Ï£¡
ÕâÑù²»ÐаÉ
°ÑºÏ²¢µÄ¸ø·Ö¿ª°É
SQL code:
SELECT *
fro ......
SqlServer´´½¨Óû§Ê±Ä¬ÈϾ͸³ÓèÁËÒ»¸öpublic½ÇÉ«¡£
ÎÒÊÇ·ñ¿ÉÒÔ´´½¨Ò»¸öÓû§£¬ÈÃÕâ¸öÓû§Ö»ÓеǼµÄȨÏÞ£¬Ã»ÓÐÆäËûµÄȨÏÞ£¡
ÎÒµÄÊý¾Ý¿âÊÇSqlServer2000
SQL code:
--Ìí¼ÓµÇ¼ wh1,ÉèÖÃÃÜÂëΪ123,ĬÈÏÊý¾ ......
C# code:
//Ôö¼ÓÒ»ÌõÊý¾Ý¡£¡£¡£¡£¡£
public int AddAdmin(string UID, string PWD)
{
string sql = "insert into Admin(_uid,_pwd)values(@UID,@PWD)";
SqlParameter[] p ......