sql查询员工入职多少天_sql 查询四舍五入_sql怎么四舍五入(18)

end

select 'VCS'=sourcecode from #commenttext order by id

select 'SQL'=text from syscomments where id = object_id(@vchObjectName) order by colid

end

CleanUp:

return

E_OAError:

exec dbo.dt_displayoaerror @iObjectId, @iReturn

GOTO CleanUp

GO

看的我直晕~！

Top

1.如果 T 表还有一字段 F0 数据类型为自动增量整型(唯一,不会重复),

而且 T 表中含有除 F0 字段外,请删除其它字段完全相同的重复多余的脏记录数据:

delete from twhere f0 in(select max(f0) from t group by f1,f2,f3,f4,f5,f6,f7 having count(f0)>1)

上面这个sql有问题

正确的如下

DELETE Legal_Dispute_Lawyer WHERE Lawyer_Record_No IN(SELECT Lawyer_Record_No FROM Legal_Dispute_Lawyer LDL WHERE Lawyer_Record_No(SELECT TOP 1 Lawyer_Record_No FROM Legal_Dispute_Lawyer WHERE LD=LDL.LD AND Name=LDL.Name AND Email=LDL.Email AND Phone_No=LDL.Phone_No AND Fax_No=LDL.Fax_No))

消除Legal_Dispute_Lawyer 表中除Lawyer_Record_No(自增字段)外其余数据完全相同的记录.

表结构如下

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Legal_Dispute_Lawyer]') and OECTPROPERTY(id, N'IsUserTable') = 1)

drop table [dbo].[Legal_Dispute_Lawyer]

GO

CREATE TABLE [dbo].[Legal_Dispute_Lawyer] (

[Lawyer_Record_No] [int] IDENTITY (1, 1) NOT NULL ,

[LD] [int] NOT NULL ,

[Name] [int] NOT NULL ,

[Phone_No] [varchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,

[Fax_No] [varchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,

400)this.width=400'>screen.width-500)this.style.width=screen.width-500;" align=center border=0> [varchar] (255) COLLATE Chinese_PRC_CI_AS NULL

) ON [PRIMARY]

GO

以这种方式还可以实现组内消除重复值..

Top

DELETE Legal_Dispute_Lawyer WHERE Lawyer_Record_No IN(SELECT Lawyer_Record_No FROM Legal_Dispute_Lawyer LDL WHERE Lawyer_Record_No<>(SELECT TOP 1 Lawyer_Record_No FROM Legal_Dispute_Lawyer WHERE LD=LDL.LD AND Name=LDL.Name AND Email=LDL.Email AND Phone_No=LDL.Phone_No AND Fax_No=LDL.Fax_No))

本文来自电脑杂谈，转载请注明本文网址：
https://www.pc-fly.com/a/ruanjian/article-30385-18.html