一个简单的存储过程..... ( 积分: 0 )

我想实现判断一个表是否有重复的字段值.参数是:表名,字段名,比较值.<br>我用下面的写法不行.请哪位高手指点...<br>CREATE&nbsp;PROCEDURE&nbsp;[dbo].[FieldValueCount]&nbsp;<br>&nbsp;&nbsp;@tName&nbsp;varchar(20),@fName&nbsp;varchar(20),&nbsp;@fValue&nbsp;varchar(50)<br>AS<br>select&nbsp;count(*)&nbsp;from&nbsp;@tName&nbsp;where&nbsp;@fName=@fValue<br>GO

使用Group&nbsp;by&nbsp;进行分组，试一下

select&nbsp;字段名&nbsp;from&nbsp;表名&nbsp;group&nbsp;by&nbsp;字段名&nbsp;having&nbsp;count(*)&gt;1