康拍樂 compiler note

SELECT name, recovery_model_desc  FROM sys.databases --修改簡單模式 USE master ; ALTER DATABASE TESTDB SET RECOVERY SIMPLE;

SELECT name, physical_name ,size FROM sys.master_files order by size desc

刪除語法： DECLARE @publicationDB AS sysname; DECLARE @publication AS sysname; SET @publicationDB = N'IOEWEBSR1'; SET @publication = N'IOE'; -- Remove a transactional publication. --USE [AdventureWorks2008R2] EXEC sp_droppublication @publication = @publication; -- Remove replication objects from the database. USE [master] EXEC sp_replicationdboption   @dbname = @publicationDB,   @optname = N'publish',   @value = N'false'; GO 參考：http://msdn.microsoft.com/zh-tw/library/ms147833.aspx 如果遇到"無法刪除發行集"的狀況 刪除發行集發生主體dbo不存在 解決方法 (1).先停用 SQL Server Agent ，再按右鍵刪除 (2). 方法一： ALTER AUTHORIZATION ON DATABASE::[輸入出問題的資料庫名稱] TO [資料庫管理員帳號] 方法二： USE [出問題的資料庫名稱] GO EXEC sp_changedbowner '資料庫管理員帳號'  GO http://msdn.microsoft.com/zh-tw/library/ms178630.aspx

 IIS Express 要設定 configuration / metabase file  等等，需設定config 檔案通常放置於此(可能會依電腦不用有異)  My Documents > IIS Express > config usually (not always) one of these paths will work  %userprofile%\documents\iisexpress\config\applicationhost.config %userprofile%\my documents\iisexpress\config\applicationhost.config

SQL 資料存在就更新，不存在就新增一筆寫法 方法1： IF EXISTS (SELECT * FROM Table1 WHERE Column1='value1')     UPDATE Table1 SET Column2='value2' WHERE Column1='value1' ELSE     INSERT INTO Table1 VALUES ('value1','value2') 方法2： UPDATE Table1 SET  Column2='value2' WHERE Column1='value1' IF @@ROWCOUNT=0     INSERT INTO Table1 VALUES (...)

解決IE 在iframe 下 網站session 遺失問題 How to set p3p http header in ASP.Net? HttpContext.Current.Response.AddHeader("p3p", "CP=\""IDC DSP COR ADM DEVi TAIi PSA PSD IVAi IVDi CONi HIS OUR IND CNT\""); How to set p3p http header in PHP? header('P3P:CP="IDC DSP COR ADM DEVi TAIi PSA PSD IVAi IVDi CONi HIS OUR IND CNT"'); How to set p3p http header in JSP? response.setHeader("P3P","CP='IDC DSP COR ADM DEVi TAIi PSA PSD IVAi IVDi CONi HIS OUR IND CNT'") How to set p3p http header in ColdFusion?