Çë°ïæ½âÊÍÒ»ÏÂ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 ÊÇʲôÒâ˼
ÊÇ¿Í»§Á¬½ÓÉÏÄãµÄ»úÆ÷ Õâô³¤µÄʱ¼äÁË
ÊÇ¿Í»§¶ËÓë·þÎñÆ÷¶Ë±£³ÖÁ¬½ÓµÄʱ¼ä
лл~
Ó¦¸ÃÊÇÄãÖ´Ðиùý³ÌµÄʱ¼ä
Ïà¹ØÎÊ´ð£º
ÎÒµÄÊý¾Ý¿âÊǼòÌåsqlserver2000 ,ÎÒÏëÔÚ·±ÌåaccessÏÂÁ¬½Ó,ͨ¹ýodbcÊÇ¿ÉÒÔÁË,µ«ÔÚaccessϳöÏÖ´ò¿ªµÄ±íÈ«ÖÐ"#ÒÑɾ³ý"
²»ÖªµÀÒªÔõô²Ù×÷²Å¿ÉÒÔÓÃACCESS·±ÌåÁ¬½Ó¼òÌåsqlserver2000.лл!!!
´ó¼Ò¶¼ ......
SQL SERVERÄÜ»ñµÃÁ¬½ÓµÄÓû§µÄIPÂð£¿
Ö÷ÒªÏëʵÏÖÒÔÏ£º
Ò»¸öÓû§Á¬½Óµ½Êý¾Ý¿â£¬°ÑÓû§µÄÓû§ÃûÓëIP¶¼±£´æÔÚÊý¾Ý¿âÖУ¬À´ÊµÏÖÓû§µÇ¼µÄ¹¦ÄÜ¡£
×îºÃÊÇÓû§µ÷ÓÃÒ»¸ö´æ´¢¹ý³Ì£¬°ÑÓû§Ãû×÷²ÎÊý£¬´æ´¢¹ý³Ì¾Í ......
ÊÇÕâÑùµÄ£¬ÎÒÓÃÊÇODBCÊý¾ÝÔ´Á¬½Ó·þÎñÆ÷µÄÊý¾Ý¿â£¬ÏÖÔÚÎÒ¾õµÃºÜÂé·³£¬ÒòΪҪΪÿÈç»úÌí¼Ó¶ÔÓ¦µÄÊý¾ÝÔ´£¬Ïë°ÑËû¸Ä³ÉADO·½·¨À´·ÃÎÊ·þÎñÆ÷µÄÊý¾Ý¿âÄÜʵÏÖÂð£¿ÒªÔõôд¡£
±ÈÈç·þÎñÆ÷ÀïÓжþ¸öÊý¾Ý¿âdata1 ºÍdata2£¬¿Í»§ ......
--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´´½¨Óû§Ê±Ä¬ÈϾ͸³ÓèÁËÒ»¸öpublic½ÇÉ«¡£
ÎÒÊÇ·ñ¿ÉÒÔ´´½¨Ò»¸öÓû§£¬ÈÃÕâ¸öÓû§Ö»ÓеǼµÄȨÏÞ£¬Ã»ÓÐÆäËûµÄȨÏÞ£¡
ÎÒµÄÊý¾Ý¿âÊÇSqlServer2000
SQL code:
--Ìí¼ÓµÇ¼ wh1,ÉèÖÃÃÜÂëΪ123,ĬÈÏÊý¾ ......