Variable to SQL Query

Sometimes there is a need to store a SQL query output to a variable in store procedure. This feature gives programming flexibility to apply more action while generating output.

For example, you can apply more group option in a simple way which was complicated in a single query or if you want to concatenate the output of some query etc.

USE [Girfa_Portal]

GO

SET ANSI_NULLS ON

Register Variable

Register Variable C Language

Register is a special type of storage medium for making variables in c language. When there is a need of access any variable very frequently like inside of loops. For increase of access time of a variable it can be take place direct on register. If a variable is on a register then its take less time compare to access a variable form memory because register is a part of CPU.

Multiple Condition with parameter in sql server

Multiple Condition with parameter in sql server

USE [Girfa_Portal]

GO

--=========== Condition with concatenate =========================

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

ALTER procedure [dbo].[Girfa]

(@arg varchar(500))

Auto variable

Auto variable "C" Language

Auto or local variable in c language is a type of variable which space allocate and deallocate space automatically and static in by nature. An auto variable is invisible from outside of a function or block. So an auto variable can be access within the block where it is defined. By default all variable in a block or function is auto by nature. Auto keyword is used to make auto variable which is optional.

Auto int a;

Or

Int a

#include<stdio.h>

void main()

{

     int a=10;