ÔÚSQL Server 2005ÖÐʵÏÖÒì²½´¥·¢Æ÷¼Ü¹¹
ÔÚSQL Server 2005Êý¾Ý¿âÖУ¬Í¨¹ýÐÂÔöµÄService Broker¿ÉÒÔʵÏÖÒì²½´¥·¢Æ÷µÄ´¦Àí¹¦ÄÜ¡£±¾ÎÄÌṩһÖÖʹÓÃService BrokerʵÏÖµÄͨÓÃÒì²½´¥·¢Æ÷·½·¨¡£
ÔÚ±¾Õâ¸ö·½·¨ÖУ¬Í¨¹ýService Broker¹¹ÔìÒì²½´¥·¢Æ÷´¦Àí¼Ü¹¹£¬¶ÔÓÚҪʹÓÃÕâÖּܹ¹µÄ±í£¬Ö»ÐèÒª´´½¨ÏàÓ¦µÄ´¥·¢Æ÷¼°´¦Àí´¥·¢Æ÷ÖÐÊý¾ÝµÄ´æ´¢¹ý³Ì£¬²¢ÇÒÔÚÒì²½´¥·¢Æ÷¼Ü¹¹ÖеǼǴ¥·¢Æ÷ºÍ´¦ÀíµÄ´æ´¢¹ý³Ì¼´¿É¡£Èç¹ûÒ»¸ö´¥·¢Æ÷ÖеÄÊý¾ÝÒª±»¶à¸ö±íʹÓã¬Ö»ÐèÒªÔÚdbo.tb_async_trigger_subscribtionÖеǼÇÏàÓ¦´¦ÀíÊý¾ÝµÄ´æ´¢¹ý³Ì¼´¿É£¬¼´Ò»¸ö±íµÄÊý¾Ý±ä¸ü¿ÉÒÔ±»¶à¸ö±í¶©ÔÄ£¨Ê¹Óã©¡£
¼Ü¹¹µÄ²½ÖèÈçÏ£º
1£® Êý¾Ý¿âÅäÖÃ
ÐèÒªÅäÖÃÊý¾Ý¿âÒÔÔÊÐíʹÓÃService Broker¡£±¾ÎÄÒÔtempdb¿âΪÀý£¬¹ÊÅäÖþùÔÚtempdbÉÏÏÂÎÄÖнøÐС£
USE tempdb
GO
-- ÔÊÐíService Broker
ALTER DATABASE tempdb SET
ENABLE_BROKER
GO
2£® ¹¹½¨Òì²½´¥·¢Æ÷Ïà¹ØµÄ¶ÔÏó
ÏÂÃæµÄT-SQL´´½¨Òì²½´¥·¢Æ÷´¦Àí¼Ü¹¹Ïà¹ØµÄ¶ÔÏó¡£
-- =======================================
-- Òì²½´¥·¢Æ÷¶ÔÏó
-- 1. service broker ¶ÔÏó
-- =======================================
-- a. message type, ÒªÇóʹÓÃxml ´«µÝÊý¾Ý
CREATE MESSAGE TYPE MSGT_async_trigger
VALIDATION = WELL_FORMED_XML
GO
-- b. Ö»ÐèÒª·¢ËÍÏûÏ¢
CREATE CONTRACT CNT_async_trigger(
MSGT_async_trigger SENT BY INITIATOR)
GO
-- c. ´æ´¢ÏûÏ¢µÄ¶ÓÁÐ
CREATE QUEUE dbo.Q_async_trigger
GO
-- d. ÓÃÓÚÏûÏ¢´¦ÀíµÄ·þÎñ
CREATE SERVICE SRV_async_trigger
ON QUEUE dbo.Q_async_trigger(
CNT_async_trigger)
GO
-- =======================================
-- Òì²½´¥·¢Æ÷¶ÔÏó
-- 2. Òì²½´¥·¢Æ÷´¦ÀíµÄ¶ÔÏó
-- =======================================
-- a. µÇ¼ÇÒì²½´¥·¢Æ÷µÄ±í
CREATE TABLE dbo.tb_async_trigger(
ID int IDENTITY
PRIMARY KEY,
table_name sysname,
trigger_name sysname
)
-- b. µÇ¼Ç¶©ÔÄÒì²½´¥·¢Æ÷µÄ´æ´¢¹ý³Ì
CREATE TABLE dbo.tb_async_trigger_subscriber(
ID int IDENTITY
PRIMARY KEY,
procedure_name sysname
)
-- c. Òì²½´¥·¢Æ÷ºÍ´æ´¢¹ý³ÌÖ®¼äµÄ¶©ÔĹØÏµ
CREATE TABLE dbo.tb_async_trigger_subscribtion(
trigger_id int
REFERENCES dbo.tb_async_trigger(
Ïà¹ØÎĵµ£º
character-set-server = GB2312
collation-server = latin1_general_ci
MySQL×Ö·û¼¯ GBK¡¢GB2312¡¢UTF8Çø±ð ½â¾ö MYSQLÖÐÎÄÂÒÂëÎÊÌâ ÊÕ²Ø
MySQLÖÐÉæ¼°µÄ¼¸¸ö×Ö·û¼¯
character-set-server/default-character-set£º·þÎñÆ÷×Ö·û¼¯£¬Ä¬ÈÏÇé¿öÏÂËù²ÉÓõġ£
character-set-database£ºÊý¾Ý¿â×Ö·û¼¯¡£
character-set-table£ºÊ ......
1.Ñ¡Ôñ×îÓÐЧÂʵıíÃû˳Ðò(Ö»ÔÚ»ùÓÚ¹æÔòµÄÓÅ»¯Æ÷ÖÐÓÐЧ)¡¡¡¡
¡¡¡¡ SQLSERVERµÄ½âÎöÆ÷°´ÕÕ´ÓÓÒµ½×óµÄ˳Ðò´¦Àífrom×Ó¾äÖеıíÃû£¬Òò´Ëfrom×Ó¾äÖÐдÔÚ×îºóµÄ±í£¨»ù´¡±ídriving table£©½«±»×îÏÈ´¦Àí£¬ÔÚfrom×Ó¾äÖаüº¬¶à¸ö±íµÄÇé¿öÏ£¬±ØÐëÑ¡Ôñ¼Ç¼ÌõÊý×îÉٵıí×÷Ϊ»ù´¡±í£¬µ±SQLSERVER´¦Àí¶à¸ö±íʱ£¬»áÔËÓÃÅÅÐò¼°ºÏ²¢µÄ·½Ê½Á ......
Select * into customers from clients
(Êǽ«clients±íÀïµÄ¼Ç¼²åÈëµ½customersÖУ¬ÒªÇó£ºcustomers±í²»´æÔÚ£¬ÒòΪÔÚ²åÈëʱ»á×Ô¶¯´´½¨Ëü£»)
Insert into customers select * from clients
½â£ºInsert into customers select * from clients£©ÒªÇóÄ¿±ê±í£¨customers£©´æÔÚ£¬
ÓÉÓÚÄ¿±ê±íÒѾ´æÔÚ£¬ËùÒÔÎÒÃdzýÁ˲åÈëÔ´±í£ ......
SQL Server Filtered Indexes - What They Are, How to Use and Performance Advantages
Written By: Arshad Ali -- 7/2/2009 -
Problem
SQL Server 2008 introduces Filtered Indexes which is an index with a WHERE clause. Doesn’t it sound awesome especially for a table that has huge amount of data and ......
Ò»¡¢É¾³ýÁÐ
ALTER TABLE AA DROP COLUMN DEP;
ÊÊÓÃÓÚС±í-----Êý¾ÝÁ¿Ð¡µÄʱºò£»
2¡¢ALTER TABLE AA SET UNUSED("DEP") CASCADE CONSTRAINTS;
È»ºóÔÚ¸ºÔØÐ¡µÄʱºò£¬É¾³ý
ALTER TABLE AA DROP UNUSED COLUMNS;
¶þ¡¢Ìí¼ÓÁÐ
ÏȼÓÒ»ÐÂ×Ö¶ÎÔÙ¸³Öµ£º
alter table table_name add mmm varchar2(10);
update ta ......