Search This Blog

Type Declaration Instruction This instruction is used to declare the type of variables being used in the program. Any variable used in the program must be declared before using it in any statement. The type declaration statement is written at the beginning of main( ) function. Ex.: int bas ; float rs, grosssal ; char name, code ; There are several subtle variations of the type declaration instruction. These are discussed below: While declaring the type of variable we can also initialize it as shown below. int i = 10, j = 25 ; float a = 1.5, b = 1.99 + 2.4 * 1.44 ; The order in which we define the variables is sometimes important sometimes not. For example, int i = 10, j = 25 ; is same as int j = 25, j = 10 ; However, float a = 1.5, b = a + 3.1 ; is alright, but float b = a + 3.1, a = 1.5 ; is not. This is because here we are trying to use a even before defining it. The following statements would work int a, b, c, d ; a = b = ...

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

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.

C# Fundamental: Data Types and Variable

Data Types In C#, data types are used to store values in the memory. When data type is declared, it allocates a block of memory to hold the value. All the data types are directly or indirectly derived from the System.object class. Before moving, we need to understand the variables. Variables A variable is used to store the value (data). It is an address given to a memory location. Example: Take an example of a bag here bag is a variable we can put books into a bag and we can take them out again but we can put books according to bag size, a bigger bag can hold more books. Similarly, we can store and retrieve data from a variable. Here bag is the variable name the size of bag is the data type, an int can hold 32 bit value and long can hold 64 bit value. Different data types have different sizes we use them according to our requirement for example if we want to store only two values true or false we...