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

ÔÚ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(


Ïà¹ØÎĵµ£º

MySQL ×Ö·û¼¯µ¼ÖÂSQLÁ¬½ÓÖ®ºóÖÐÎÄÂÒÂëµÄÎÊÌ⣡

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£ºÊ ......

SQLSERVER SQLÐÔÄÜÓÅ»¯

1.Ñ¡Ôñ×îÓÐЧÂʵıíÃû˳Ðò(Ö»ÔÚ»ùÓÚ¹æÔòµÄÓÅ»¯Æ÷ÖÐÓÐЧ)¡¡¡¡
¡¡¡¡ SQLSERVERµÄ½âÎöÆ÷°´ÕÕ´ÓÓÒµ½×óµÄ˳Ðò´¦Àífrom×Ó¾äÖеıíÃû£¬Òò´Ëfrom×Ó¾äÖÐдÔÚ×îºóµÄ±í£¨»ù´¡±ídriving table£©½«±»×îÏÈ´¦Àí£¬ÔÚfrom×Ó¾äÖаüº¬¶à¸ö±íµÄÇé¿öÏ£¬±ØÐëÑ¡Ôñ¼Ç¼ÌõÊý×îÉٵıí×÷Ϊ»ù´¡±í£¬µ±SQLSERVER´¦Àí¶à¸ö±íʱ£¬»áÔËÓÃÅÅÐò¼°ºÏ²¢µÄ·½Ê½Á ......

SQL SERVER±í¼ä¸´ÖÆÊý¾Ý

Select * into customers from clients
(Êǽ«clients±íÀïµÄ¼Ç¼²åÈëµ½customersÖУ¬ÒªÇó£ºcustomers±í²»´æÔÚ£¬ÒòΪÔÚ²åÈëʱ»á×Ô¶¯´´½¨Ëü£»)
Insert into customers select * from clients
½â£ºInsert into customers select * from clients£©ÒªÇóÄ¿±ê±í£¨customers£©´æÔÚ£¬
ÓÉÓÚÄ¿±ê±íÒѾ­´æÔÚ£¬ËùÒÔÎÒÃdzýÁ˲åÈëÔ´±í£ ......

SQL Server2008 Filtered Indexes

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 ......

oracle sql×Ô¶¯µÝÔö

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