Is it possible to update a table value with out using update
command?. if yes what is the reason, if no what is the
reason?.
- 1 Answers
- 2723 Views
- I also Faced
- E-Mail Answers
Answer Posted / bhawana
NO,it is impossible to update the table without using update
command,Because update command is used only for update the table
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
Please can the SQL code below be interpreted IF @xMatchCriteria='MATCH12' BEGIN IF EXISTS (Select * from #InsightData where (EmailAddress=@xDCPEmailAddress ) ) BEGIN SET @xTestMatchCriteria = @xMatchCriteria; SELECT @xCRMCustomerId=CustomerId, @xCRMDcpCustomerId=DcpCustomerId, @xCRMPortalCustomerID=PortalCustomerID,@xCRMDcpID=DcpID, @xCRMCardNumber=CardNumber, @xCRMEmailAddress=EmailAddress, @xCRMfirtLetterFirstName=firtLetterFirstName, @xCRMLastName=Surname,@xCRMAddressLine1=AddressLine1, @xCRMPostCode=PostCode FROM #InsightData where (EmailAddress=@xDCPEmailAddress ) END ELSE BEGIN SET @xTestMatchCriteria='No'+@xMatchCriteria; END END
How do I optimize a selected query in mysql?
Explain the difference between mysql and mysql interfaces in php?
Explain the difference between primary key and candidate key in mysql?
Do while loop in mysql procedure?
What are the different tables present in MySQL?
Write a query to select all teams that won either 1, 3, 5 or 7 games.
Is mariadb faster than mysql?
How to rename an existing column in a table?
What does mysqli stand for?
How do I delete a mysql user?
What is the use of mysqli_query?
How do I restore a mysql database?
Define REGEXP?
How to Change a users password from unix shell.
