SQL Ìí¼Óɾ³ý·þÎñÆ÷
//--Ìí¼Ó·þÎñÆ÷
EXEC sp_addlinkedserver
@server='LQXLSJ-600A5A60',--±»·ÃÎʵķþÎñÆ÷±ðÃû
@srvproduct='',
@provider='SQLOLEDB',
@datasrc='LQXLSJ-600A5A60' --Òª·ÃÎʵķþÎñÆ÷
EXEC sp_addlinkedsrvlogin
'LQXLSJ-600A5A60', --±»·ÃÎʵķþÎñÆ÷±ðÃû
'false',
NULL,
'sa', --ÕʺÅ
'sa' --ÃÜÂë
//--ɾ³ý·þÎñÆ÷
Exec sp_droplinkedsrvlogin 'LQXLSJ-600A5A60',Null
Exec sp_dropserver 'LQXLSJ-600A5A60'
Ïà¹ØÎĵµ£º
sql ´úÂë:
---------------------------------------------------------
/*
a ±íÃû
Èç¹ûÔÚsql ²éѯ·ÖÎöÆ÷µ±ÖгöÏÖ
" SQL Server ×èÖ¹Á˶Ô×é¼þ 'xp_cmdshell' µÄ ¹ý³Ì'sys.xp_cmdshell' µÄ·ÃÎÊ£¬ÒòΪ´Ë×é¼þÒÑ×÷Ϊ´Ë·þÎñÆ÷°²È«ÅäÖõÄÒ»²¿·Ö¶ø±»¹Ø± ......
SQL Server 2005 ¾µÏñ¹¦ÄÜʵÏÖ
1. Ö÷»ú¡¢¾µÏñ·Ö±ðMASTER KEY¡£
Ö÷»úÖ´ÐУº
USE master;
CREATE MASTER KEY ENCRYPTION BY PASSWORD = 'password';
CREATE CERTIFICATE HOST_A_cert WITH ......
SQL Server 2005Êý¾Ý¿â¾µÏñ¼ò½é
×Ô´ÓSQL Server 2000ÒÔÀ´£¬ÄãÒѾÄܹ»Í¨¹ýʹÓø´ÖÆÀ´´´½¨Ò»¸ö±¸ÓõķþÎñÆ÷¡¢´«ÊäÈÕÖ¾£¬ÒÔ¼°±¸·ÝºÍÖØÐ´洢ÁË——µ«ÊÇÏÖÔÚ΢ÈíÓÖÒýÈëÁËÒ»¸öÄÚ½¨µÄ¹¤¾ß£¬Ëü¿ÉÒÔʵÏÖ×Ô¶¯µÄ´íÎó»Ö¸´¡£Êý¾Ý¿â¾µÏñÊÇSQL Server 2005µÄÒ»¸öÐÂÌØÐÔ£¬ËüÔÊÐíÄ㽫һ¸öSQL ServerÖеÄÊý¾Ý¿âÄÚÈݾµÏñµ½ÁíÒ»¸öS ......
²Î¿¼ÎÄÏ×£ºhttp://www.cnblogs.com/chenxizhang/archive/2009/04/23/1441913.html
SQL ServerÌṩËÄÖÖ·½Ê½Á¬½ÓÊý¾Ý¿â·þÎñÆ÷:
1. share memory: Ö»ÊÊÓÃÓÚ¿Í»§¶ËºÍ·þÎñÆ÷¶ËÔÚͬһ̨»úÆ÷ÉÏ,²ÅÄܲÉÓõÄÁ¬½Ó
2. Named pipe:
ÔÚ¾ÖÓòÍø(LAN)ÄÚʵÏÖÁ¬½Ó,Ò»¸ö½ø³ÌʹÓÃÒ»²¿·ÖµÄÄÚ´æÀ´Ïò½ø³ÌµÄÁíÒ»¶Ë´«µÝÏûÏ¢,Ò»¸ö½ø³ÌµÄÊä³öÊÇÁíÍâ ......
select * from tableName where datediff(week,dateField,getdate())=0
ÕâÑù²é³öÀ´µÄ½á¹ûÊÇ´ÓÐÇÆÚÌìµ½ÐÇÆÚÁù(ÀÏÍâĬÈÏÐÇÆÚÌìÊÇÒ»ÖܵĵÚÒ»Ìì).
Èç¹ûÏëÒÔÐÇÆÚÒ»×÷ΪµÚÒ»ÌìµÄ»°,Á½¸öʱ¼ä¶¼ÐèÒª¼õÒ»,ÈçÏÂ:
select * from tableName where datediff(week,dateField-1,getdate()-1)=0 ......