2008年12月01日 星期一
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
exec(@sql)
drop table aaa
Posted in 技术 | Tags: SQL, 代码 | No Comments »
2008年09月18日 星期四
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 });
Posted in 技术 | Tags: LinQ, SQL, 代码 | No Comments »