使用資料表更新資料表

	UPDATE TableA
	SET TableA.FullName = B.FullName
	FROM TableB AS B
	WHERE TableA.AccountID = B.Account_ID

view raw update.sql hosted with ❤ by GitHub

---

sql server - SQL update from one Table to another based on a ID match - Stack Overflow

Simple Full Screen Overlay

---

jquery: how can i create a simple overlay? - Stack Overflow

SQLite3 Create Table 設定欄位預設值為目前時間

CREATE TABLE TestTable (UID INTEGER PRIMARY KEY AUTOINCREMENT,Title TEXT,AddDate TIMESTAMP DEFAULT CURRENT_TIMESTAMP)

view raw GMT.sql hosted with ❤ by GitHub

CREATE TABLE TestTable (UID INTEGER PRIMARY KEY AUTOINCREMENT,Title TEXT,AddDate date DEFAULT (datetime('now','localtime')))

view raw Localtime.sql hosted with ❤ by GitHub

---

sql - Sqlite: CURRENT_TIMESTAMP is in GMT, not the timezone of the machine - Stack Overflow sql - sqlite database default time value 'now' - Stack Overflow

DataTable 轉 Excel

	Dim hssfworkbook As New HSSFWorkbook()
	Using msNew As New IO.MemoryStream()
	Dim sheet As HSSFSheet = hssfworkbook.CreateSheet("ThisIsSheetName")
	Dim nrowHeader As HSSFRow = sheet.CreateRow(0)
	For h As Integer = 0 To dt.Columns.Count - 1
	nrowHeader.CreateCell(h).SetCellValue(dt.Columns(h).ColumnName)
	Next
	For intRow As Integer = 0 To dt.Rows.Count - 1
	Dim nrowNew As HSSFRow = sheet.CreateRow(intRow + 1)
	For intCol As Integer = 0 To dt.Columns.Count - 1
	nrowNew.CreateCell(intCol).SetCellValue(dt.Rows(intRow)(intCol).ToString.Trim)
	Next
	Next
	'sheet.AutoSizeColumn(CShort(0))
	'sheet.AutoSizeColumn(CShort(1))
	'sheet.AutoSizeColumn(CShort(2))
	'sheet.AutoSizeColumn(CShort(3))
	hssfworkbook.Write(msNew)
	hssfworkbook = Nothing
	Dim strFileName As String = "Sheet_" & Now.ToString("yyyyMMddHHmmss") & ".xls"
	Dim strExcelFilePath As String = Server.MapPath("") & "\" & strFileName
	Using fs As IO.FileStream = File.OpenWrite(strExcelFilePath)
	msNew.WriteTo(fs)
	End Using
	Response.Redirect("Download.ashx?file=" & strFileName)
	End Using

view raw utils.vb hosted with ❤ by GitHub

EnterpriseLibrary 常用語法

Imports System.Data.Common
Imports Microsoft.Practices.EnterpriseLibrary.Data

npm列出全部安裝套件

npm -g ls --depth=0

調整照片Exif時間 (jhead)

 -ta<+|->h[:mm[:ss]]
            Adjust time by h:mm forwards or backwards.  Useful when having
            taken pictures with the wrong time set on the camera, such as when
            traveling across time zones or DST changes. Dates can be adjusted
            by offsetting by 24 hours or more.  For large date adjustments,
            use the -da option

jhead -ta+48 D:\Pic\*.jpg