Delete with CTE

  1. With CTE as   
  2. (  
  3. Select Id,city,[state],row_number() over (partition by City,[state] order by City) as CityNumber from [CityMaster]  
  4. )  
  5. delete from CTE where CityNumber >1   

Comments

Post a Comment

Popular posts from this blog

Razor View Engine VS Web Form(ASPX) View Engine

Razor View Engine VS Web Form(ASPX) View Engine Razor View Engine Web Form View Engine Razor Engine is an advanced view engine  that was introduced with MVC3. This is not a new language but it is a new markup syntax. Web Form Engine is the default  view engine for the Asp.net  MVC that is included with Asp.net MVC from the beginning. The namespace for Razor Engine   is  System.Web.Razor . The namespace for Webform Engine is System.Web.Mvc.WebFormViewEngine . The file extensions used with Razor Engine are different from Web Form Engine. It has .cshtml (Razor with C#) or .vbhtml (Razor with VB) extension for views, partial views, editor templates and for  layout pages. The file extensions used with Web Form Engine are also like  Asp.net Web Forms. It has .aspx extension  for views, .ascx extension for partial views &  editor templates and .master extension for layout/master pages. Razor has new and advance ...
Read more

View vs Partial View MVC

The primary difference is that a Partial View is designed to be rendered within other full Views and as a result it will not contain all of the markup that a full View might ( since it is designed to work within other Views ). For example, a normal View might look like this and contain all of the elements present in a traditional HTML page :  <!DOCTYPE html> <html> <head> <meta charset = utf-8 /> <title> Example </title> </head> <body> <!-- Your Content Here --> </body> </html> where as a Partial View might only contain a small section that it needs to render and since it should be displayed within an existing View, it won't require the necessary tags like <head>, <html>, etc. because it is implied that these should already be present when a Partial View is rendered. An example partial View might look like this :  <div> <!-- Example --> <ul> ...
Read more

ASP.NET MVC VS WebForms

Difference between ASP.NET MVC and WebForms Asp.Net Web Forms Asp.Net MVC Asp.Net Web Form follow a traditional event-driven development model. Asp.Net MVC is a lightweight and follows MVC (Model, View, Controller) pattern based development, model. Asp.Net Web Form has  server controls. Asp.Net MVC has HTML helpers. Asp.Net Web Form supports  view state for state management at the client side. Asp.Net MVC does not support view state. Asp.Net Web Form has file-based URLs means file name exist in the URLs must have its physical existence. Asp.Net MVC has route-based URLs means URLs are divided into controllers and actions and moreover it is based on controller not on physical file. Asp.Net Web Form follows Web Forms Syntax Asp.Net MVC follow customizable syntax (Razor as default) In Asp.Net Web Form, Web Forms(ASPX)  i.e. views are tightly coupled  to Code behind(ASPX.CS) i.e. logic. In Asp.Net MVC, Views and logic are kept se...
Read more