LINQ+to+SQL 源代码

select lower('i LOVE you') as 小写字母 select upper('please reading') as 大写字母 select replicate('go',10) as 复制函数 select reverse('uoy…

select max(gpdj) as 最贵光盘价格, min(gpdj) as 最便宜价格 ,sum(gpdj*qnt) as 总共价值 , avg(gpdj) as 平均价格 from gpb

select * from employee where ygxm like '[^李]%'

select 光盘编号=gph ,光盘名称=gpmc,光盘语言=gpyy from gpb where gph between 2 and 7

select * from employee where ygbh in ( 2,4,6)

select count(gpsm) as 'count',count(*) AS 'count(*)' from gpb

select exp(4) as '4的指数',log(100)as '100的对数', pi()as 圆周率,rand(3) as 随机函数 select sign(-19) as '-19的符号函数',sqrt(25) as '25的根号', squ…

select * from employee where ygxm like '[^李]%'

select * from ghsb order by 3 DESC