MSSQL语句

来源：互联网发布：乐视tv网络电视投影编辑：程序博客网时间：2024/05/18 02:50

1、去除表中某个字段对应的值中的空格？？update ST_PPTN_D set STNM=REPLACE(STNM,' ', ''); 2、根据一个表中筛选出来的字段去更新另一个表中的某个对应字段？？update ST_RSVR_D  set ST_RSVR_D.LGTD=tt.LGTD,ST_RSVR_D.LTTD=tt.LTTD  from   (     select 水位站编码,LGTD,LTTD from 水位站 where      LGTD is not null and LTTD is not null and LGTD<>'' and LTTD<>'' and       slasttime is not null and slasttime>'2012-01-01'  ) tt  where ST_RSVR_D.STCD=tt.水位站编码   asp.net分页的SQL语句select * from ( select *,Row_Number() over(order by id) RowNumber from 表名) t where t.RowNumber>=1 and t.RowNumber<=10; //SQL   SERVER中定义变量模糊查询(带分页)declare  @ProjectName varchar(200);set  @ProjectName ='LCOS高新';select * from (select s.ID,s.ProjectName,s.ContractNumber,s.ProjectNO,case s.Lbt1  when 1 then  '已收样'  when  2 then  '任务指派'  when  3 then

'试验出报告' else '其它' end  as 'Lbt1' ,ROW_NUMBER() OVER(ORDER BY  s.ID DESC) as PagerAutoRowNumber from  LabsFlow s  where  (s.Lbt1=1  or s.Lbt1=2)  and  CHARINDEX(@ProjectName,s.ProjectName)>0) as PagerTempTable where PagerAutoRowNumber between 1 and 1000

----SQL查询表有多少列Select count(Name) From SysColumns Where id=Object_Id('dbo.DeviceSY')----SQL查询表列名称Select name from syscolumns Where ID=OBJECT_ID('dbo.DeviceSY')

阅读全文

0 0