Tag Archive [SQL]

Posts Tagged ‘SQL’

SQL脚本 — 行变列 »

Posted 十二月 1st, 2008 by o2ho in category 技术

create table aaa ( col nvarchar(10) ) insert into aaa select 1 union select 2 union select 3 declare @sql varchar(8000) set @sql='select ' select  @sql=@sql+'max(case col when '''+ col +''' then col end) + '','' + ' from (select distinct col from aaa)  a set @sql=left(@sql,len(@sql)-1) set @sql=@sql+'  from aaa' --print @sql

Continue Reading »

在 LinQ 语句中实现 Left Join 操作 »

Posted 九月 18th, 2008 by o2ho in category 技术

var query = (from p in dc.GetTable<Person>() join pa in dc.GetTable<PersonAddress>() on p.Id equals pa.PersonId into tempAddresses from addresses in tempAddresses.DefaultIfEmpty(new PersonAddress()) select new { p.FirstName, p.LastName, addresses.State });

Continue Reading »