Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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µÝ¹é²éѯ²¿ÃÅ

create function [dbo].[DeptTree](@initDeptCode  varchar(10))/*¶¨Ò庯Êýc_tree£¬ÊäÈë²ÎÊýΪ³õʼ½ÚµãDeptCode*/
returns @t table(DeptCode varchar(10),UpDeptCode  varchar(10),lev int)/*¶¨Òå±ítÓÃÀ´´æ·ÅÈ¡³öµÄÊý¾Ý*/
begin
  declare @i int/*±êÖ¾µÝ¹é¼¶±ð*/
  set @i=1
  insert @t ......

SQL SERVER

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

SQL ServerÎÞ·¨´ò¿ªÓû§Ä¬ÈÏÊý¾Ý¿â

ÎÞ·¨´ò¿ªÓû§Ä¬ÈÏÊý¾Ý¿â£¬µÇ¼ʧ°Ü,ÕâÊÇSQL ServerʹÓÃÕßÊìϤµÄÎÊÌâÖ®Ò»¡£ÔÚʹÓÃÆóÒµ¹ÜÀíÆ÷¡¢²éѯ·ÖÎöÆ÷¡¢¸÷À๤¾ßºÍÓ¦ÓÃÈí¼þµÄʱºò£¬Ö»Òª¹ØÏµµ½Á¬½ÓSQL ServerÊý¾Ý¿âµÄʱºò£¬¶¼ÓпÉÄÜ»áÅöµ½´ËÎÊÌâ,ÒýÆð´Ë´íÎó·¢ÉúµÄÔ­Òò±È½Ï¶à,ÏÂÃæÎÒÃǾÍÀ´Ïêϸ·ÖÎöÒýÆð´ËÎÊÌâµÄÔ­ÒòÒÔ¼°½â¾ö°ì·¨¡£
Ò»¡¢Ô­Òò
µÇ¼ÕÊ»§µÄĬÈÏÊý¾Ý¿â±»É¾³ý¡ ......

SQL ServerÖи÷¸öϵͳ±íµÄ×÷ÓÃ

 
sysaltfiles            Ö÷Êý¾Ý¿â              ±£´æÊý¾Ý¿âµÄÎļþ
syscharsets        Ö÷Êý¾Ý¿â        &nb ......

SQL Server 2005 ûÓÐSQL Server Management Studio


 
SQL Server 2005 ûÓÐSQL Server Management Studio
°²×°visual studio 2005µÄʱºòϵͳҲװÁËSQL 2005¡£Çë×¢Ò⣬Õâʱ°²×°ÉϵÄSQL2005ÊÇExpress°æ±¾µÄ£¬¼È²»ÊÇÆóÒµ°æ£¬Ò²²»ÊÇ¿ª·¢Õß°æ¡£ÕâʱµÄExpress°æÊÇûÓа²×°SQL Server Management Studio µÄ£¬Ö»ÓÐÅäÖù¤¾ß£¬Ò²¾ÍÊÇ˵ÄãÔÚ¿ªÊ¼²Ëµ¥Ö»¿´µÃµ½ÅäÖù¤¾ß¡£
Õâʱ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ