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

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' 
)


Ïà¹ØÎĵµ£º

oracle10g SQL ¸ú×Ù

1.¼¤»îSQL¸ú×Ù
   ´Óoracle10gÒÔºóÌṩÁËÐµķ½·¨¼¤»îSQLµÄ¸ú×Ù£¬¼´ÊÇʹÓÃdbms_monitor°üÀ´¿ªÆô»ò¹Ø±ÕSQL¸ú×Ù¡£
   ֮ǰ¾É·½·¨ÊÇʹÓà alter session set events ..  »òÕßʹÓÃdbms_system.set_ev·½Ê½
   ʹÓÃdbms_monitor°ü¿ÉÒÔÔڻỰ£¬¿Í»§¶Ë£¬×é¼þÒÔ¼°Êý¾Ý¿âËĸö²ã¼¶¿ªÆôSQLµÄ¸ú×Ù¡ ......

LINQ to SQL ѧϰreference

http://weblogs.asp.net/scottgu/archive/2007/09/07/linq-to-sql-part-9-using-a-custom-linq-expression-with-the-lt-asp-linqdatasource-gt-control.aspx
1-9 parts are the most useful knowledge for you so far. ......

SQL ServerÀïÃæÈçºÎµ¼³ö°üº¬Êý¾ÝµÄSQL½Å±¾

ͨ³£Çé¿öÏ£¬SQL ServerÀïÃæµÄÉú³ÉSQL½Å±¾£¬Ö»»á°üº¬Êý¾Ý¿â¼°±íµÄ×ֶνṹ£¬¶ø²»»á°üº¬±íµÄÊý¾Ý£¬Ò²¾ÍÊÇSQL½Å±¾ÀïÃæÖ»ÓÐCreate database£¬Create table ÕâÑùµÄÓï¾ä£¬Ã»ÓÐinsert into¡£
ÒòΪSQL Server²¢²»°üº¬Õâ¸ö¹¦ÄÜ£¬Ö»ÄÜ¿¿µÚÈý·½µÄ´úÂëÁË¡£
ÒÔÏ´洢¹ý³Ì¿ÉÒÔʵÏÖ£º
CREATE PROCEDURE dbo.UspOutputData
@tablenam ......

SQLÈ¡ÈÕÆÚ

SQLÈ¡ÈÕÆÚ
SQL Server 2009-11-19 15:07:30 ÔĶÁ7 ÆÀÂÛ0 ×ֺţº´óÖÐС
·½·¨Ò»:
select CONVERT(varchar, getdate(), 120 )
2004-09-12 11:06:08
select replace(replace(replace(CONVERT(varchar, getdate(), 120 ),\'-\',\'\'),\' \',\'\'),\':\',\'\')
20040912110608
select CONVERT(varchar(12) , getdate( ......

Oracle SQL DeveloperÓëPL/SQL Developer±È½Ï¡¾×ª¡¿

¸½:Oracle SQL Developer — À©Õ¹½»Á÷ÖÐÐÄ
http://www.oracle.com/technology/global/cn/products/database/sql_developer/files/extensions.htm
      ֮ǰ×÷Ϊһ¸öOracle Employee£¬È´×ÜÊÇÔÚʹÓÃPL/SQL Developer£¨¶øÇÒÊÇÆÆ½â°æ£©£¬ÕâʵÔÚÓÐЩ˵²»¹ýÈ¥£¬µ«ÊÇÈçºÎÕÒµ½Ò»¸öºÏÐijÃÊÖµÄÄܹ»Ô ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ