Tuesday, 16 January 2018

Array Average using function

Write a function which accepts an array of size n containing integer values and returns the average of all values. Call the function from main program.

Solution : 

/*==============================
     Girfa Student Help
     Program : Array Average using function
     More Program :http://girfahelp.blogspot.in/p/function-programming.html
================================*/
#include<stdio.h>
#include<conio.h>
#define MAX 5
int avg(int*);

Sunday, 14 January 2018

Array multiply using function

Q :  Write a function which receives two integer arrays and creates a third array by multiplying  corresponding elements (elements with same index) and returns it to main program.


Solution : 

/*==============================
     Girfa Student Help
     Program : Multiply two array using function
     More Program :http://girfahelp.blogspot.in/p/function-programming.html
================================*/
#include<stdio.h>
#include<conio.h>
#define MAX 5
void mul(int *,int *,int *);
void print(int *);
void main()
{

     int ar1[MAX],ar2[MAX],ar3[MAX],i;
     clrscr();
     printf("\nInput f

Palindrome number

 Q : Write a program which asks for a integer from the user. It reverses the integer and prints “same” if after reversal the number is same as old number otherwise it prints “not same”.

Solution : 

/*==============================
     Girfa Student Help
     Program : Reverse a number
     More Program :http://girfahelp.blogspot.in/p/loop-c-language.html
================================*/
#include<stdio.h>
#include<conio.h>
void main()
{

     int n,m,r=0;
     clrscr();
     printf("Enter number>> ");
     scanf("%d",&n);
     m=n;
     while(n>0)

Saturday, 13 January 2018

Table as parameter SQL Server

Table as parameter SQL Server

SQL Server provides a special parameter named table parameter. Using table parameter user can pass entire table as other parameter pass to store procedure. Table parameter is better alternate of temporary table. It reduces unnecessary work and time. Which need to pass more than one row to database for save.

Table Structure


Field Name
Data Type
Roll
Int
Name
Varchar(30)
City
Varchar(40)

Store Procedure

Table Type


CREATE TYPE dbo.myDataType AS TABLE  
( roll int, 
  name varchar(30),
  city varchar(30)
 );