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

SQL Server bcp

D:\projects\openi\misc\xxxx_data_20090828>bcp [xxxxolap].[dbo].[wdb_cxbz]  in wdb_xxx.txt      -c -T
SQLState = 37000, NativeError = 4060
Error = [Microsoft][SQL Server Native Client 10.0][SQL Server]Cannot open database "xxxolap" requested by the login. The login failed.
SQLState = 28000, NativeError = 18456
Error = [Microsoft][SQL Server Native Client 10.0][SQL Server]Login failed for user 'xxxx\robin'.
½â¾ö°ì·¨
- MS SQLSERVER MANAGEMENT STUDIO -> SECURITY
- new LOGIN£¬¼ÓÈë 'xxxx\robin'
- ROLES&MAPPING


Ïà¹ØÎĵµ£º

ÁíÀà¼òµ¥µÄSQLÊý¾Ý¿â¸ÄÃû·½·¨

°ÑOldÊý¾Ý¿â¸ÄΪNewÊý¾Ý¿â
1.´ò¿ª“ÆóÒµ¹ÜÀíÆ÷”ÕÒµ½ OldÊý¾Ý¿â£­£­¡·ÓÒ¼ü£­£­¡·ËùÓÐÈÎÎñ£­£­¡··ÖÀëÊý¾Ý¿â
2.µ½C:\Program Files\Microsoft SQL Server\MSSQL\DataÏÂÕÒµ½Old_Data.mdfºÍOld_log.ldf°ÑOld_Data»»³ÉÄãÏëÒªµÄÃû×ÖÀýÈçNew.mdf¡¢New.ldf
3.µ½ÆóÒµ¹ÜÀíÆ÷£¬ÕÒµ½ Êý¾Ý¿â £­£­¡·ÓÒ¼ü£­£­¡·ËùÓÐÈÎÎñ£­£­¡ ......

PL/SQLѧϰ±Ê¼ÇÈý


1.Ìõ¼þ¿ØÖÆ
1.1 if .. then .. end if
if Ìõ¼þ then
    Óï¾ä¶Î£»
end if;
1.2 if .. then .. else .. end if
if Ìõ¼þ then
    Óï¾ä¶Î£»
else 
    Óï¾ä¶Î£»
end if;
1.3 ifǶÌ×
2.Ñ­»·¿ØÖÆ
2.1 loop .. exit .. end loop
loop  
   & ......

SQL*Plus FAQ

 What is SQL*Plus and where does it come from?
SQL*Plus is a command line SQL and PL/SQL language interface and reporting tool that ships with the Oracle Database Client and Server software. It can be used interactively or driven from scripts. SQL*Plus is frequently used by DBAs and Developers ......

ʹÓÃset statistics on À´¼ì²ésql tuningµÄ½á¹û


ÔÚSQL Server2005/2008ÖпÉÒÔʹÓÃÒ»ÏÂËĸöÃüÁîÀ´µ÷ÓÅsqlÓï¾äÒÔ¼°¼ì²éµ÷ÓŵĽá¹û
set
 statistics time on

set
 statistics IO on

set
 statistics profile on

set
 statistics xml on

......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ