Tags » SQL Query

Difference Between Temporary Table and Table Variable

Both Temporary Tables (# Tables) and Table Variables ( @ Tables) in Sql Server provide a mechanism for Temporary holding/storage of the result-set for further processing. 572 more words

SQL QUERY

How Can i Use Pivot In sql Server with Example

CREATE TABLE #BookSales
(BookType VARCHAR(20), SalesYear INT, BookSales MONEY);
GO

INSERT INTO #BookSales VALUES(‘Fiction’, 2014, 11201);
INSERT INTO #BookSales VALUES(‘Fiction’, 2014, 12939);
INSERT INTO #BookSales VALUES(‘Fiction’, 2013, 10436); 40 more words

SQL QUERY

Write a c program to find largest among three numbers using binary minus operator

#include<stdio.h>

int main(){

int a,b,c;

printf(“\nEnter 3 numbers: “);

scanf(“%d %d %d”,&a,&b,&c);

if(a-b>0 && a-c>0)

printf(“\nGreatest is a :%d”,a);

else

if(b-c>0) 14 more words

SQL QUERY

Write a c program to subtract two numbers without using subtraction operator

Write a c program or code to subtract two numbers without using subtraction operator

#include<stdio.h>

int main(){

int a,b;

int sum;

printf(“Enter any two integers: “); 30 more words

SQL QUERY

Write a c program to add two numbers without using addition operator

Add two numbers in c without using operator

How to add two numbers without using the plus operator in c

#include<stdio.h>

int main(){

int a,b; 64 more words

SQL QUERY

FIND POWER OF A NUMBER USING C PROGRAM

How to calculate power of a number in c

How to write power in c

#include<stdio.h>

int main(){

int pow,num,i=1;

long int sum=1;

printf(“\nEnter a number: “); 32 more words

SQL QUERY

Reverse any number using c program

Code 1:

  1. Write a c program to reverse a given number
  2. C program to find reverse of a number
  3. C program to reverse the digits of a number…
  4. 281 more words
SQL QUERY