Sql Serverµ¼³öÎı¾Îļþ
ÏÈ¿ªÆô·þÎñÆ÷ÅäÖÃÑ¡Ï
EXEC sp_configure 'show advanced options', 1
RECONFIGURE
EXEC sp_configure 'xp_cmdshell', 1
RECONFIGURE
/** µ¼³öÎı¾Îļþ
EXEC master..xp_cmdshell 'bcp dbname..tablename out c:\DT.txt -c -S servername -U sa -P password'
»ò
EXEC master..xp_cmdshell 'bcp "Select * from dbname..tablename" queryout c:\DT.txt -c -S servername -U sa -P password'
µ¼³öµ½TXTÎı¾£¬ÓöººÅ·Ö¿ª
exec master..xp_cmdshell 'bcp "¿âÃû..±íÃû" out "d:\tt.txt" -c -t ,-U sa -P password'
BULK INSERT ¿âÃû..±íÃû
from 'c:\test.txt'
WITH (
FIELDTERMINATOR = ';',
ROWTERMINATOR = '\n'
)
Ïà¹ØÎĵµ£º
5.1 ÃÜÂë²ßÂÔ
¡¡¡¡ÓÉÓÚsql server²»Äܸü¸ÄsaÓû§Ãû³Æ£¬Ò²²»ÄÜɾ³ýÕâ¸ö³¬¼¶Óû§£¬ËùÒÔ£¬ÎÒÃDZØÐë¶ÔÕâ¸öÕʺŽøÐÐ×îÇ¿µÄ±£»¤£¬µ±È»£¬°üÀ¨Ê¹ÓÃÒ»¸ö·Ç³£Ç¿×³µÄÃÜÂ룬×îºÃ²»ÒªÔÚÊý¾Ý¿âÓ¦ÓÃÖÐʹÓÃsaÕʺš£Ð½¨Á¢Ò»¸öÓµÓÐÓësaÒ»ÑùȨÏ޵ij¬¼¶Óû§À´¹ÜÀíÊý¾Ý¿â¡£Í¬Ê±Ñø³É¶¨ÆÚÐÞ¸ÄÃÜÂëµÄºÃϰ¹ß¡£Êý¾Ý¿â¹ÜÀíÔ±Ó¦¸Ã¶¨ÆÚ²é¿´ÊÇ·ñÓв»·ûºÏ ......
1.¼¤»îSQL¸ú×Ù
´Óoracle10gÒÔºóÌṩÁËÐµķ½·¨¼¤»îSQLµÄ¸ú×Ù£¬¼´ÊÇʹÓÃdbms_monitor°üÀ´¿ªÆô»ò¹Ø±ÕSQL¸ú×Ù¡£
֮ǰ¾É·½·¨ÊÇʹÓà alter session set events .. »òÕßʹÓÃdbms_system.set_ev·½Ê½
ʹÓÃdbms_monitor°ü¿ÉÒÔÔڻỰ£¬¿Í»§¶Ë£¬×é¼þÒÔ¼°Êý¾Ý¿âËĸö²ã¼¶¿ªÆôSQLµÄ¸ú×Ù¡ ......
--ÐÐÁл¥×ª
/******************************************************************************************************************************************************
ÒÔѧÉú³É¼¨ÎªÀý×Ó£¬±È½ÏÐÎÏóÒ×¶® ÕûÀíÈË£ºÖйú·ç
(Roy)
ÈÕÆÚ
:2008.06.06 *************************************** ......
³ÌÐòÆô¶¯Sql ServerÆäʵºÜ¼òµ¥
´úÂ룺
System.ServiceProcess.ServiceController myController =
new System.ServiceProcess.ServiceController("MSSQL$ACCP4444"); //·þÎñÃû³Æ ÕÒÁ˰ëÌì²ÅÕÒµ½£¬±¿ËÀÎÒÍêÁË¡£ÔÚ·þÎñÉÏÓÒ¼üÊôÐÔ£¬ÄÜ¿´µ½
if (myController.CanStop)
{ }
else ......
ÔÌù£ºhttp://topic.csdn.net/u/20100412/11/a4ea520e-7dd0-44d2-98bb-9f62f0ed6160.html?21233
--------------------------------------------------------------------------
-- Author : htl258(Tony)
-- Date : 2010-04-14 06:02:36
-- Version:Microsoft SQL Server 2008 (RTM) - 1 ......