imrexhuang

// ----
// Sass (v3.3.10)
// Compass (v1.0.0.alpha.20)
// ----


$colorA:#5538c8;
$colorB:#137EDC;
$colorC:#74a098;
$colorD:#a08874;

imrexhuang

// ----
// Sass (v3.3.10)
// Compass (v1.0.0.alpha.20)
// ----

//http://sassandcompass.com 
//Sass and Compass for Designers第三章範例

$colorA:#5538c8;
$colorB:#137EDC;

imrexhuang

// ----
// Sass (v3.3.10)
// Compass (v1.0.0.alpha.20)
// ----

$defined-bs-type: border-box;
$defined-bs-type: sausages !default;
@mixin bs($bs-type: $defined-bs-type) {
	-webkit-box-sizing: $bs-type;
	-moz-box-sizing: $bs-type;

imrexhuang

// ----
// Sass (v3.3.10)
// Compass (v1.0.0.alpha.20)
// ----

$defined-bs-type: sausages !default;
@mixin bs($bs-type: $defined-bs-type) {
	-webkit-box-sizing: $bs-type;
	-moz-box-sizing: $bs-type;
	box-sizing: $bs-type;

imrexhuang

Declare @Path Nvarchar(2000)

Set @Path ='C:\Backup\TSQL\Archive_Log_'+Replace(Convert(Nvarchar,Sysdatetime(),120),':','')+'.trn'

BACKUP LOG [TSQL] TO DISK = @Path WITH COMPRESSION

imrexhuang

-- Source: http://dba.stackexchange.com/questions/11005/sql-server-2008-r2-query-last-successful-database-backup-for-all-dbs
SELECT TOP 100 
    s.database_name, 
    m.physical_device_name,
    CAST(DATEDIFF(second, s.backup_start_date,
    s.backup_finish_date) AS VARCHAR(100)) + ' ' + 'Seconds' TimeTaken,
    s.backup_start_date,
    CASE s.[type]
    WHEN 'D' THEN 'Full'
    WHEN 'I' THEN 'Differential'

imrexhuang

--參考 https://technet.microsoft.com/zh-tw/library/ms190193(v=sql.105).aspx

--宣告儲存Error的變數
DECLARE @ErrorVar INT

--產生Error
SELECT 6 / 0;
--RAISERROR(N'Message', 16, 1);

--儲存Error

imrexhuang

--參考 https://technet.microsoft.com/zh-tw/library/ms190193(v=sql.105).aspx

--宣告儲存Error的變數
DECLARE @ErrorVar INT

--產生Error
SELECT 6 / 2;
--RAISERROR(N'Message', 16, 1);

--儲存Error

imrexhuang

--SQL Server 2012 T-SQL資料庫設計 (悅知文化)
--http://www.delightpress.com.tw/book.aspx?book_id=skud00022
--CH06 P.363

USE Northwind
 
SELECT ProductID,UnitPrice,
CASE
     WHEN UnitPrice < 50 THEN '低於 50'
     WHEN UnitPrice >= 50 AND UnitPrice<100 THEN '低於 100'

imrexhuang

USE AdventureWorks2014
SELECT CONVERT(char(7), OrderDate,21) AS 訂單月份,
CONVERT(char(10), OrderDate, 21) AS 訂單日期,*
FROM Sales.SalesOrderHeader
ORDER BY OrderDate DESC