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
Ïà¹ØÎĵµ£º
Ò»¡¢¹ØÓÚCREATE TABLE tab1 (×Ö¶ÎÃû TEXT)ÖУ¬×Ö¶ÎÃûΪ“a.a.a»òa.a.b”ʱ£¬Ìáʾ£º
“×ֶζ¨ÒåÓï·¨´íÎó”
´ð£ºÔÚ×Ö¶ÎÃû×ÖÍâÃæ¼ÓÉÏ“[ ]”¾Í¿ÉÒÔÁË£¡
¶þ¡¢´´½¨Ò»¸öÒÔListCtrlµÚÒ»ÁÐΪEXCELµÚÒ»Ðеıí½á¹¹ ºÍ ²åÈëÒ»¸öÒÔListCtrlµÚNÁÐΪEXCELµÚ¶þÐеıí½á¹¹
  ......
ansi_warningºÍansi_nulls Á½¸öÑ¡Ïî±ØÐë´ò¿ª£¬ºÃÏñ¶ÔϵͳҲûɶӰÏì¡£
Â¥Ö÷ÔÙ¼ì²éÒ»ÏÂÁ½¸öµØ·½£¬¾²âÊÔ£¬ÔÚҪʹÓ÷ֲ¼Ê½ÊÂÎñʱ£¬ÕâÊDZØÐëÒªÉèÖõġ£
1¡¢Á´½Ó·þÎñÆ÷ºÍÃû³Æ½âÎöÎÊÌâ
-- ´´½¨Á´½Ó·þÎñÆ÷
EXEC sp_addlinkedserver 'srv_lnk', 'ms', 'SQLOLEDB', '192.168.1. ......
±¾ÎÄÑÝʾÁË SQL Server 2005 ·ÖÇø±í·ÖÇøÇл»µÄÈýÖÖÐÎʽ£º
1. Çл»·ÖÇø±íµÄÒ»¸ö·ÖÇøµ½ÆÕͨÊý¾Ý±íÖУºPartition to Table£»
2. Çл»ÆÕͨ±íÊý¾Ýµ½·ÖÇø±íµÄÒ»¸ö·ÖÇøÖУºTable to Partition£»
3. Çл»·ÖÇø±íµÄ·ÖÇøµ½ÁíÒ»·ÖÇø±í£ºPartition to Partition¡£
²¢Ö¸³öÁËÔÚ·ÖÇø±í·ÖÇøÇл»¹ý³ÌÖеÄ×¢ÒâÊÂÏî¡£
-- ´´½¨·ÖÇøº¯Ê ......
ʲôÊÇÊý¾Ý¿â·ÖÇø£¿
Êý¾Ý¿â·ÖÇøÊÇÒ»ÖÖ¶Ô±íµÄºáÏò·Ö¸î£¬Sql server 2005ÆóÒµ°æºÍÖ®ºóµÄSql server°æ±¾²ÅÌṩÕâÖÖ¼¼Êõ£¬ÕâÖÖ¶Ô±íµÄºáÏò·Ö¸î²»Í¬ÓÚ2000Öеıí·Ö¸î£¬Ëü¶Ô·ÃÎÊÓû§ÊÇ͸Ã÷µÄ£¬Óû§²¢²»»á¸Ð¾õµÄ±í±»ºáÏò·Ö¸îÁË¡££¨2000ÖеıíºáÏò·Ö¸îÊǽ¨n¸ö±íÀýÈ簴ʱ¼ä½¨±íÿÔÂÒ»¸ö±í£¬±íÃû²»Í¬£¬×îºóÐèÒª×öÒ»¸ö´óÊÓͼ£©
Ϊʲ ......
¶¨Òå±êÁ¿±äÁ¿Óï·¨
ÔÚPL/SQLÓï¿éÖж¨Òå±äÁ¿ºÍ³£Á¿µÄÓï·¨ÈçÏÂ
indentifier [CONSTANT] datatype [NOT NULL] [:=|DEFAULT expr]
indentifier ÓÃÓÚÖ¸¶¨±äÁ¿»ò³£Á¿µÄÃû³Æ
CONSTANT:ÓÃÓÚÖ¸¶¨³£Á¿¡£µ±¶¨Òå³£Á¿Ê±£¬±ØÐëÖ¸¶¨ËüµÄ³õʼֵ£¬²¢ÇÒÆäÊýÖµ²»Äܸıä
datatype£ºÓÃÓÚÖ¸¶¨±äÁ¿»ò³£Á¿µÄÊý¾ÝÀàÐÍ¡£
NOT NULL£º ÓÃÓÚÇ¿ ......