Case in SQL

-

CASE ebv.db_no WHEN 22978 THEN 'WECS 9500' WHEN 23218 THEN 'WECS 9500' WHEN 23219 THEN 'WECS 9500' ELSE 'WECS 9520' 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

Entity Framework VS ADO.NET

-
Image
Entity Framework Entity framework  is ORM Model, which used LINQ to access database, and code is autogenerated. It enables developers to work with data using objects of domain specific classes without focusing on the underlying database tables and columns where this data is stored. Entity Framework  as it translates LINQ queries to SQL first then process the query. First time  EF  loads metadata into memory, that takes a time. It builds in-memory representation of model from edmx file, or from source code if you are using code first. EF  is built at the top of  ADO . NET , so it cannot be  faster . But it makes development much  faster Entity Framework  is an open-source ORM  framework  for . NET applications supported by Microsoft. It use LINQ which is simpler, tidier, and higher-level e.g using (var context = new CompanyContext())  {  var emp = context.Employee;  }    ADO.NET ADO . NET is  made of...
Read more

☀️ New AI Perfects Heliostat Aiming to Boost Solar Tower Power

-
Image
 In a breakthrough that could reshape solar energy, researchers at Spain's Plataforma Solar de Almería (PSA) have developed an AI-powered system that significantly improves how solar mirrors (heliostats) aim at tower receivers. The AI uses reinforcement learning to adjust each mirror’s angle in real time, based on sunlight, cloud cover, temperature, and time of day — all without human intervention. 🧠 Why This Is a Big Deal Traditional heliostat setups rely on fixed aiming points. PSA’s new AI system: Learns from experience using a method called Soft Actor-Critic (SAC) Adjusts mirror positions dynamically for maximum energy efficiency Reduces mechanical wear and tear by minimizing unnecessary movements 🧪 Testing & Results Researchers ran simulations using 114 heliostats at PSA. In three rounds of experiments, the AI strategy: Increased power absorption during midday Extended operation hours in the morning and evening Improved energy output by up to 8.7% a...
Read more