SQL中的@@ ROWCOUNT值 [英] @@ROWCOUNT values in SQL

问题描述

亲爱的朋友，

我已经创建了一个过程，并且使用了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值的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！