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

SQL SERVERÊý¾Ý¿âÖÐµÄ±í±¸·Ý³ÉÎı¾

--×÷ÓãºÊý¾Ý¿âÖÐµÄ±í±¸·Ý³ÉÎı¾
Declare @tabname varchar(200),@ip varchar(50),@user varchar(50),@password varchar(50),@sql varchar(1000),@filetxt varchar(200),@file varchar(50)
set @tabname='database.dbo.tb' --±íÃû
set @ip='127.0.0.1'  --IPµØÖ·£¬±¾»úµÄ»°¾Íд127.0.0.1
set @user='sa'   --Êý¾Ý¿âÓû§Ãû
set @password='123'  --Êý¾Ý¿âÃÜÂë
set @file='c:\'   --±¸·Ý·¾¶
set @filetxt='tb.txt'  --±¸·ÝÎļþÃû
set @sql='Bcp '+@tabname+' out '+@file+@filetxt+' -S '+@ip+' -U '+@user+' -P '+@password+' -t \t -c'
Print @sql
Exec master..xp_cmdshell @sql,No_Output


Ïà¹ØÎĵµ£º

SQL SERVER

DBCC
Transact-SQL ±à³ÌÓïÑÔÌṩ DBCC Óï¾ä×÷Ϊ Microsoft® SQL Server™ 2000 µÄÊý¾Ý¿â¿ØÖÆÌ¨ÃüÁî¡£ÕâЩÓï¾ä¶ÔÊý¾Ý¿âµÄÎïÀíºÍÂß¼­Ò»ÖÂÐÔ½øÐмì²é¡£Ðí¶à DBCC Óï¾äÄܹ»¶Ô¼ì²âµ½µÄÎÊÌâ½øÐÐÐÞ¸´¡£
Êý¾Ý¿â¿ØÖÆÌ¨ÃüÁîÓï¾ä±»·ÖΪÒÔÏÂÀà±ð¡£
Óï¾ä·ÖÀà Ö´ÐÐ
ά»¤Óï¾ä ¶ÔÊý¾Ý¿â¡¢Ë÷Òý»òÎļþ×é½øÐÐά»¤µÄÈÎÎñ¡£  ......

PL\SQL²éѯ³öÏÖÂÒÂë½â¾ö°ì·¨

1. ´ò¿ªpl\sql  ÔËÐÐÏÂÃæµÄ½Å±¾£¬²éѯ·þÎñÆ÷µÄ×Ö·û¼¯ ¡£
SELECT 'AMERICAN_AMERICA.' || PROPERTY_VALUE
from DATABASE_PROPERTIES
WHERE PROPERTY_NAME = 'NLS_CHARACTERSET';
ÎÒµÄÊÇ    AMERICAN_AMERICA.ZHS16GBK
2.ÔÚÔËÐÐÖÐÊäÈ룺regedit£¬´ò¿ª×¢²á±í±à¼­Æ÷£» 
3.HKEY_LOCAL_MACHI ......

ÓÅ»¯SQL ServerÊý¾Ý¿â·þÎñÆ÷ÄÚ´æÅäÖÃ

ǰÑÔ
Å©ÒµÒøÐÐ×ÜÐÐ1998ÄêÒÔÀ´ÕýÊ½ÍÆ¹ãÁËаæÍøÂç°æ×ÛºÏÒµÎñͳ¼ÆÐÅϢϵͳ£¬¸ÃϵͳÊÇ»ùÓÚWindowsNT4.0ƽ̨£¬²ÉÓÿͻ§£¯·þÎñÆ÷ģʽ£¬ÒÔMicrosoft SQL ServerΪ»ù´¡½¨Á¢ÆðÀ´µÄ´óÐÍÊý¾Ý¿âÓ¦ÓóÌÐò£¬ÏµÍ³½çÃæÓѺᢲÙ×÷¼ò±ã£¬¼ÆËã¡¢·ÖÎö¡¢¼ìË÷¹¦Äܷdz£Ç¿´ó£¬Îª±£Ö¤Å©ÒµÒøÐÐϵͳ¼°Ê±½øÐÐ×ÝÏòºÍºáÏòÒµÎñÊý¾Ý²É¼¯¡¢°´ÕÕ²»Í¬ÒªÇóÉú³ ......

SQLʱ¼ä¶Î²éѯ


SQLʱ¼ä¶Î²éѯ
ACCESSµÄ»°
select * from table where date1<#2008-1-20# and date2>#2007-8-30#
MYSQLµÄ»°
select * from table where date1<'2008-1-20' and date2>'2007-3-30'
Ò²¿ÉÒÔ
select * from table where date1 between '2008-1-20' and '2007-3-30'
ÆäÖÐdate1,date2¶¼ÊÇÈÕÆÚÀàÐ͵Ä× ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ