Untitled

[lalit24rocks]

Using MERGE in SQL Server to Insert, Update and Delete in Single Statement http://www.webcodeexpert.com/2017/07/using-merge-in-sql-server-to-insert.html

[lalit24rocks]

Difference between IEnumerable and IQueryable in C# with example. http://www.webcodeexpert.com/2017/05/difference-between-ienumerable-and.html

In this article I am going to explain what is the difference between IEnumerable and IQueryable Or we can say we will discuss IEnumerable vs IQueryable.

[lalit24rocks]

Most Important SQL Server Interview Questions and Answers. http://www.webcodeexpert.com/2017/05/most-important-sql-server-interview.html

In this article i am going to explain frequently asked top most important sql server interview questions and answers. This will help fresher/starting level candidates to improve their sql and clear interview. It will also help intermediate level candidates to brush up their sql skills.

[lalit24rocks]

Difference Between Abstract class and Interface in C# http://www.webcodeexpert.com/2017/04/abstract-classes-vs-interfaces.html In this article I am going to explain the difference between Abstract class and Interface in C# with suitable examples.

[lalit24rocks]

What is Abstract Class in C#. When, where and why to use it. http://www.webcodeexpert.com/2017/04/what-is-abstract-class-in-c-when-where.html

Abstract Class and Interface is one of the most frequently asked interview question. In this tutorial, I will explain about Abstract class in C#

[lalit24rocks]

What is Interface in C# and Where to use it. http://www.webcodeexpert.com/2017/04/what-is-interface-in-c-and-where-to-use.html

In this article we will discuss about interface in C# i.e. What is interface, when, where and why to use an interface. It is one of the mostly asked interview question.

[lalit24rocks]

SQL SERVER: Convert Table Data to XML Format using FOR XML PATH() http://www.webcodeexpert.com/2017/04/sql-server-convert-table-data-to-xml.html In this article I am going to explain how to convert sql table data to different xml format using FOR XML PATH().  

[lalit24rocks]

SQL SERVER: How to Replace XML Node's Attribute Value in XML Column of Table http://www.webcodeexpert.com/2017/02/sql-server-how-to-replace-xml-nodes.html In this article i am going to explain how to update the value of XML node's attribute in XML data type column in all or specific row of sql server table.

[lalit24rocks]

SQL SERVER: Searching XML Node's Attribute Value Exists or Not in XML Datatype Column of Table http://www.webcodeexpert.com/2017/01/sql-server-searching-xml-nodes.html In this article i am going to explain how to find all or specific records in sql table where the xml node's attribute value matches with the variable value that we pass.

[lalit24rocks]

ASP.NET MVC: TempData vs Session and When to use what? http://www.webcodeexpert.com/2017/01/aspnet-mvc-tempdata-vs-session-and-when.html

In this article you will learn the following:

1) What is the Difference and Similarity between TempData and Session? 2) When to use TempData and Session?

[lalit24rocks]

ASP.NET MVC: TempData Keep vs Peek Methods http://www.webcodeexpert.com/2017/01/aspnet-mvc-tempdata-keep-vs-peek-methods.html

In this article you will learn the following:

1) What is TempData? 2) How it is used to persist data for next request? 3) Use of Keep and Peek methods to persist data. 4) Similarities and differences between Keep and Peek methods.

[lalit24rocks]

ASP.NET MVC: Using Keep and Peek with TempData to Persist data http://www.webcodeexpert.com/2017/01/use-of-keep-and-peek-with-tempdata-in.html

In this article you will learn the following

1) What is TempData and what is the use of TempData? 2) How to pass data from Controller to controller or action to action? 3) How to persist data in next request? 4) What is Keep() and Peek() methods and their use?

[lalit24rocks]

Sql Server: Using CASE Statement inside IN Clause (alternative) http://www.webcodeexpert.com/2017/01/sql-server-using-case-statement-inside.html

In this article I am going to share best alternative of using CASE statement inside IN operator in sql server with suitable examples.

[lalit24rocks]

Sql Server: Select or Read XML Column Data from table http://www.webcodeexpert.com/2017/01/sql-server-select-or-read-xml-column.html

In this article I am going to share how to parse and read data from XML data type column of sql server table.

[lalit24rocks]

Sql Server: Update multiple XML node values with new values in table http://www.webcodeexpert.com/2017/01/sql-server-update-multiple-xml-node.html

In this article I am going to share how to modify or we can say replace multiple XML node/ attribute values with new values in single or multiple update statement(s) based on condition in sql server table.

[lalit24rocks]

Sql Server: Update XML Node value with new value in table http://www.webcodeexpert.com/2017/01/sql-server-update-xml-node-value-with.html

In this article I am going to share how to modify or we can say replace XML node/ attribute value with new value in sql server table based on condition.

[lalit24rocks]

SQL SERVER: Parse XML and Get Data As Comma Separated String Format http://www.webcodeexpert.com/2016/12/sql-server-how-to-parse-xml-and-get.html

In this article I am going to explain how to get comma separated values from xml data in sql server using two suitable examples.