Ò׽ؽØͼÈí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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 ÊÇʲôÒâ˼

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

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

лл~

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


Ïà¹ØÎÊ´ð£º

ACCESS·±ÌåÁ¬½Ó¼òÌåsqlserver2000

  ÎÒµÄÊý¾Ý¿âÊǼòÌåsqlserver2000 ,ÎÒÏëÔÚ·±ÌåaccessÏÂÁ¬½Ó,ͨ¹ýodbcÊÇ¿ÉÒÔÁË,µ«ÔÚaccessϳöÏÖ´ò¿ªµÄ±íÈ«ÖÐ"#ÒÑɾ³ý"
²»ÖªµÀÒªÔõô²Ù×÷²Å¿ÉÒÔÓÃACCESS·±ÌåÁ¬½Ó¼òÌåsqlserver2000.лл!!!
´ó¼Ò¶¼ ......

SQLSERVERÄÜ»ñµÃÁ¬½ÓµÄÓû§µÄIPÂð£¿

SQL SERVERÄÜ»ñµÃÁ¬½ÓµÄÓû§µÄIPÂð£¿

Ö÷ÒªÏëʵÏÖÒÔÏ£º
Ò»¸öÓû§Á¬½Óµ½Êý¾Ý¿â£¬°ÑÓû§µÄÓû§ÃûÓëIP¶¼±£´æÔÚÊý¾Ý¿âÖУ¬À´ÊµÏÖÓû§µÇ¼µÄ¹¦ÄÜ¡£
×îºÃÊÇÓû§µ÷ÓÃÒ»¸ö´æ´¢¹ý³Ì£¬°ÑÓû§Ãû×÷²ÎÊý£¬´æ´¢¹ý³Ì¾Í ......

ado·ÃÎÊÔ¶³ÌÊý¾Ý¿â(Ô¶³Ì·ÃÎÊsqlserver)

ÊÇÕâÑùµÄ£¬ÎÒÓÃÊÇODBCÊý¾ÝÔ´Á¬½Ó·þÎñÆ÷µÄÊý¾Ý¿â£¬ÏÖÔÚÎÒ¾õµÃºÜÂé·³£¬ÒòΪҪΪÿÈç»úÌí¼Ó¶ÔÓ¦µÄÊý¾ÝÔ´£¬Ïë°ÑËû¸Ä³ÉADO·½·¨À´·ÃÎÊ·þÎñÆ÷µÄÊý¾Ý¿âÄÜʵÏÖÂð£¿ÒªÔõôд¡£
±ÈÈç·þÎñÆ÷ÀïÓжþ¸öÊý¾Ý¿âdata1 ºÍdata2£¬¿Í»§ ......

--oracle ´¥·¢Æ÷£¬×ª sqlserver ÎÊÌâ

--oracle ´¥·¢Æ÷£¬×ª sqlserver ÎÊÌâ
CREATE OR REPLACE TRIGGER TG_BU_TSTK_IMPORTITEM
BEFORE UPDATE ON TSTK_IMPORTITEM
FOR EACH ROW
DECLARE
VAR_LIBGOODCOUNT NUMERIC(12,2);
BEGIN ......

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

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

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

SQL code:
--Ìí¼ÓµÇ¼ wh1,ÉèÖÃÃÜÂëΪ123,ĬÈÏÊý¾ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ