begin transaction | rollback transaction | how to retrieve deleted data | sql server 2008

how to rollback deleted query in sql server . how to retrieve deleted | updated data in sql server by using rollback and begin transaction . sometimes we think if i will delete that particular row then where it will effect. specially when you are working on live project then it will...

top query in sql server | select top 1*

How to use and write top query in sql server | My sql | Oracle top query will be same in every database but  thing is that to know about table name and field of particular table. select * from stud  1 dev 2 deva 4 deva 5 deva 6 deva 8 "dsouza" 8 "d-souza" Now I want to select...

Even | Odd number | 1 to 10 ..n | vb.net source code

Even number is a number which is divisible by 2 . Odd number is number which is not divisible by 2. lets take examples. 4 /2=2. when we divide number 4 to number 2 it will not gives remainder so four is Even number . second examples is 5 divided by 2 i.e 5/2 remeainde will be 1.so 5 is...

Swap values of two variables using call by value | output | comments

How to write program to swap two numbers using call by value in c . source code to swap two number . void swap(int a,int b) { int temp; temp=a; a=b; b=temp; printf("\nValues of a and b within the function: %d %d",a,b); } int main() { int a,b; //Accept value of a & b printf("\nEnter...

sscanf() function | c program | string

This function is same as scanf() function but it reads from string rather than standard input. /*Program to illustrate the use of sscanf() function*/ Include header file int main() { //declare two strings char s1[20]="1234"; char s2[20]="345.67"; //declare int and float variables int n; float...

sprintf() function | c program | source code

c program sprintf() function use in program with source code. This function is same as printf() function but it sends the formatted output to a string instead of screen. So we can convert a variable data type into string using sprintf() function. /*Program to illustrate the use of sprintf()...

how to swap two values in c program | call by reference in c code

swap values of two variables using call by reference comments How to write C Program to swap values of two variables using call by reference include header files //function to swap values void swap(int *a,int *b) { int temp; temp=*a; *a=*b; *b=temp; printf("\nValues of a and b within the...

How to write C Program to calculate L.C.M and G.C.D of two numbers using function

Program source code .first of all create two function first function gcd to find out gcd() and next lcm(). we need to pass two parameter  in given function . void gcd(int,int); // created function for gcd void lcm(int,int); // created function for lcm int main() { int a,b; printf("Enter...

Void Pointer example in c language

 How to use of void pointer in c language include header files main() { int a=10,*j; void *k; j=k=&a; j++; k++; printf("\n %u %u ",j,k); } Explanation: Void pointers are generic pointers and they can be used only when the type is not known and as an intermediate address storage...

array in c program | Array example with Explanation

Array in cprogramming /*Array in c program with code*/ include header file main() { char s[ ]="man"; int i; for(i=0;s[ i ];i++) printf("\n%c%c%c%c",s[ i ],*(s+i),*(i+s),i[s]); } Explanation: As we know array name is the base address for that array. Here s is the base address and i is...

c program const use with source code

/* Use of const with output */ this program shows how to change constant integer value by increment it. include header files void main() { int const * p=5; printf("%d",++(*p)); } Explanation: p is a pointer to a "constant integer".  But we tried to change the value of the...

Token pasting operator in c language with program source code.

/* use of token pasting operator with Output */ //Token pasting operator is used to concatenate two tokens into a single token. with program source code. #define PASTE(a,b) a##b #define MARKS(sub) marks_##sub int main() { int k1=15,k2=60; int marks_os= 95; int marks_ds=99; //converting...

Nesting of macros | check alphabet using ISALPHA | Program code

Nesting of macros in c language with output. How to write code for nesting of macros in c language. By using if and else condition we can check whether entered value is alphabet or not. simply by using ISALPHA Keyword. ISALPHA will check about the alphabet or not.  include...

perfect number in vb.net from 1 to n | source code

Number which is sum of its factors  like factor of 6 is 1*2*3. so 1+2+3=6 sum of factors is =number itself hence 6 is perfect number .after that 28 is perfect number. perfect number from 1 to 1000 is 6, 28, 496 Public Sub perfect()         Dim takeval...