ROW_NUMBER SQL Server

When SQL query has been run a query for create some output then sql server track number row on per partition returned. Which you can show using row number on the basis of following example

Syntax:

SELECT ROW_NUMBER() OVER (Order by Column_name) AS RowNumber,Col1,Col2,…

FROM dbo.newadmission

Cyclic Redundancy check

CRC (Cyclic Redundancy check)

CRC is error detecting technique which is used to detect an error occurred during transmission. CRC technique used in networking, cd, dvd and many other types of memory devices. CHKDSK check disk error using CRC algorithms to find any error. 

A pattern of 0s and 1s can be represented as a polynomial with coefficient of 0 and 1. The power of each term shows the value of the bit. 

Algorithm

• Take Bit stream for transfer. 
• Divide your bit stream with a divisor which used both sender and receiver. Divisor may have any bit stream 0 or 1 but used the same for both end. 
• Divisor can also be represent using polynomial series as following rule.
  
  

Single Row Access MVC Razor

This post target when there is a need to get only single row and display them on a cshtml view.

@model Britanic_MIS.Models.CustomerModel

Generate HTML control using Razor

MVC Razor is a powerful technique to generate HTML controls. So I have created this post to demonstrate you to how can you generate simple HTML controls using razor code.

Textbox

Razor        

@Html.TextBox("Test",null, new { placeholder=@Model.FullName, @class = "form-control",@onclick="test()" })

Generated Code