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

(Microsoft SQL Server£¬´íÎó: 3219)

MSSQL»¹Ô­Êý¾Ý¿âʧ°Ü£¬ÌáʾÈçÏ£º »¹Ô­¶ÔÓë·þÎñÆ÷ ʧ°Ü¡£(Microsoft.SqlServer.Smo) ÆäËüÐÅÏ¢£º ©§ ©»¡úÖ´ÐÐTransact-SQLÓï¾ä»òÅú´¦Àíʱ·¢ÉúÒì³£¡££¨Microsoft.SqlServer.ConnectionsInfo£© ©§ ©»¡ú²»ÄÜÑ¡ÔñÎļþ»òÎļþ×é¡°¡­¡­¡±ÓÃÓڴ˲Ù×÷¡£ RESTORE DATABASE ÕýÔÚÒì³£ÖÕÖ¹¡££¨Microsoft SQL Server, ´íÎó£º3219£© ³öÏÖ´Ë´íÎóʱÎҵIJÙ×÷²½ÖèΪ£º ÓÒ»÷Êý¾Ý¿â¡·¡·ÈÎÎñ¡·¡·»¹Ô­¡·¡·ÎļþºÍÎļþ×é¡·¡·Ô´É豸£¨Ñ¡Ôñ±¸·ÝÎļþ£©¡·¡·Ö¸¶¨±¸·ÝÎļþλÖá·¡·Ìí¼ÓÑ¡¶¨Îļþ¡£ ÔÚ¡°»¹Ô­ÎļþºÍÎļþ×顱¶Ô»°¿òÖеã»÷¡°È·¶¨¡±°´Å¥£¬¼´³öÏÖÉÏÃæÏÔʾµÄ´íÎó¡£ ÕýÈ·µÄ²½ÖèΪ£º ÓÒ»÷Êý¾Ý¿â¡·¡·ÈÎÎñ¡·¡·»¹Ô­¡·¡·Êý¾Ý¿â¡·¡·Ô´É豸£¨Ñ¡Ôñ±¸·ÝÎļþ£©¡·¡·Ö¸¶¨±¸·ÝÎļþλÖá·¡·Ìí¼ÓÑ¡¶¨Îļþ¡£ ÔÚ¡°»¹Ô­Êý¾Ý¿â¡±¶Ô»°¿òÖеã»÷¡°È·¶¨¡±°´Å¥£¬¼´¿ÉÕýÈ·»¹Ô­¡£ Ö÷ÒªÔ­Òò£º ÎļþºÍÎļþ×鱸·Ý±ØÐë±»»¹Ô­µ½Æ¥ÅäµÄÊý¾Ý¿â »¹Ô­ÎļþºÍÎļþ×鱸·Ý SQL Server µÄ˵Ã÷µÄÏêϸÐÅÏ¢¿É¼û£º http://support.microsoft.com/kb/281122/zh-cn ÖÁÓÚ¡°»¹Ô­Êý¾Ý¿â¡±ºÍ¡°»¹Ô­ÎļþºÍÎļþ×顱µÄÇø±ð¿ÉÒÔ¼û´ËÎÄÕ£ºhttp://www.cnblogs.com/zping/archive/2008/08/21/1272961.html


Ïà¹ØÎĵµ£º

sql °Ñ±íµ¼³É.TXTÎļþ

sql ´úÂë:
---------------------------------------------------------
/*
  a        ±íÃû
  Èç¹ûÔÚsql ²éѯ·ÖÎöÆ÷µ±ÖгöÏÖ
  " SQL Server ×èÖ¹Á˶Ô×é¼þ 'xp_cmdshell' µÄ ¹ý³Ì'sys.xp_cmdshell' µÄ·ÃÎÊ£¬ÒòΪ´Ë×é¼þÒÑ×÷Ϊ´Ë·þÎñÆ÷°²È«ÅäÖõÄÒ»²¿·Ö¶ø±»¹Ø± ......

SQL Server 2005 ¾µÏñ¹¹½¨ÊÖ²á

Ò»¡¢ ¾µÏñ¼ò½é
1¡¢ ¼ò½é
Êý¾Ý¿â¾µÏñÊǽ«Êý¾Ý¿âÊÂÎñ´¦Àí´ÓÒ»¸öSQL ServerÊý¾Ý¿âÒÆ¶¯µ½²»Í¬SQL Server»·¾³ÖеÄÁíÒ»¸öSQL ServerÊý¾Ý¿âÖС£¾µÏñ²»ÄÜÖ±½Ó·ÃÎÊ;ËüÖ»ÓÃÔÚ´íÎó»Ö¸´µÄÇé¿öϲſÉÒÔ±»·ÃÎÊ¡£
Òª½øÐÐÊý¾Ý¿â¾µÏñËùÐèµÄ×îСÐèÇó°üÀ¨ÁËÁ½¸ö²»Í¬µÄSQL ServerÔËÐл·¾³¡£Ö÷·þÎñÆ÷±»³ÆÎª“Ö÷»ú”£¬µÚ¶þ¸ö·þÎñÆ÷±» ......

SQL Server 2005 ¾µÏñ¹¦ÄÜʵÏÖ

SQL Server 2005 ¾µÏñ¹¦ÄÜʵÏÖ
1. Ö÷»ú¡¢¾µÏñ·Ö±ðMASTER KEY¡£
Ö÷»úÖ´ÐУº 
USE master;  
  
CREATE MASTER KEY ENCRYPTION BY PASSWORD = 'password';  
  
CREATE CERTIFICATE HOST_A_cert WITH  ......

How do I release sql express database?


Questions
I have a simple app that
uses an SQL Express 2005 database. When the user closes the app, I want
to give the option to back up the database by making a copy in another
directory. However, when I try to do it, I get "The process cannot
access the file '...\Pricing.MDF' because i ......

SQL °´ÖÜ,ÔÂ,¼¾¶È,Äê²éѯͳ¼ÆÊý¾Ý

//°´×ÔÈ»ÖÜͳ¼Æ 
select to_char(date,'iw'),sum() 
from 
where 
group by to_char(date,'iw') 
//°´×ÔÈ»ÔÂͳ¼Æ 
select to_char(date,'mm'),sum() 
from 
where 
group by to_char(date,'mm') 
//°´¼¾Í³¼Æ 
select to_char(date,'q'),sum() 
fr ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ