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

ÈçºÎͬʱÁ¬½ÓÁ½¸ö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


ÎÒÒ²ÊÇÕâôдµÄ£¬ÄѵÀ¾ÍûÓбðµÄ°ì·¨À


Ïà¹ØÎÊ´ð£º

ÔÚÖ¸¶¨µÄλÖò»´æÔÚÓÐЧµÄSQLServer°²×°

°²×°SQLServer2000¸öÈ˰棬µ½¡°°²×°ÀàÐÍ¡±½çÃ棬²»¹ÜÑ¡ÔñʲôѡÏ²»¹ÜÓÃĬÈÏ·¾¶»¹ÊÇ×Ô¶¨Òå·¾¶£¬µã»÷ÏÂÒ»²½£¬¶¼µ¯³ö¡°ÔÚÖ¸¶¨µÄλÖò»´æÔÚÓÐЧµÄSQLServer°²×°—C:\Program Files\Microsoft SQL Server¡±µÄ¶Ô ......

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

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

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

--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 ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ