(TSQL)組出DAOImpl.cs所需程式碼

	--組成C#的insert指令
	--StringBuilder sb_insertcmd = new StringBuilder();
	--sb_insertcmd.AppendLine(@"INSERT INTO "+this.schema+".[XYZ123]");
	SELECT 'sb_insertcmd.AppendLine(@" (['+COLUMN_NAME+']");' FROM INFORMATION_SCHEMA.COLUMNS
	WHERE TABLE_SCHEMA = 'dbo' AND TABLE_NAME = 'XYZ123'

view raw gistfile1.txt hosted with ❤ by GitHub