tag:blogger.com,1999:blog-7767918376204344706.post2778188711936591289..comments2023-10-25T09:02:03.547-07:00Comments on Sukesh Marla: Sql Practice - 1Sukesh Marlahttp://www.blogger.com/profile/16619059549331221666noreply@blogger.comBlogger4125tag:blogger.com,1999:blog-7767918376204344706.post-73000181309144450632011-08-09T09:04:25.002-07:002011-08-09T09:04:25.002-07:00Excellent Sai..
second query given by u is awesome...Excellent Sai..<br />second query given by u is awesome one.<br />i.e,<br />update TableTest <br />set EmpName = CASE EmpName<br />WHEN 'A' THEN 'B'<br />WHEN 'B' THEN 'A'<br />ELSE EmpName<br />END<br /><br />Even your First query works,but performance wise thats poor.Sukesh Marlahttps://www.blogger.com/profile/16619059549331221666noreply@blogger.comtag:blogger.com,1999:blog-7767918376204344706.post-82267266660293289742011-08-09T06:53:42.674-07:002011-08-09T06:53:42.674-07:00UPDATE `employee` SET EMPLOYEENAME = (
CASE
WHEN
...UPDATE `employee` SET EMPLOYEENAME = (<br />CASE<br />WHEN<br /> EMPLOYEENAME = 'A' <br />THEN<br />'B' <br />WHEN<br /> EMPLOYEENAME = 'B'<br />THEN<br />'A'<br />ELSE <br />'C'<br />END<br />)Hitesh Kolihttps://www.blogger.com/profile/03260076320641046317noreply@blogger.comtag:blogger.com,1999:blog-7767918376204344706.post-56883057195626870822011-08-08T22:07:30.760-07:002011-08-08T22:07:30.760-07:00Declare @Emp Varchar(50)
update TableTest
set E...Declare @Emp Varchar(50)<br /><br />update TableTest <br />set EmpName = CASE EmpName<br /> WHEN 'A' THEN 'B'<br /> WHEN 'B' THEN 'A'<br /> ELSE EmpName<br /> END<br />***** second way ************Sai Sherlekarhttps://www.blogger.com/profile/06814179051261391347noreply@blogger.comtag:blogger.com,1999:blog-7767918376204344706.post-34722606637320771642011-08-08T21:55:30.419-07:002011-08-08T21:55:30.419-07:00update TableTest
set EmpName = 'AA'
wher...update TableTest <br />set EmpName = 'AA' <br />where EmpName = 'A'<br /><br />update TableTest <br />set EmpName = 'A' <br />where EmpName = 'B'<br /><br />update TableTest <br />set EmpName = 'B' <br />where EmpName = 'AA'<br /><br />**********very simple way************Sai Sherlekarhttps://www.blogger.com/profile/06814179051261391347noreply@blogger.com