Dynamic Memory allocation C language

Memory is storage unit which every program need for their operation. When you run your program then a request is made to OS for memory allocation. There are two types of memory allocations are used in programming.

• Static
• Dynamic

Static memory allocation is fix allocation.  It cannot be change during run time. Static memory allocation is better option in case when we know exactly how much amount of memory need. For example holding roll number marks of student etc.

IDENT_CURRENT SQL Server

IDENT_CURRENT return last inserted identity field value from any session any scope table.

One most interesting things which surprise me while I had used this first time. Which is follows

You can get SQL server generated identity value which inserting row, means it is not necessary that identity value only can get after save a row. Not at all!

You can use this feature while creating some userid and roll number type field in many applications.

i.e: 10000001,2000829 etc.

CREATE TABLE dbo.stu( 

   ID INT IDENTITY NOT NULL PRIMARY KEY,  

   Roll varchar(20),

   Name VARCHAR(40) NOT NULL 

   City VARCHAR(40) NOT

Nested Loop

When a loop resides inside of other loop .Nested loops are useful while if there is a need of looping for each count of other turn of a loop.

Temporary Table in SQL Server store procedure

declare @mytbl as table

(

     id bigint,

     name varchar(30),

     mobileno varchar(30),