本文介绍了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) )
更多推荐
SQL中的@@ ROWCOUNT值
发布评论