You must Sign In to post a response.
  • Category: SQL Server

    Solve the below query

    hi every one,
    Please solve this....
    i'm trying but not getting.
    it shows 0 rows effecting.

    Declare @newdate datetime
    set @newdate=dateadd(month,2,getdate())
    update Tbl_User_Reg set SubscriptionName='Basic',CreateDate=@newdate where UserRegId='10'
  • #766818
    Hi Sadiq,

    Please check whether the table Tbl_User_Reg contains UserRegId value as 10. If it is not then it will display
    (0 row(s) affected)

    Simiyon A

  • #766819

    Have you tried this query

    select * from Tbl_User_Reg where UserRegId='10'

    Whether it returns any records?

    I guess the problem is there is no rows in that select statement, if records found for to the above statement then it will definitely update the columns and return the effected rows count.

    Give respect to your work, Instead of trying to impress your boss.

    Blog :

  • #766822
    Is the UserRegId varchar?.
    Can you check is there any spaces in the table data?

    Try to get
    select * from Tbl_User_Reg where UserRegId='10'

    If your are not getting any row then the problem is in the data

    select * from Tbl_User_Reg where UserRegId like '10' and check whether any spaces there in the data.

    By Nathan
    Direction is important than speed

  • #766842
    the return message itself very descriptive, if your message says '0 row affected' it does means, you have no rows that fitted in WHERE condition
    in short according to your query, check if column 'UserRegId' is having value '10'
    Hope it helps

    Editor, DotNetSpider MVM
    Microsoft MVP 2014 [ASP.NET/IIS]

  • #766852
    Lot of Possibilities are there for showing this Error Messages.
    1. There is no records in the table based on UserRegid is 10
    2. May be there is no records in the table too.
    3. Otherwise, That column could not based on Varchar.

    So, Share your table structure. Or . Kindly check with the following query before executing the Update Query.

    Select * from Tbl_User_Reg where UserRegId='10'


  • #766857

    First of all check whether the table has required data.
    after it passes check the required condition is met. i.,e

    select * from Tbl_User_Reg where UserRegId='10';

    is the possible scenarios that get 0 rows effected


Sign In to post your comments