Below Script gives you three important details related to date using datepart() function. Current Week of the Year Start of
Continue readingC program to enter integer elements and sort them in ascending order
#include <stdio.h> int main() { int arr[5],j,k,s=0; printf(“\n Enter five Elements :”); for(j=0;j<5;j++) { scanf(“%d”,&arr[j]); s=s+arr[j]; } printf(“Sorted elements are:\n”);
Continue readingSQL Server Services
Services used for better control on SQL Server. One program may have multiple services Entire SQL Server run using these
Continue readingWrite C Program to Find the First and Second Largest Two Numbers in a given Array
#include <stdio.h> #define MAX 5 int main() { int arr[MAX], i, larg1, larg2, temp; printf(“Enter %d the numbers \n”, MAX);
Continue readingWrite C program to insert an element at a specified position in a given array
#include <stdio.h> int main() { int arr[15]={0},i,n,pos,num; printf(“\n how many elements you want to enter:”); scanf(“%d”,&n); printf(“\n Enter the elements
Continue readingDifference Between Union and Union All in SQL Server
union:- union command remove the duplicates and selects only distinct values by default UNION command must have the same number
Continue readingACID properties in SQL (Atomicity, Consistency, Isolation, Durability)
ACID(Atomicity, Consistency, Isolation, Durability) Property is the most important part of the database. ACID stands for Atomicity, Consistency, Isolation and
Continue readingC program for binary search
#include <stdio.h> int main() { int c, low, up, mid, num, search, array[100]; printf(“how many number do want to enter\n”);
Continue readingWrite a Program to convert a decimal number to Binary, octal and hexadecimal number
#include <stdio.h> void main() { int dnum, choice; printf (“Enter a decimal number “) ; scanf(“%d”,&dnum) ; printf (“1.Binary\n 2.
Continue readingIdentify the culprit who dropped or altered tables,procedures or databases in SQL Server
We can be find out who made DDL Changes in SQL Server database through the sys.traces dynamic management view .
Continue reading