Category: SQL Server

27 Jun 2016 03:49

Joined:	13/03/2015
Level:	Silver
Points:	144

Points:	2

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

27 Jun 2016 04:22

Joined:	16/03/2011
Level:	Gold
Points:	528

Points:	2

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)

Regards,
Simiyon A

#766819

27 Jun 2016 04:24

Joined:	03/05/2013
Level:	Gold
Points:	15822

Points:	3

Hi,

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.

N@veen
Blog : http://naveens-dotnet.blogspot.in/

#766822

27 Jun 2016 05:02

Joined:	05/06/2009
Level:	Gold
Points:	10245

Points:	3

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

28 Jun 2016 00:15

Joined:	13/06/2007
Level:	Gold
Points:	21327

Points:	2

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

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

#766852

28 Jun 2016 04:23

Joined:	12/12/2013
Level:	Gold
Points:	529

Points:	3

Hi,
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'

Regards,
Karunanidhi.K

#766857

28 Jun 2016 09:38

Joined:	20/03/2013
Level:	Gold
Points:	4176

Points:	2

Sidiqi

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

SRI RAMA PHANI BHUSHAN KAMBHAMPATI

Solve the below query

About dotnetspider.com

Quick Links

General

Services