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

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Óï¾ä

1¡¢ËµÃ÷£º¸´ÖƱí(Ö»¸´Öƽṹ,Ô´±íÃû£ºa бíÃû£ºb) (Access¿ÉÓÃ)
·¨Ò»£ºselect * into b from a where 1<>1
·¨¶þ£ºselect top 0 * into b from a
2¡¢ËµÃ÷£º¿½±´±í(¿½±´Êý¾Ý,Ô´±íÃû£ºa Ä¿±ê±íÃû£ºb) (Access¿ÉÓÃ)
insert into b(a, b, c) select d,e,f from b;
3¡¢ËµÃ÷£º¿çÊý¾Ý¿âÖ®¼ä±íµÄ¿½±´(¾ßÌåÊý¾ÝʹÓþø¶Ô· ......

sql °Ñ±íµ¼³É.TXTÎļþ

sql ´úÂë:
---------------------------------------------------------
/*
  a        ±íÃû
  Èç¹ûÔÚsql ²éѯ·ÖÎöÆ÷µ±ÖгöÏÖ
  " SQL Server ×èÖ¹Á˶Ô×é¼þ 'xp_cmdshell' µÄ ¹ý³Ì'sys.xp_cmdshell' µÄ·ÃÎÊ£¬ÒòΪ´Ë×é¼þÒÑ×÷Ϊ´Ë·þÎñÆ÷°²È«ÅäÖõÄÒ»²¿·Ö¶ø±»¹Ø± ......

SQL Server 2005 ¾µÏñ¹¦ÄÜʵÏÖ

SQL Server 2005 ¾µÏñ¹¦ÄÜʵÏÖ
1. Ö÷»ú¡¢¾µÏñ·Ö±ðMASTER KEY¡£
Ö÷»úÖ´ÐУº 
USE master;  
  
CREATE MASTER KEY ENCRYPTION BY PASSWORD = 'password';  
  
CREATE CERTIFICATE HOST_A_cert WITH  ......

Using Oracle Trace Analyzer (trcanlzr.sql)


Using Oracle Trace Analyzer (trcanlzr.sql)
Dave Moore:  Author of Oracle Utilities
Oracle has provided another utility initially designed for performance tuning Oracle Applications.  Trace Analyzer is provided in the form of a PL/SQL package (TRCA$ ).  The Trace Analyzer utility i ......

Sql Server Êý¾Ý¿âÁ¬½ÓÎÊÌâ

²Î¿¼ÎÄÏ×£ºhttp://www.cnblogs.com/chenxizhang/archive/2009/04/23/1441913.html
SQL ServerÌṩËÄÖÖ·½Ê½Á¬½ÓÊý¾Ý¿â·þÎñÆ÷:
1. share memory: Ö»ÊÊÓÃÓÚ¿Í»§¶ËºÍ·þÎñÆ÷¶ËÔÚͬһ̨»úÆ÷ÉÏ,²ÅÄܲÉÓõÄÁ¬½Ó
2. Named pipe:
ÔÚ¾ÖÓòÍø(LAN)ÄÚʵÏÖÁ¬½Ó,Ò»¸ö½ø³ÌʹÓÃÒ»²¿·ÖµÄÄÚ´æÀ´Ïò½ø³ÌµÄÁíÒ»¶Ë´«µÝÏûÏ¢,Ò»¸ö½ø³ÌµÄÊä³öÊÇÁíÍâ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ