Get the class properties in the list

In this article you will learn, how you can access your class properties value in a list and perform whatever operation you want with the properties value. below is my Class named Employee. this class contains four properties.     public class Employee     {         public string FirstName { get; set; }         public string LastName { get; set; }  ...

Continue Reading →

STUFF() - SQL Server

Description: STUFF function is used to append number of characters from one string and replace them with another string. So, you can say this function insert string into another string, it removes all the specified length of string and insert other string value on that place. Syntax STUFF(string, start, length, add_string)  Example: 1- SELECT STUFF('dotnetguru.in',12,2, 'com') as [stuff...

Continue Reading →

Basics of SQL Commands

SQL commands are a set of instructions that are used to interact with the database like Sql Server, MySql, Oracle etc. SQL commands are responsible to create and to do all the manipulation on the database. These are also responsible to give/take out access rights on a particular database Sql Commands Category We have different sql commands for different-different purpose. We can grouped Sql...

Continue Reading →

Comma separated value parameter in SQL IN clauses

How to use comma separated values parameter in SQL IN Clause in SQL Queries- The SQL IN clause is very useful, since it allows you to specify exactly which values you want to return. For this tip,  let's assume we have a database with this table: CREATE TABLE [dbo].[Employee]( [ID] [int] NOT NULL, [Name] [varchar](50) NULL, CONSTRAINT [PK_Employee] PRIMARY KEY And the Data is: ID...

Continue Reading →