SQL Server Get Previous and Next Row Values from Sequence

Introduction:

Here I will explain how to get previous and next row values from sequence in sql server or find next and previous records from table in sql server or access previous and next row values from in sql server. To get next and previous records from table data in sql server we need to write query to get max and min value from table data based on value in sql server.

Description:

In previous articles I explained sql server get before and after character example, sql server keyboard shortcut keys, sql server order by with union example, SQL Server single procedure to insert update delete, SQL Server take database backup, Primary key constraint in sql server, foreign key constraint in sql server and many articles relating to SQL server. Now I will explain how to get previous and next record value from table data in sql server.

Fix for Windows 10 Blurry Font (Text) Problem

Introduction: 

Here I will explain how to fix blurry font problem in windows 10 or icon font problem in windows 10 or blurry font fix in windows 10 or fix for blurred text problem in windows 10. To fix blurry font problem in windows 10 we need to change cleartype options.

Description:
  
In previous articles I explained excel find and highlight duplicate columns, keyboard keyboard shortcut key codes, compare two columns values and show duplicate values in excel, create desktop shortcut key to lock computer, configure dns server in windows 7. Now I will explain how to fix blurry font problem in windows 10 by changing cleartype options.

SQL Server 2014 Keyboard Shortcut Keys in Management Studio

Introduction:

Here I will explain keyboard shortcuts for sql server management studio 2014 or shortcut keys for sql server management studio 2014 or keyboard shortcuts to open new query window, show / hide result pane, toggle between tabs, execute selected query, etc. in sql server management studio.

Description:

In previous articles I explained sql server order by with union query, sql server show exact match values top then partial match values, sql server convert string to proper case, sql server charindex function example, restore database in sql server from .bak / .mdf file, foreign key constraint in sql server, cursor example in sql server and many articles relating to SQL server. Now I will explain sql server management studio keyboard shortcut keys to open query window, execute queries, etc.

JavaScript Convert Phone Number Format Example in jQuery

Introduction: 

Here I will explain how to use JavaScript to format phone number with example or convert phone number to international format (USA) in JavaScript / jQuery convert number to phone number format with example or JavaScript phone number validation example. By loop through number we can convert number to phone number format.

Description:
  
In previous articles I explained jQuery disable f12 or console window in browser example, jQuery difference between == and === with example, jQuery show loading image on button click with example, jQuery get radio button selected value by name, jQuery validate radiobuttonlist with example and many articles relating to css, AngularJS, jQuery, JavaScript and asp.net. Now I will explain how to convert number to phone number format in JavaScript with example.

SQL Server Order By in Union with Example

Introduction:

Here I will explain how to use order by in union query in sql server with example or order by clause with union operator in sql server with example or use union operator with order by in sql server or how to combine and use order by and union in sql server with example. To use Order By property with union we need to create sub query for union query statements in sql server.

Description:

In previous articles I explained sql server show exact match values top then partial match values, sql server difference between @@identity, scope_identity and ident_current, joins in sql server with examples, difference between len and datalength functions in sql server, sql server charindex function example, sql server difference between dml, ddl, dcl, tcl, SQL Server restore database from .bak / .mdf file and many articles relating to SQL server. Now I will explain how to use order by clause in union query in sql server with example.

Asp.Net MVC Create Roles, Assign Roles to Users in Membership Provider

Introduction: 

Here we will learn how to create roles and assign roles to users using membership in asp.net mvc with example or assigning roles to users in asp.net mvc membership provider with example. Generally membership provider will provide default functionality to create roles and assign roles to users using membership database in asp.net mvc applications. In case if we want to use our own custom database for membership provider then we can use it in asp.net mvc based on our requirements.

Description:
  
In previous articles I explained use hidden fields in asp.net mvc with html helpers, asp.net mvc custom route constraints with example, view models in asp.net mvc with example, query string parameters in asp.net mvc, exception handling in asp.net mvc with example, areas in asp.net mvc with example, Global action filters in asp.net mvc with example and many articles relating to asp.net mvc, asp.net, c#,vb.net. Now I will explain how to create roles and assign roles to users using membership provider in asp.net mvc with example.

Asp.Net MVC Create User using Membership Provider with Example

Introduction: 

Here we will learn how to create users using membership in asp.net mvc with example or use membership in asp.net mvc with example or how to use createuser method in asp.net mvc membership provider to create new user with example. Generally membership provider will provide default functionality to create users using membership database in asp.net mvc applications and we can use custom database for membership provider in asp.net mvc based on our requirements.

Description:
  
In previous articles I explained query string parameters in asp.net mvc, exception handling in asp.net mvc with example, areas in asp.net mvc with example, Global action filters in asp.net mvc with example, asp.net mvc controller scaffolding templates with example, action filters in asp.net mvc with example, insert data into database using asp.net mvc web api with example, create master page with layouts in asp.net mvc razor view and many articles relating to asp.net mvc, asp.net, c#,vb.net. Now I will explain how to create users using membership provider in asp.net mvc with example.

jQuery Disable F12 Key, Console Log in Browser in JavaScript Example

Introduction:

By clicking F12 in the browser we can open the Console log and development tool of a web site running in the browser. As a developer while you are developing its OK for you, but when others are trying to see your application code and do some operations definitely we don't want to disclose this. So what is the solution? we can easily prevent this using some simple JavaScript  and jQuery scripts. Let’s see how.

Description:

To stop this we can do two things. One, while users are opening the console log he or she will be prompted with some message or user will not be accessing the F12 key with mouse right click options. We will discuss both the ways one by one.

Asp.Net Membership Provider Tutorial (Create Users, Roles, Assign Roles) Examples

Introduction: 

Here we will learn asp.net membership provider tutorial with topics like creating users, roles, assign roles to users, edit / update / delete user details, recover user password using password recovery / change user password using changepassword control, etc.. using asp.net membership provider with examples using c#, vb.net.

Description:
  
In previous articles I explained get users ip address in asp.net, jquery auto complete textbox from database in asp.net, create / read / get cookies in asp.net, generate one time password (otp) in asp.net with example, jQuery Gridview Crud Operations in asp.net, show multiple markers in google map from database in asp.net and many articles relating to asp.net, c#,vb.net and jQuery. Now I will explain complete asp.net membership provider tutorial with examples in c#, vb.net.

Get Users IP Address in Asp.Net using C#, VB.NET with Example

Introduction: 

Here we will learn how to get users / client IP address in asp.net using c# and vb.net with example or retrieving user's IP address in asp.net using c# and vb.net or how to get IP address of visitors machine in asp.net using c# and vb.net with example.

Description:
  
In previous articles I explained JavaScript Get User IP Address, City, Latitude, Longitude, how to find client machine IP using jquery in asp.net, show users current location in google map using latitude and longitude in asp.net, show google map with latitude & longitude in asp.net and many articles relating to asp.net, c#, vb.net jQuery. Now I will explain how to get users ip address or client IP address of machine in asp.net using c# and vb.net.