数据库/LINQ
besley
十年以上企业信息系统架构设计 SaaS软件架构设计和云计算平台研发团队管理经验 提供信息系统 WEB技术 工作流系统 研发团队管理和项目管理等咨询服务
展开
-
LINQ查询XML字段
How to filter XML elements using LINQ query for one attribute/field containing a particular substring?原文地址:http://stackoverflow.com/questions/8311373/how-to-filter-xml-elements-using-linq-quer转载 2012-08-01 10:35:41 · 1043 阅读 · 0 评论 -
数据库 GUID vs INT 作为主键的性能辨析
GUID vs INT Debatehttp://blogs.msdn.com/b/sqlserverfaq/archive/2010/05/27/guid-vs-int-debate.aspxAmruthaVarshiniJ 27 May 2010 4:37 AM 3I recently read a blog post on what was b转载 2013-05-24 11:07:27 · 2089 阅读 · 0 评论 -
SQL 递归查询语句
How to use recursive CTE calls in T-SQLA common table expression (CTE) in T-SQL is used by many to get around the internal referencing problem inderived tables. It also gives you a bet转载 2014-11-04 11:48:05 · 807 阅读 · 0 评论 -
T-SQL 递归查询示例
1. 数据库表创建-- Create an Employee table.CREATE TABLE dbo.MyEmployees( EmployeeID smallint NOT NULL, FirstName nvarchar(30) NOT NULL, LastName nvarchar(40) NOT NULL, Title nvarchar(50) NOT NUL原创 2014-11-05 11:29:14 · 1022 阅读 · 0 评论