Manish

Recent Blog Comments By Manish

• Using CASE Statements In A SQL UPDATE Query

  Posted on Oct 31, 2013 at 2:32 AM

  @sreekanth, Update YourTable SET age=(CASE WHEN CAST(age AS INT) < 18 THEN NULL ELSE age END), salary=(CASE WHEN CAST(salary AS numeric(18,2)) <> 1000.25 THEN 800.25 ELSE salary END) Thanks Manish... read more »

• Ask Ben: Javascript String Replace Method

  Posted on Apr 26, 2011 at 3:31 AM

  Hi Ben, I want to ask you that in java script variable have 32000(I read somewhere) char limit. Due to this limitation i am getting problem in my application i making the .net application in which i have used PageMethod and this pagemethod returning me the 82000 char long string but can anything it... read more »

• Using CASE Statements In A SQL UPDATE Query

  Posted on Jun 26, 2010 at 8:26 AM

  hi Pinal, I have already use like this but when i use END of case statment than it take the END for the BEGIN not for the case statment. but anyways maybe i have use some another line there. i will try to use this. please make comment on my this comment... read more »

• Using CASE Statements In A SQL UPDATE Query

  Posted on Jun 26, 2010 at 8:08 AM

  hello ben, i want to use the case statment in the Storeprocedure like this can u tell me it is a urgent example create proc Testing ( @jobnumber nvarchar (100), @flag int ) begin update tablename jobnumber=(case when @flag = 0 than @jobnumber ) end I have used like this but it showing syntex er... read more »