You have following table "TestUpdate".
Q 1.) What would be the output of following query?
Q 3.) What would be the output of following query?
Q 1.) What would be the output of following query?
UPDATE Testupdate
SET ID = ID + (SELECT MAX(ID) FROM Testupdate)
SELECT *
FROM Testupdate
Ans:
Q 2.) What would be the output of following query? based on blow table

UPDATE Testupdate SET ID = ID + (SELECT MAX(ID) FROM Testupdate)
GO 2
UPDATE Testupdate SET ID = ID + (SELECT MAX(ID) FROM Testupdate)
Q 3.) What would be the output of following query?
UPDATE Testupdate
SET ID = ID + MAX(ID)
Ans:
I really enjoyed while reading your article and it is good to know the latest updates. Do post more.
ReplyDeleteDevOps course in Chennai
Best DevOps Training in Chennai
AWS Training in Chennai
AWS Certification in Chennai
RPA Training in Chennai
Robotics Process Automation Training in Chennai
DevOps Training in Anna Nagar
DevOps Training in Chennai
Great collection and thanks for sharing this info with us. Waiting for more updates.
ReplyDeleteDevOps Training in Chennai
DevOps Certification in Chennai
AWS Training in Chennai
AWS course in Chennai
Cloud Computing Training in Chennai
Cloud Computing courses in Chennai
DevOps Training in Velachery
DevOps course in Chennai
Thanks for taking the time to discuss this, I feel happy about it and love to learn more on this topic.
ReplyDeleteui ux design course in Chennai
ux design course in chennai
ui ux course in chennai
Web Designing Course in chennai
web designing training in chennai
AngularJS Training in Chennai
ccna course in Chennai
ui ux design course in Velachery
ui ux design course in T Nagar
ui ux design course in OMR