delete duplicate record in SQL server

create table empp(id int identity ,name varchar(30))

insert into empp values('bhanu')

select * from empp

-- for selecting duplicate record

select name ,count(*)  cnt from empp e group by e.name having count(*) >1

-- for selecting non-duplicate record

select name ,count(*)  cnt from empp e group by e.name having count(*) =1

• 
  

--with having

delete from empp  where id  in (select max(id) from empp  group by name having count(*)>1)

--without having

delete from empp  where id not in (select max(id) from empp  group by name)

DELETE FROM emp WHERE ID NOT IN (SELECT MIN(ID) FROM emp GROUP BY FName)

delete from tableName where UniqueColumn NOT IN (select MIN(UniqueColumn) from tableName GROUP BY DuplicateRecoedColumn/DeletedDuplicateColumn)

iis 7.5 handler "extensionlessurlhandler-integrated-4.0" has a bad module "managedpipelinehandler" in its module list

First Repair .NET Framework

and configure your iis using

http://www.sitefinity.com/documentation/documentationarticles/installation-and-administration-guide/install-sitefinity/configuring-the-iis-to-host-sitefinity-projects

Send model data from view to controller using ajax call

 $("#btnSubmit").click(function () {
            var tommy = {
                FromDate: $("#FromDate").val(),
                ToDate: $("#ToDate").val()
            };

            $.ajax({
                url: "@Url.Action("SearchVehicle", "Default")",
               type: "POST",
               contentType: "application/json",
               data: JSON.stringify({ vehicleSearchParameter: tommy }),
               success: function (response) {
                   response ? alert("It worked!") : alert("It didn't work.");
               }
           });
        })

vehicleSearchParameter is a class  file model
tommy  is javascript object

public ActionResult SearchVehicle(VehicleSearchParameter vehicleSearchParameter, string Command)
        {
}

Binding Dropdown using EF in MVC

Model Code:

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.Mvc;

namespace RAVDEVMVC.Models
{
    public class Vehicles
    {
        public  SelectList VehicleList { get; set; }
    }
}

Controller Code:
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.Mvc;
using RAVDEVMVC.Models;

namespace RAVDEVMVC.Controllers
{
    public class HomeController : Controller
    {
     
        public ActionResult Index()
        {
            RAVEntities RE = new RAVEntities();
            IList<vehicle> objVehicleList = (from data in RE.vehicles
                                             select data).ToList();
            vehicle objvehicle = new vehicle();
            objvehicle.Vehicle1 = "Select";
            objVehicleList.Insert(0, objvehicle);
            SelectList objmodeldata = new SelectList(objVehicleList,"","Vehicle1",0);

            Vehicles objVehicleModel = new Vehicles();
            objVehicleModel.VehicleList = objmodeldata;
            return View(objVehicleModel);
        }
    }
}

View Code

@model RAVDEVMVC.Models.Vehicles

@Html.DropDownList("ddlVehicle",Model.VehicleList)

         

Autocomplete TextBox in MVC

RAVEntities  is a Entity Model

Controller Code:
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.Mvc;
using AutoComplete.Models;

namespace AutoComplete.Controllers
{
    public class AutoCompleteController : Controller
    {
        //
        // GET: /AutoComplete/

        public ActionResult Index()
        {
            return View();
        }

        public JsonResult getData(string term) {
            var result = new List<KeyValuePair<string, string>>();
            RAVEntities re=new RAVEntities();
            IList<vehicle> objVehicleList= (from data in re.vehicles
                               select data).ToList();
            foreach (var item in objVehicleList)
            {
                result.Add(new KeyValuePair<string, string>(item.Vehicle1, item.Vehicle1.ToString()));
            }
            var result3 = result.Where(s => s.Value.ToLower().Contains(term.ToLower())).Select(w => w).ToList();
            return this.Json(result3, JsonRequestBehavior.AllowGet);
        }

    }
}

View Code

@{

    ViewBag.Title = "Index";

    Layout = null;

}

@Styles.Render("~/Content/themes/base/css")

@Scripts.Render("~/bundles/jquery")

@Scripts.Render("~/bundles/jqueryui")

<script type="text/javascript">

    $(document).ready(function () {

        $("#Country").autocomplete({

            source: function (request, response) {

                $.ajax({

                    url: "/AutoComplete/getData",

                    type: "POST",

                    dataType: "json",

                    data: { term: request.term },

                    success: function (data) {

                        response($.map(data, function (item) {

                            return { label: item.Key, value: item.Value };

                        }))

                    }

                })

            },

            messages: {

                noResults: "", results: ""

            }

        });

    })

</script>

@Html.TextBox("Country")

<input id="tags" type="text" />

procedure with in ,out ,in out parameter in pl/sql

create or replace procedure test211(idd   IN number,
                                    names varchar2,
                                    NAME2 OUT VARCHAR,
                                    X     IN NUMBER,
                                    Y     IN OUT NUMBER) is
begin
  insert into test21 values (idd, names);
  SELECT NAMES INTO NAME2 FROM TEST21 T WHERE T.IDD = IDD;
  IF X = 1 THEN
    Y := 1;
  ELSE
    Y := 2;
  END IF;
end;



DECLARE IDD NUMBER;
 NAMES VARCHAR2(55);
  NAME2 VARCHAR2(20);
   X NUMBER;
    Y NUMBER;
BEGIN
IDD := 81;
 NAMES := 'BHANU';
 X := 1;
  Y := 0;
   test211(IDD, NAMES, NAME2, X, Y);

END;

Order by and RowNUM in ORACLE

SELECT ROWNUM SLNO, QRY.* FROM (SELECT TRADE_PK,TRADE_ID, TRADE_NAME,SELFLAG
  FROM (SELECT DISTINCT TMT.TRADE_MST_PK TRADE_PK,
                        TMT.TRADE_CODE TRADE_ID,
                        TMT.TRADE_NAME TRADE_NAME,
                        '1' SELFLAG
          FROM TRADE_MST_TBL TMT
         WHERE TMT.TRADE_MST_PK IN (222, 226 , 227, 224, 225)
       
         UNION
         SELECT DISTINCT TMT.TRADE_MST_PK TRADE_PK,
                        TMT.TRADE_CODE TRADE_ID,
                        TMT.TRADE_NAME TRADE_NAME,
                        '' SELFLAG
          FROM TRADE_MST_TBL TMT
         WHERE TMT.TRADE_MST_PK NOT IN (222, 226 , 227, 224, 225))
         ORDER BY SELFLAG ASC)QRY