Variable Declaration and If Condition in Sql Server Stored Procedure

-

Create Proc Usp_CheckStatus
@id int
As
Begin

Declare @status nvarchar(50)
Set @status=(select status from TblUsers where id=@id)

   If(@status='active')
   Begin

---Your Block of Code/query

  End

End

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