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

mssqlÀïÊÂÎñµÄÏê½â

ÕûÀíתÌù
Ò»¡¢ÊÂÎñµÄÊôÐÔ
¡¡¡¡ÊÂÎñ¾ßÓÐacidÊôÐÔ:¼´ atomicÔ­×ÓÐÔ, consistentÒ»ÖÂÐÔ, isolated¸ôÀëÐÔ, durableÓÀ¾ÃÐÔ
¡¡¡¡Ô­×ÓÐÔ£ºÊÂÎñÓ¦×÷Ϊһ¸ö¹¤×÷µ¥Ôª,ÊÂÎñ´¦ÀíÍê³É£¬ËùÓеŤ×÷Ҫô¶¼ÔÚÊý¾Ý¿âÖб£´æÏÂÀ´£¬ÒªÃ´ÍêÈ«»Ø¹ö£¬È«²¿²»±£Áô
¡¡¡¡Ò»ÖÂÐÔ£ºÊÂÎñÍê³É»òÕß³·Ïúºó£¬¶¼Ó¦¸Ã´¦ÓÚÒ»ÖµÄ״̬
¡¡¡¡¸ôÀëÐÔ£º¶à¸öÊÂÎñͬʱ½øÐУ¬ËüÃÇÖ®¼äÓ¦¸Ã»¥²»¸ÉÈÅ.Ó¦¸Ã·ÀÖ¹Ò»¸öÊÂÎñ´¦ÀíÆäËûÊÂÎñÒ²ÒªÐ޸ĵÄÊý¾Ýʱ£¬²»ºÏÀíµÄ´æÈ¡ºÍ²»ÍêÕûµÄ¶ÁÈ¡Êý¾Ý
¡¡¡¡ÓÀ¾ÃÐÔ£ºÊÂÎñÌá½»ÒÔºó£¬Ëù×öµÄ¹¤×÷¾Í±»ÓÀ¾ÃµÄ±£´æÏÂÀ´
¶þ¡¢ÊÂÎñ²¢·¢´¦Àí»á²úÉúµÄÎÊÌâ
¡¡¡¡¶ªÊ§¸üУºµ±Á½¸ö»ò¶à¸öÊÂÎñÑ¡ÔñͬһÐУ¬È»ºó»ùÓÚ×î³õÑ¡¶¨µÄÖµ¸üиÃÐÐʱ£¬»á·¢Éú¶ªÊ§¸üÐÂÎÊÌ⡢ÿ¸öÊÂÎñ¶¼²»ÖªµÀÆäËüÊÂÎñµÄ´æÔÚ¡£×îºóµÄ¸üн«ÖØдÓÉÆäËüÊÂÎñËù×öµÄ¸üУ¬Õ⽫µ¼ÖÂÊý¾Ý¶ªÊ§¡£
¡¡¡¡Ôà¶Á£ºµ±µÚ¶þ¸öÊÂÎñÑ¡ÔñÆäËüÊÂÎñÕýÔÚ¸üеÄÐÐʱ£¬»á·¢ÉúδȷÈϵÄÏà¹ØÐÔÎÊÌâ¡£ µÚ¶þ¸öÊÂÎñÕýÔÚ¶ÁÈ¡µÄÊý¾Ý»¹Ã»ÓÐÈ·Èϲ¢ÇÒ¿ÉÄÜÓɸüдËÐеÄÊÂÎñËù¸ü¸Ä¡£
¡¡¡¡²»¿ÉÖظ´¶Á£ºµ±µÚ¶þ¸öÊÂÎñ¶à´Î·ÃÎÊͬһÐжøÇÒÿ´Î¶ÁÈ¡²»Í¬µÄÊý¾Ýʱ£¬»á·¢Éú²»Ò»ÖµķÖÎöÎÊÌâ¡£²»Ò»ÖµķÖÎöÓëδȷÈϵÄÏà¹ØÐÔÀàËÆ£¬ÒòΪÆäËüÊÂÎñÒ²ÊÇÕýÔÚ¸ü¸ÄµÚ¶þ¸öÊÂÎñÕýÔÚ¶ÁÈ¡µÄÊý¾Ý¡£ È»¶ø£¬ÔÚ²»Ò»ÖµķÖÎöÖУ¬µÚ¶þ¸öÊÂÎñ¶ÁÈ¡µÄÊý¾ÝÊÇÓÉÒѽøÐÐÁ˸ü¸ÄµÄÊÂÎñÌá½»µÄ¡£¶øÇÒ£¬²»Ò»ÖµķÖÎöÉæ¼°¶à´Î£¨Á½´Î»ò¸ü¶à£©¶ÁȡͬһÐУ¬¶øÇÒÿ´ÎÐÅÏ¢¶¼ÓÉÆäËüÊÂÎñ¸ü¸Ä£»Òò¶ø¸ÃÐб»·ÇÖظ´¶ÁÈ¡¡£
¡¡¡¡»ÃÏñ¶Á£ºµ±¶ÔijÐÐÖ´ÐвåÈë»òɾ³ý²Ù×÷£¬¶ø¸ÃÐÐÊôÓÚij¸öÊÂÎñÕýÔÚ¶ÁÈ¡µÄÐеķ¶Î§Ê±£¬»á·¢Éú»ÃÏñ¶ÁÎÊÌâ¡£ ÊÂÎñµÚÒ»´Î¶ÁµÄÐз¶Î§ÏÔʾ³öÆäÖÐÒ»ÐÐÒѲ»¸´´æÔÚÓÚµÚ¶þ´Î¶Á»òºóÐø¶ÁÖУ¬ÒòΪ¸ÃÐÐÒѱ»ÆäËüÊÂÎñɾ³ý¡£Í¬Ñù£¬ÓÉÓÚÆäËüÊÂÎñµÄ²åÈë²Ù×÷£¬ÊÂÎñµÄµÚ¶þ´Î»òºóÐø¶ÁÏÔʾÓÐÒ»ÐÐÒѲ»´æÔÚÓÚԭʼ¶ÁÖС£
Èý¡¢ÊÂÎñ´¦ÀíÀàÐÍ
¡¡¡¡×Ô¶¯´¦ÀíÊÂÎñ£ºÏµÍ³Ä¬ÈÏÿ¸öt£­sqlÃüÁÊÇÊÂÎñ´¦Àí ÓÉϵͳ×Ô¶¯¿ªÊ¼²¢Ìá½»
¡¡¡¡ÒþʽÊÂÎñ£ºµ±ÓдóÁ¿µÄddl ºÍdmlÃüÁîÖ´ÐÐʱ»á×Ô¶¯¿ªÊ¼£¬²¢Ò»Ö±±£³Öµ½Óû§Ã÷È·ÌύΪֹ£¬Çл»ÒþʽÊÂÎñ¿ÉÒÔÓÃset implicit_transactions.ΪÁ¬½ÓÉèÖÃÒþÐÔÊÂÎñģʽ.µ±ÉèÖÃΪ on ʱ£¬set implicit_transactions ½«Á¬½ÓÉèÖÃΪÒþÐÔÊÂÎñģʽ¡£µ±ÉèÖÃΪ off ʱ£¬ÔòʹÁ¬½Ó·µ»Øµ½×Ô¶¯Ìá½»ÊÂÎñģʽ
¡¡¡¡Óû§¶¨ÒåÊÂÎñ£ºÓÉÓû§À´¿ØÖÆÊÂÎñµÄ¿ªÊ¼ºÍ½áÊø ÃüÁîÓÐ: begin tran, commit tran,rollback tran ÃüÁî
¡¡¡¡·Ö²¼Ê½ÊÂÎñ£º¿çÔ½¶à¸ö·þÎñÆ÷µÄÊÂÎñ³ÆΪ·Ö²¼Ê½ÊÂÎñ,sql server ¿ÉÒÔÓÉdtc microsoft dist


Ïà¹ØÎĵµ£º

mssql´æ´¢¹ý³ÌÊÕ¼¯


sql´æ´¢¹ý³Ì½Ì³Ì
[ËѼ¯ÕûÀí]sql´æ´¢¹ý³ÌÍêÈ«½Ì³Ì 
Ŀ¼
1.sql´æ´¢¹ý³Ì¸ÅÊö
2.SQL´æ´¢¹ý³Ì´´½¨
3.sql´æ´¢¹ý³Ì¼°Ó¦ÓÃ
4.¸÷ÖÖ´æ´¢¹ý³ÌʹÓÃÖ¸ÄÏ
5.ASPÖд洢¹ý³Ìµ÷ÓõÄÁ½ÖÖ·½Ê½¼°±È½Ï
6.SQL´æ´¢¹ý³ÌÔÚ.NETÊý¾Ý¿âÖеÄÓ¦Óà
7.ʹÓÃSQL´æ´¢¹ý³ÌÒªÌرð×¢ÒâµÄÎÊÌâ
1.sql´æ´¢¹ý³Ì¸ÅÊö
ÔÚ´óÐÍÊý¾Ý¿âϵͳÖУ¬´æ´ ......

MSSQLµÄ¶à²ãǶÌײéѯ

½ñÌìÔÚÁÄÌìϵͳÖÐÐèҪϵͳִÐÐÒ»¸ö¶à²ãǶÌײéѯ¡£
Ò»¿ªÊ¼Óï¾äÈçÏÂ×ܳöÏÖ´íÎó£ºÔ­À´ÊÇÔÚ]='123') ºóÎÒ¶à¼ÓÁËÒ»¸ö as tb1
¸ÄΪÈçϺó£¬ÕýÈ·ÔËÐС£
select * from ( select top(10)  * from ( select top(100)  * from (select  [chatcontent].[senderid],[chatcontent].[id] ,[chatcontent].[toid] ,[chatc ......

»ùÓÚmssql °ÙÍò¼¶ Êý¾Ý ²éѯ ÓÅ»¯ ¼¼ÇÉÈýÊ®Ôò

1.¶Ô²éѯ½øÐÐÓÅ»¯£¬Ó¦¾¡Á¿±ÜÃâÈ«±íɨÃ裬Ê×ÏÈÓ¦¿¼ÂÇÔÚ where ¼° order by Éæ¼°µÄÁÐÉϽ¨Á¢Ë÷Òý¡£
2.Ó¦¾¡Á¿±ÜÃâÔÚ where ×Ó¾äÖжÔ×ֶνøÐÐ null ÖµÅжϣ¬·ñÔò½«µ¼ÖÂÒýÇæ·ÅÆúʹÓÃË÷Òý¶ø½øÐÐÈ«±íɨÃ裬È磺
select id from t where num is null
¿ÉÒÔÔÚnumÉÏÉèÖÃĬÈÏÖµ0£¬È·±£±íÖÐnumÁÐûÓÐnullÖµ£¬È»ºóÕâÑù²éѯ£º
select id ......

½²½âMSSQLÊý¾Ý¿âÖÐSQLËø»úÖƺÍÊÂÎñ¸ôÀ뼶±ð

Ëø»úÖÆ
NOLOCKºÍREADPASTµÄÇø±ð¡£
1. ¿ªÆôÒ»¸öÊÂÎñÖ´ÐвåÈëÊý¾ÝµÄ²Ù×÷¡£
BEGIN TRAN t
INSERT INTO Customer
SELECT 'a','a'
2. Ö´ÐÐÒ»Ìõ²éѯÓï¾ä¡£
SELECT * from Customer WITH (NOLOCK)
½á¹ûÖÐÏÔʾ"a"ºÍ"a"¡£µ±1ÖÐÊÂÎñ»Ø¹öºó£¬ÄÇôa½«³ÉΪÔàÊý¾Ý¡£(×¢:1ÖеÄÊÂÎñδÌá½») ¡£NOLOCK±íÃ÷ûÓжÔÊý¾Ý±íÌí¼Ó¹²Ï ......

ÆôÓÃMSSQL·Ö²¼Ê½ÊÂÎñµÄ³£¼ûÎÊÌâ

ÈçºÎ´´½¨Á´½Ó·þÎñÆ÷
IF  EXISTS (SELECT srv.name from sys.servers srv WHERE srv.server_id != 0 AND srv.name = N'Á´½Ó·þÎñÆ÷Ãû')
EXEC master.dbo.sp_dropserver @server=N'Á´½Ó·þÎñÆ÷Ãû'', @droplogins='droplogins'
GO
EXEC master.dbo.sp_addlinkedserver
 @server = N'Á´½Ó·þÎñÆ÷Ãû'', @srvproduct= ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ