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

ͨ¹ýMSSQL Server Agent Ö´ÐÐDTS °üµÄÎÊÌâ

ÖÆ×÷ÁËÒ»¸öDTS°ü£¬Äܹ»¿ª·¢»·¾³»òÕßÃüÁîÐÐÏÂÕýÈ·µÄÖ´ÐУ¬µ«ÔÚͨ¹ýAgent À´Ö´ÐеÄʱºò×ÜÊDZ¨´í£º
DTSRun: Loading... DTSRun: Executing... DTSRun OnStart: Copy Data from PRODFILE to [CompanyXYZDB].[dbo].[PRODFILE] Step DTSRun OnError: Copy Data from PRODFILE to [CompanyXYZDB].[dbo].[PRODFILE] Step, Error = -2147467259 (80004005) Error string: Error opening datafile: Access is denied. Error source: Microsoft Data Transformation Services Flat File Rowset Provider Help file: DTSFFile.hlp Help context: 0 Error Detail Records: Error: 5 (5); Provider Error: 5 (5) Error string: Error opening datafile: Access is denied. Error source: Microsoft Data Transformation Services Flat File Rowset Provider Help file: DTSFFile.hlp Help context: 0 DTSRun OnFinish: Copy Data from PRODFILE to [CompanyXYZDB].[dbo].[PRODFILE] Step DTSRun: Package execution complete. Process Exit Code 1. The step failed.
»òÕßÊÇÈçÏ´íÎó£º
 ´íÎóÔ´:   Microsoft OLE DB Provider for Oracle      °ïÖúÎļþ:         °ïÖúÉÏÏÂÎÄ:   0      ´íÎóÏêϸ¼Ç¼:      ´íÎó:   -2147467259 (80004005); Ìṩ³ÌÐò´íÎó:   0 (0)      ×Ö·û´®´íÎó:   ûÓз¢ÏÖ Oracle ¿Í»§¶ËºÍÍøÂç×é¼þ¡£ÕâЩ×é¼þÓÉ Oracle ¹«Ë¾Ìṩ£¬ÊÇ Oracle 7.3.3°æ(»ò¸üÐÂ)¿Í»§¶ËÈí¼þ°²×°µÄÒ»²¿·Ö¡£    ÌṩÕß½«ÎÞ·¨Ê¹ÓÃÖ±µ½ÕâЩ×é¼þ±»°²×°ÎªÖ¹¡£      ´íÎóÔ´:   Microsoft OLE DB Provider for Oracle      °ïÖúÎļþ:         °ïÖúÉÏÏÂÎÄ:   0      DTSRun OnError:  DTSStep_DTSExecuteSQLTask_5, Error = -2147467259 (80004005)      ×Ö·û´®´íÎó:   ûÓз¢ÏÖ Oracle ¿Í»§¶ËºÍÍøÂç×é¼þ¡£ÕâЩ×é¼þÓÉ Oracle ¹«Ë¾Ìṩ£¬ÊÇ Oracle 7.3.3°æ(»ò¸üÐÂ)¿Í»§¶ËÈí¼þ°²×°µÄÒ»²¿·Ö¡£    ÌṩÕß½«ÎÞ·¨Ê¹ÓÃÖ±µ½ÕâЩ×é¼þ±»°²×°ÎªÖ¹¡£ &


Ïà¹ØÎĵµ£º

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

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

MSSQLÊý¾Ý¿âÊý¾ÝÀàÐÍ


 
    Êý¾ÝÀàÐÍ
 
 ÀàÐÍ
 
 ÃèÊö
 
bit
 
ÕûÐÍ
 
bit Êý¾ÝÀàÐÍÊÇÕûÐÍ£¬ÆäÖµÖ»ÄÜÊÇ0¡¢1»ò¿ÕÖµ¡£ÕâÖÖÊý¾ÝÀàÐÍÓÃÓÚ´æ´¢Ö»ÓÐÁ½ÖÖ¿ÉÄÜÖµµÄÊý¾Ý £¬ÈçYes »òNo¡¢True »òFa lse ¡¢On »òOff
int
 
ÕûÐÍ
 
int Êý¾ÝÀàÐÍ¿ÉÒÔ´æ´¢´Ó- 231( ......

mssqlÀïsp_MSforeachtableºÍsp_MSforeachdbµÄÓ÷¨

´Ómssql6.5¿ªÊ¼£¬Î¢ÈíÌṩÁËÁ½¸ö²»¹«¿ª£¬·Ç³£ÓÐÓõÄϵͳ´æ´¢¹ý³Ìsp_MSforeachtableºÍsp_MSforeachdb£¬ÓÃÓÚ±éÀúij¸öÊý¾Ý¿âµÄÿ¸ö±íºÍ±éÀúDBMS¹ÜÀíϵÄÿ¸öÊý¾Ý¿â¡£
ÎÒÃÇÔÚmasterÊý¾Ý¿âÀïÖ´ÐÐÏÂÃæµÄÓï¾ä¿ÉÒÔ¿´µ½Á½¸öprocÏêϸµÄ´úÂë
use master
exec sp_helptext sp_MSforeachtable
exec sp_helptext sp_Msforeachdb
sp_M ......

.batÆô¶¯Êý¾Ý¿â·þÎñ(MSSQL,Oracle)

 @echo off
:dosmenu
REM Ñ¡Ôñ²Ëµ¥
echo  Windows ·þÎñÆô¶¯»ò¹Ø±Õ By hope 2008Äê2ÔÂ7ÈÕ     
echo.
echo [1]Æô¶¯Sql Server2005   [2]¹Ø±ÕSql Server2005
echo [3]Æô¶¯Oracle9i         [4]¹Ø±ÕOracle9i
echo.
echo  ......

½²½â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±íÃ÷ûÓжÔÊý¾Ý±íÌí¼Ó¹²Ï ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ