Skip to content

Instantly share code, notes, and snippets.

View Rotceh's full-sized avatar

Rotceh

0 followers · 9 following
View GitHub Profile
@Rotceh
Rotceh / runListSqlcmd.bat
Created July 19, 2017 09:31
執行list.sql的批次檔
@echo off
rem 資料庫IP\資料庫執行個體名稱
set dbIp=stanley\SQL2014
rem 資料庫名稱
set dbName=TSQL2014
rem 登入帳號
set dbUsrAcc=ImDeveloper
rem 使用者密碼
set dbUsrPwd=Passw0rd
rem 清單.SQL檔放置路徑
@Rotceh
Rotceh / list.sql
Created July 19, 2017 09:29
將多個sql script以一個SQLCMD列表
:r .\sql01.sql
:r .\sql02.sql
:r .\sql03.sql
:r .\sql04.sql
:r .\sql05.sql
:r C:\testDB\db_script\sql06.sql
@Rotceh
Rotceh / sqlcmdOndirectory.bat
Created July 19, 2017 09:24
執行指定目錄內的.sql腳本
@echo off
rem 資料庫IP\資料庫執行個體名稱
set dbIp=stanley\SQL2014
rem 資料庫名稱
set dbName=TSQL2014
rem 登入帳號
set dbUsrAcc=ImDeveloper
rem 使用者密碼
set dbUsrPwd=Passw0rd
rem 整理完畢的SQL指令集資料夾位置
@Rotceh
Rotceh / IncludeSample
Created April 6, 2017 01:19
Include的時機
方法一
<jsp:include page="網頁名稱"> 或
<jsp:include page="網頁名稱">
<jsp:param name="參數1" value="值1" />
<jsp:param name="參數2" value="值2" />
.....
<jsp:include/>
此為JSP的Action,因此適用於不同page 間的控制權轉移，並且可以允許參數的傳入。
例如希望能在原A page 執行到一半，include 另一個B page的程式來執行(將程式的執行權轉
@Rotceh
Rotceh / gist:e3d42e9860a2c463ef530839f77245a0
Last active March 14, 2017 10:24
sql_create
CREATE DATABASE IBATIS_DEMO;
USE IBATIS_DEMO;
CREATE TABLE EMPLOYEE (
id INT NOT NULL auto_increment,
first_name VARCHAR(20) default NULL,
last_name VARCHAR(20) default NULL,
salary INT default NULL,
PRIMARY KEY (id)
);
@Rotceh
Rotceh / myToReadBookLists.md
Created July 13, 2016 18:08 — forked from chusiang/myToReadBookLists.md
凍仁的讀書清單
@Rotceh
Rotceh / Test_Gist.c
Created September 3, 2015 03:21
Test code segment
#include<stdio.h>
int main(){
printf("Hello github!");
return 0;
}