SQL中的@@ ROWCOUNT值

本文介绍了SQL中的@@ ROWCOUNT值的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！ 问题描述

亲爱的朋友， 我已经创建了一个过程，并且使用了if(如果存在)来获取值.

Dear Friends, I have created a Procedure and i have used if exists to get the values.

SELECT * FROM MY_DATA WITH (NOLOCK) IF @@ROWCOUNT>=1 BEGIN SELECT * FROM MY_DETAIL WITH (NOLOCK) END ELSE BEGIN SELECT 'NO RECORDS' END

在此，我得到了My_Data值加上My_detail表值. 但是我只想获取My_Detail表值，如何避免My_data记录. 请提出相同的建议.

In this I have getting My_Data values plus My_detail table values. But I want to get only My_Detail table value, how to avoid My_data records. Kindly suggest for the same.

推荐答案

declare @count varchar(50) select @count=count(1) from MY_DATA WITH (NOLOCK) IF @count>=1 BEGIN SELECT * FROM MY_DETAIL WITH (NOLOCK) END ELSE BEGIN SELECT 'NO RECORDS' END

SELECT * FROM MY_DETAIL WITH (NOLOCK) WHERE EXISTS (SELECT MAX(1) FROM MY_DATA WITH (NOLOCK) )