摘要:
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[f_convert]') and xtype in (N'FN', N'IF', N'TF')) drop function [dbo].[f_convert] GO ... 阅读全文
摘要:
declare @name varchar(800),@sqls nvarchar(500) DECLARE curObject1 CURSOR FOR --声明游标 select [name] from sysobjects where xtype='U' and name'dtproperties' order by [name] OPE... 阅读全文
摘要:
要查询案卷表中的重复纪录,比如是否有单位重复的纪录,可以使用下列的方法 SELECT * FROM jkarchvol WHERE (vol_unit IN (SELECT vol_unit FROM jkarchvol GROUP BY vol_unit HAVING COUNT(*) > 1)) 做的时候出现多个字段重复... 阅读全文