only one clustered index per table where as you can have more than one non clustered index per table cluster
Continue readingC program to print Armstrong numbers from 1 to 1000
#include<stdio.h> #include<conio.h> int main() { int num, n, cube, d, sum; printf(“Armstrong numbers are : \n”); for (num = 100;
Continue readingProgram to Convert a binary number to a decimal number
#include<stdio.h> #include<conio.h> int main() { int n, nsave, rem, d, j = 1, decimal = 0; printf(“Enter the number in
Continue readingProgram In C to find out the factorial of any number
#include<stdio.h> #include<conio.h> int main() { int n, num; long fact = 1; printf(“Enter the number :”); scanf(“%d”, &n); num =
Continue readingProgram In C to print the sum of digits of any number
#include<stdio.h> #include<conio.h> int main() { int n, sum = 0, rem; printf(“Enter the number : “); scanf(“%d “, &n); while
Continue readingHow To Find and Remove Duplicate records in SQL ?
I have created a table and inserted some records in Table for understanding purposes. Creating New Table create table
Continue readingHow To Check Word or String is Palindrome or not ?
We can check given word is palindrome or not through below code:- #include<stdio.h> #include<string.h> main( ) { char str[10];
Continue readingFind The 2nd or 3rd Or Nth Highest Salary In SQL
I have created a table and inserted some records in Table for understanding purposes. — Creating New Table create table
Continue readingHow to Shrink TempDB Database Without Restart SQL Server Services?
Sometimes we try to Shrink TempDB but it don’t happen then We can Shrink TempDB Database without restart the SQL
Continue readingHow Can You find out Process ID for SQL Server Services?
After the execution of above script you will get information like service status, process Id, last startup time and service
Continue reading