ASP.net , C#, and VB.net , and Java, and SQL

coding and testing
博客园 首页 新随笔 联系 订阅 管理

2012年4月13日 #

showplan_all
摘要： USE AdventureWorks2012; GO SET SHOWPLAN_ALL ON; GO -- First query. SELECT BusinessEntityID FROM HumanResources.Employee WHERE NationalIDNumber = '509647174'; GO -- Second query. SELECT BusinessEntityID, EmergencyContactID FROM HumanResources.Employee WHERE EmergencyContactID LIKE '1%' 阅读全文
posted @ 2012-04-13 13:23 mr liao 阅读(354) 评论(0) 推荐(0) 编辑

cross apply / outer apply
摘要： refence: http://hypgr.iteye.com/blog/260112 阅读全文
posted @ 2012-04-13 13:22 mr liao 阅读(164) 评论(0) 推荐(0) 编辑

DataTable 的DataView.RowFilter DataTable.Rows.Find 和 DataTable.Select
摘要： http://stackoverflow.com/questions/2832304/dataview-rowfilter-vs-datatable-select-vs-datatable-rows-findhttp://www.dotblogs.com.tw/jeff-yeh/archive/2010/09/28/17972.aspx比较 Moonground's post sums it up nicely: DataView.RowFilter is for binding.DataTable.Rows.Find is for searching by... 阅读全文
posted @ 2012-04-13 13:18 mr liao 阅读(2747) 评论(0) 推荐(0) 编辑

DataTable
摘要： http://stackoverflow.com/questions/2832304/dataview-rowfilter-vs-datatable-select-vs-datatable-rows-find 阅读全文
posted @ 2012-04-13 13:16 mr liao 阅读(217) 评论(0) 推荐(0) 编辑

引用[C#]合併兩個DataTable (更新)
摘要： 引用http://www.dotblogs.com.tw/kennyshu/archive/2009/06/16/8853.aspx 也許有人和我一樣有這樣的需求，所以分享給有需要的人。01 public static void AppendDataTable(DataTable hostDt, DataTable clientDt)02 {03 if (hostDt != null && hostDt.Rows.Count > 0)04 {05 DataRow dr;06 07 for (int i = 0; i < clientDt.Columns.Co... 阅读全文
posted @ 2012-04-13 13:15 mr liao 阅读(2311) 评论(0) 推荐(0) 编辑