Tag: SQL

• Use stored procedure in c# project to solve special problem

  there are two Scenes in my projects (1) C# project, we use entityframwork to do mssql database operation.however, I would like to get a value caculated with parameters in the tables cross 3 databases.of course ,we do not want to change any database structure,however, there is one database connected to entityframework. now we can use…

  Guanghu Yang

  May 29, 2022

  .Net, C#, SQL

  C#, SQL, Stored procedure, transaction

• use Over Clause to delete duplicate records in SQL

  I have to delete some duplicate game data with different primary key. In other words，My application insert same game data many times in one table due to some software bug. Now my purpose is to delete these duplicate game data but keep only one record for each same game data. My table GameSale is defined…

  Guanghu Yang

  May 1, 2022

  SQL

  Select-Over, SQL, window function