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

sql´´½¨´¥·¢Æ÷

 create trigger updatemaster                    //´´½¨´¥·¢Æ÷Ãû×ÖÊÇ updatemaster
on votedetails                                           //×÷ÓÃÓÚvotedetailsÕâ¸ö±íÖÐ
for update                                             //Ìõ¼þÊÇ£¬Õâ¸ö±í±»Ö´ÐÐÁË update(¸üÐÂ) ²Ù×÷ºó
as
begin                                                    //¿ªÊ¼Ö´ÐÐÏÂÃæµÄÓï¾ä
   update votemaster set votesum=votesum+1 where voteid=(select top 1 voteid from inserted)
end    


Ïà¹ØÎĵµ£º

SQL¹ÂÁ¢Óû§½â¾ö·½°¸

 ¡¡  Ö¢×´
¡¡¡¡µ±Äú½«Êý¾Ý¿â±¸·Ý»Ö¸´µ½Áíһ̨·þÎñÆ÷ʱ£¬¿ÉÄÜ»áÓöµ½¹ÂÁ¢Óû§µÄÎÊÌâ¡£SQL Server Áª»ú´ÔÊéÖеĹÂÁ¢Óû§ÒÉÄѽâ´ðÖ÷ÌâÖÐûÓн²Êö½â¾ö´ËÎÊÌâµÄ¾ßÌå²½Öè¡£
¡¡¡¡±¾ÎĽéÉÜÁËÈçºÎ½â¾ö¹ÂÁ¢Óû§ÎÊÌâ¡£
¡¡¡¡×´Ì¬
¡¡¡¡Microsoft ÒѾ­È·ÈÏÕâÊÇÔÚ±¾ÎÄ¿ªÍ·ÁгöµÄ Microsoft ²úÆ·ÖдæÔÚµÄÎÊÌâ¡£
¡¡¡¡¸ü¶àÐÅÏ ......

轉SQL Server Ô¶³ÌÁ´½Ó·þÎñÆ÷ÏêϸÅäÖÃ

 Ô¶³ÌÁ´½Ó·þÎñÆ÷ÏêϸÅäÖÃ
--
½¨Á¢Á¬½Ó·þÎñÆ÷
EXEC
sp_addlinkedserver
'
Ô¶³Ì·þÎñÆ÷IP
'
,
'
SQL Server
'
--
±ê×¢´æ´¢
EXEC
sp_addlinkedserver
@server

=

'
server
'
,
--
Á´½Ó·þÎñÆ÷µÄ±¾µØÃû³Æ¡£Ò²ÔÊÐíʹÓÃʵÀýÃû³Æ£¬ÀýÈçMYSERVER\SQL1
@srvproduct

=

'
product_name ......

ʹÓÃSQL SERVERµÄLink ServerʵÏÖ·Ö²¼Ê½ÊÂÎñ

ansi_warningºÍansi_nulls Á½¸öÑ¡Ïî±ØÐë´ò¿ª£¬ºÃÏñ¶ÔϵͳҲûɶӰÏì¡£
 
Â¥Ö÷ÔÙ¼ì²éÒ»ÏÂÁ½¸öµØ·½£¬¾­²âÊÔ£¬ÔÚҪʹÓ÷ֲ¼Ê½ÊÂÎñʱ£¬ÕâÊDZØÐëÒªÉèÖõġ£
1¡¢Á´½Ó·þÎñÆ÷ºÍÃû³Æ½âÎöÎÊÌâ
-- ´´½¨Á´½Ó·þÎñÆ÷
EXEC sp_addlinkedserver 'srv_lnk', 'ms', 'SQLOLEDB', '192.168.1. ......

SQL¸ù¾ÝÒÑÖªµÄÄêÔÂ,¼ÆËã¸ÃÔµÄÌìÊý.

 ±¾ÎÄÊÇÒ»¸ö¼¼ÇÉÎÄÕÂ,½éÉÜSQL¸ù¾ÝÒÑÖªµÄÄêÔÂ,¼ÆËã¸ÃÔµÄÌìÊý.
±¾ÎÄÊÇÒ»¸ö¼¼ÇÉÎÄÕÂ,½éÉÜSQL¸ù¾ÝÒÑÖªµÄÄêÔÂ,¼ÆËã¸ÃÔµÄÌìÊý.
declare   @iDays   int 
declare   @dt   varchar(50) 
set   @dt=@Year+'-'+@Month+'-01'
select @iDays=day(dateadd( ......

±àдSQL²éѯµÄ¹Ø¼ü—SQLÓï¾äµÄÖ´ÐÐ˳Ðò


¡¾ÎÄÕ±êÌâ¡¿±àд
SQL
²éѯµÄ¹Ø¼ü—
SQL
Óï¾äµÄÖ´ÐÐ˳Ðò
¡¾ÎÄÕÂ×÷Õß¡¿Ôø½¡Éú
¡¾×÷ÕßÓÊÏä¡¿
zengjiansheng1@126.com
¡¾×÷Õß
QQ
¡¿
190678908
¡¾×÷Õß
MSN
¡¿
zengjiansheng1@hotmail.com
¡¾×÷Õß²©¿Í¡¿
blog.csdn.net/newjueqi
 
*********************************************************** ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ