Query to Update Multiple Rows | Updating Multiple Rows using Join

-

Update AdminMaster

set Username=b.Username,

Password=b.Password

from AdminMaster as a

join @TempAdmin b on a.id=b.id



//@TempAdmin is Temporary table that we can pass on stored procedure

Comments

Post a Comment

Popular posts from this blog

Uploading Image to Sql Server Image Datatype in asp.net using fileupload Control

-
Uploading Image to Sql Server Image Datatype in asp.net using fileupload Control  Byte[] imgbyte = null;  if (FileUpload1.HasFile)             {                 string fileName = Path.GetFileName(FileUpload1.PostedFile.FileName);                 FileUpload1.PostedFile.SaveAs(Server.MapPath("~/UserPhoto/") + DateTime.Now.ToString("_MMddyyyy_HHmmss") + fileName);                 photo = "UserPhoto/" + DateTime.Now.ToString("_MMddyyyy_HHmmss") + fileName;                 string fpathPhoto = Server.MapPath(photo);                 FileInfo fInfo = new FileInfo(fpathPhoto);                 long numBytes = fInfo.Length;                 //Open FileStream to read...
Read more

📉 Study: African Women Face Higher Risk of Job Loss to AI in Outsourcing Sector

-
 A recent report reveals that women in Africa’s outsourcing industry are at greater risk than men of losing their jobs to automation and AI by 2030 . The findings were shared at the first-ever Global AI Summit for Africa , held in Kigali, Rwanda, where over 1,000 policymakers, business leaders, and experts gathered to discuss the continent’s digital future. The report, created by Caribou Digital and Genesis Analytics in collaboration with the Mastercard Foundation , highlights a key concern: 🔹 Tasks performed by women are 10% more likely to be automated compared to those performed by men. If not addressed, this could worsen gender inequality in the tech-driven workplace of the future. 📌 Call for Upskilling & Innovation The report urges African workers to enhance their digital and technical skills to adapt to the evolving job market and move into more resilient, higher-value roles. Speaking at the summit, Rwandan President Paul Kagame emphasized the need for: ...
Read more

🎨 Is There a Future for Graphic Designers in the AI Era?

-
Image
  Yes — but the role is evolving fast. 🧠 1. AI is a Tool, Not a Threat AI tools like DALL·E, Midjourney, Adobe Firefly , and Canva’s Magic Design can generate images in seconds. But they don’t replace your creative thinking , storytelling, or brand intuition. Instead, they help you: Generate concept art or moodboards quickly Experiment with styles and layouts Speed up tedious design iterations Expand your visual vocabulary Think of AI as your creative assistant , not your competition. ✨ 2. Your Creative Direction Is Irreplaceable AI can generate content, but it can’t: Understand a brand’s emotion, tone, or identity Create a cohesive visual campaign across platforms Make nuanced aesthetic choices based on human psychology Capture cultural sensitivity or humor That’s where human designers shine — you tell stories , set the mood , and connect with emotion . 🖌 3. New Design Roles Are Emerging As AI becomes a standard tool, new career paths ...
Read more