ÈçºÎͬʱÁ¬½ÓÁ½¸ösqlserverÊý¾Ý¿â
ÈçºÎͬʱÁ¬½ÓÁ½¸ösqlserverÊý¾Ý¿â
×öÁ½¸öÊý¾Ý¿âÁ¬¾Í¿ÉÒÔÁËÒýÓà ÈçºÎͬʱÁ¬½ÓÁ½¸ösqlserverÊý¾Ý¿â ÊÇÈçºÎÁ¬½Ó¡£ End_rbody_60474109//--> ¸Ã»Ø¸´ÓÚ2009-10-19 10:39:55±»¹ÜÀíԱɾ³ý ¶ÔÎÒÓÐÓÃ[0] ¶ª¸ö°åש[0] ÒýÓà ¾Ù±¨ ¹ÜÀí TOP ayouori µÈ¡¡¼¶£º #4Â¥ µÃ·Ö£º10»Ø¸´ÓÚ£º2009-10-17 08:54:04 Ö»ÒªÁ¬½Ó¶ÔÏñÃû×Ö²»Ò»Ñù¾ÍÐÐÁË,¶àÉÙ¸öÊý¾Ý¿â¶¼¿ÉÒÔ,²»Í¬ÀàÐ͵ÄÊý¾ÝÒ²ÐÐ. ±ÈÈç VBScript code: set conn1=server.createobject("ADODB.connection") connstr="Driver={SQL Server};Server=zy;Database=Êý¾Ý¿âÒ»;Uid=sa;Pwd=sa;" conn1.open connstr set conn2=server.createobject("ADODB.connection") connstr="Driver={SQL Server};Server=zy;Database=Êý¾Ý¿â¶þ;Uid=sa;Pwd=sa;" conn2.open connstr Ö»ÒªÁ¬½ÓÃû²»Ò»Ñù¾Íok£¬´úÂ룬¥ÉÏÕý½â£¡ set conn1=server.createobject("ADODB.connection") connstr="Driver={SQL Server};Server=zy;Database=Êý¾Ý¿âÒ»;Uid=sa;Pwd=sa;" conn1.open connstr set conn2=server.createobject("ADODB.connection") connstr2="Driver={SQL Server};Server=zy;Database=Êý¾Ý¿â¶þ;Uid=sa;Pwd=sa;" conn2.open connstr2 ÎÒÒ²ÊÇÕâôдµÄ£¬ÄѵÀ¾ÍûÓбðµÄ°ì·¨À
Ïà¹ØÎÊ´ð£º
°²×°SQLServer2000¸öÈ˰棬µ½¡°°²×°ÀàÐÍ¡±½çÃ棬²»¹ÜÑ¡ÔñʲôѡÏ²»¹ÜÓÃĬÈÏ·¾¶»¹ÊÇ×Ô¶¨Òå·¾¶£¬µã»÷ÏÂÒ»²½£¬¶¼µ¯³ö¡°ÔÚÖ¸¶¨µÄλÖò»´æÔÚÓÐЧµÄSQLServer°²×°—C:\Program Files\Microsoft SQL Server¡±µÄ¶Ô ......
ÐèҪʹÓÃSQL Server2000»ò2005 ÐèÒªÉè¼ÆÊý¾ÝÓÐЧÑéÖ¤,·Àֹ¼Èë²»ºÏ·¨Êý¾Ý ÐèÒªÉè¼Æ´æ´¢¹ý³Ì»ò×Ô¶¨Ò庯ÊýÍê³ÉÊý¾ÝµÄ¼Èë\ÐÞ¸Ä\ɾ³ý\ͳ¼Æ\²éѯ Êý¾Ý¿â´ó²¿·Ö±íÎÒÒѾ½¨Á¢,Ö»ÊǸ¨ÖúÐÔµÄС±í½¨Á¢µÄ»¹²»È«
......
--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
......