This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
WITH CTE AS ( | |
/* 共通テーブル式(CTE) */ | |
SELECT | |
CONVERT(DATETIME, '2017/09/02 21:30:10') AS T | |
) | |
SELECT | |
c.T /* 対象日時 */ | |
,DATEPART(YEAR, c.T ) AS IntYear /* 年を取得(int型) */ | |
,DATEPART(MONTH, c.T ) AS IntMonth /* 月を取得(int型) */ | |
,DATEPART(DAY, c.T ) AS IntDay /* 日を取得(int型) */ |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
<div><strong>件名:</strong> {{ message.subject }}</div> | |
<div><strong>送信者:</strong> {{ message.sender }}</div> | |
<div><strong>日時:</strong> {{ message.date }}</div> | |
<div> | |
<strong>宛先:</strong> | |
<span ng-repeat="recipient in message.recipients">{{ recipient }}</span> | |
</div> | |
<div>{{ message.message }}</div> | |
<a href="#/">メッセージのリストに戻る</a> |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
Option Explicit | |
' 参照設定の[Microsoft Scripting Runtime]が必要 | |
' 標準モジュールに記載してください | |
' ---------------------------------------------------------- | |
' 概 要:差集合(A - B)の結果をカンマと改行区切りで返す | |
' 引 数:A 引かれる側のRange | |
' 引 数:B 引く側のRange | |
' 引 数:CompareMode 比較モード(省略時は0) 0:バイナリ(大文字小文字を区別する) 1:テキスト(大文字小文字を区別しない) |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
Option Explicit | |
' Sheet1に1万行データを書き込むサンプルコードです | |
' 以下の参照設定が必要です | |
' [Microsoft ActiveX Data Object X.X Library] | |
' ---------------------------------------------------------- | |
' 名 称:Main | |
' 引 数:なし |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
<!DOCTYPE html> | |
<html lang="ja" ng-app="myApp"> | |
<head> | |
<meta charset="utf-8"> | |
<meta http-equiv="X-UA-Compatible" content="IE=9"> | |
<meta name="viewport" content="width=device-width, initial-scale=1"> | |
<title>HTAとAngularJSと、時々、VBScript</title> | |
<!-- angularjs --> | |
<script src="https://ajax.googleapis.com/ajax/libs/angularjs/1.5.8/angular.min.js"></script> |