SQL语句

 

------查询当月明天要过生日的会员
select  *  from table where len(生日字段)!=0  and month(cast(生日字段 as datetime))=month(getdate()) and   day(dateadd(day,-1,cast(生日字段 as datetime)))=day(getdate()) 

 

-----作者表-->专家表  姓名相同并且性别不同的数据导进去
insert into dbo.Expert_S_Base ( code,xm,xb,dwphone,dwdz,gzdw,zc,jtdz,email,dwyzbm,csrq )
select  b.id ,b.zzxm ,b.sex,b.lxdh,b.dwdz,b.dw,b.zc,b.jtdz,b.dzyx,b.yb,b.csny from  Expert_S_Base a,ResearchZZinfo b
 where a.xm =b.zzxm and a.xb !=b.sex

 

-- 查某xm 字段重复的数据
select * from ResearchZZinfo where zzxm in (select zzxm from ResearchZZinfo group by zzxm having count(1) >= 2)

 

-----建三表视图

SELECT     b.ID, a.STMC, b.SSST, b.LDRXM, b.STZW, b.STZW2, c.LXMC
FROM            slbiz.dbo.Society_B_User AS a INNER JOIN
                      slbiz.dbo.Society_B_Leaders AS b ON a.ID = b.SSST INNER JOIN
                      slbiz.dbo.Society_D_DicItem AS c ON b.STZW = c.ID