A detailed introduction to " C# Fundamental "

Introduction



 Data types are the building block of any programming language. These are like the grammar of any language.

 I have explained in detail the data types, memory allocation on stack and heap, variables, naming conventions.

 Topics covered are as follows:
  • Data types
  • Variables
  • Naming convention
  • Value type/reference type
  • Stack/heap memory


Note:-- All examples are created by using VS 2015 enterprise edition.

 Related Topics:

Popular posts from this blog

Set a value when the column is null

Set a value when the column is null In sql server 2008 there are two functions to replace  NULL  values with another values 1. ISNULL  function required two parameters: the value to check and the replacement for null values ISNULL(value,replacement) 2.COALESCE  function works a bit different  COALESCE  will take any number of parameters and return the first non-NULL value , I prefer COALESCE over ISNULL 'cause meets ANSI standarts, while ISNULL does not. COALESCE(value1,value1,value3, valueN,replacement) Solution 1: SELECT Name , DOB , ( CASE WHEN Address1 IS NULL THEN 'NA' ELSE Address1 END ) AS Address1 , ( CASE WHEN Address2 IS NULL THEN 'NA' ELSE Address2 END ) AS Address2 , ... FROM Users Solution 2: Use  isnull : SELECT Name , DOB , isnull ( Address1 , 'NA' ) as [ Address1 ], isnull ( Address2 , 'NA' ) as [ Address2 ], isnull ( City , 'NA' ) as...
Read more

SQL Basic- SQL Commands(DDL,DML,DCL)

Image
SQL commands based on their nature: These commands can be classified into groups based on their nature: DDL Commands (Data Definition Language) CREATE Creates a new table or other object in database. ALTER Modifies an existing database object. DROP Deletes an entire table or other object in the database. DML Commands (Data Manipulation Language) SELECT Retrieves records from one or more tables. INSERT Insert a record into the table. UPDATE Modifies records. DELETE Deletes records. DCL Commands (Data Control Language) GRANT         Gives a privilege to user. REVOKE           Takes back privileges granted from user.
Read more

SQL BASIC - SQL DELETE Command

Image
SQL DELETE  This statement is used to delete records in a table. SQL UPDATE Statement  The SQL update statement is used to delete row in a table. Syntax: [ To update the existing record into the table, we are using SQL UPDATE command as follows: ] DELETE FROM table_name WHERE  column_name=value; Note: WHERE clause: In SQL DELETE Statement,  WHERE clause specifies which record should be deleted. If you don't use WHERE clause,then SQL DELETE condition delete all records. Data Is Deleted Only in Specified Columns: The following statement will delete existing record as per the specifies condition in WHERE Clause. Below is existing   "Student"  table: Example 1: [we delete existing student " Anuj " from "Student" table.] The following statement are used as to delete a existing "Anuj's " record from the " Student " table : DELETE F...
Read more