What is cursor in SQL Server with example.

26 April 2017 Sudhanshu Ranjan 222

A cursor is a set of rows together with a pointer that identifies a current row.

More..

Get manager name in employee table mostly asked in interview question

05 October 2016 Sudhanshu Ranjan 407

Mostly this question asked by interviewer to find the manager name of employee in employee table.

More..

NULLIF Function in SQL Server with example

05 October 2016 Sudhanshu Ranjan 548

Most of the Interviewer ask this question. What is NULLIF Function? The NULLIF function compares expression1 and expression2. If expression1 and expression2 are equal, the NULLIF function returns NULL. Otherwise, it returns the first expression which is expression1.

More..

Code first approach with CRUD operation in MVC Application

01 August 2016 Sudhanshu Ranjan 991

In last article I have shown "datepicker textbox in mvc 4 using JQuery", "Bind dropdown in MVC using jquery with C#". Now today I am going to show how to work with code first approach using Entity Framework and how to perform CRUD operation in MVC application. In code first approach we transform our coded classes into a database design.

More..

Bind dropdown in MVC using jquery with C#

24 July 2016 Sudhanshu Ranjan 1.52k

In today article, I am going to explain how to bind the multiple dropdown (Like: Country, State, City) in MVC using JQuery, ajax, C#. It is very common in your development life and you will get these types situation to bind dropdown which depends on others dropped down. You can understand that you have to populate data like Country, State and City on webpage.

More..

How to delete the duplicate record from table in sql server

08 July 2016 Sudhanshu Ranjan 807

This is common query asked in most of the interviews.

More..

Display data which has two or more than two times in table in sql server.

08 July 2016 Sudhanshu Ranjan 708

This is most popular query which is asked by interviewers.

More..

What is the difference between UNION and UNION ALL?

20 May 2016 Sudhanshu Ranjan 654

UNION and UNION ALL both are merged the data of two different tables in single table. UNION display only the unique data in both table whereas UNION ALL display duplicate data also. Column name should be match on both table...More

More..

Microsft online test question for Dotnet -1

16 May 2016 Sudhanshu Ranjan 720

Microsft online test question for 2016 test.

More..

About Dotnet Cube

It's my blog - Dotnet Cube, where you will learn and get solutions about programming, web designing and development. I started this website to share my knowledge and experience which might help someone.

You can get more details about me and my blog at About Us page.

Subscribe Newsletter

Subscribe to our monthly newsletter to get the latest industry news, Media Group updates and our current specials.

Follow On Us...

Home | About | Advertise | Copyrights | Privacy | Contact | Admin

Copyrights © 2015-2017 dotnetcube.com. All rights reserved