(229) 445-3421

What is while loop ? Loops are used in programming to repeat a specific block of code.There are 3 types of loop.for loopwhile loopdo while loop The syntax of for loop is: do { /Statements to be executed repeatedly } while( condition ); Notice that the conditional expression appears at the end of the loop,… 5203246082

WHILE LOOP

What is while loop ? Loops are used in programming to repeat a specific block of code.There are 3 types of loop.for loopwhile loopdo while loop The syntax of for loop is: while(condition) { /Statements to be executed repeatedly } A sequence of statements are executed until a specified condition is true. This sequence of… 7812937806

FOR LOOP

What is loop ? Loops are used in programming to repeat a specific block of code.There are 3 types of loop.for loopwhile loopdo while loop The syntax of for loop is: for (initialization; condition test; increment or decrement) { /Statements to be executed repeatedly } A sequence of statements are executed until a specified condition… 3032057514

IF ELSE STATEMENT

Decision Control statement In decision control statements (if-else and nested if), group of statements are executed when condition is true. If condition is false, then else part statements are executed.There are 3 types of decision making control statements in C language.if statements.if else statements.nested if statements. if syntax: if(expression) /if true { /execute your code… 8082202648

Variables

What is Variables ? Variables are memory locations(storage area) in C programming language. #include<stdio.h> #include<conio.h> void main() { int a,b,sum; /variable declaration a=20; /variable definition b=30; /variable definition sum=a+b; printf(“Sum is %d”,sum); /Sum is 50 getch(); } There are some rules on choosing variable names Variable name can consist of Capital letters A-Z, lowercase letters… Read More »

801-618-0369

What is keyword ? Keywords are predefined, reserved words used in programming that have a special meaning. Keywords are part of the syntax and they cannot be used as an identifier.For example: int money; Here, int is a keyword that indicates ‘money’ is a variable of type integer.other examples int, for, if, else, char, while, include… Read More »

Hello World

First Program “Hello, World!” is a simple program that displays “Hello, World!” on the screen. Since, it’s a very simple program, it is used to illustrate the basic syntax of any programming language. #include <stdio.h> int main() { printf(“Hello, World!\n”); return 0; } 1. #include #include is used to Inserts a particular header from another… Read More »

Overview

What is C ? C is a powerful general-purpose programming language. It is fast, portable and available in all platforms. Before getting started with C programming, lets get familiarized with the language first. History of C programming The origin of C is closely tied to the development of the Unix operating system, originally implemented in… (510) 333-2316

518-855-8807

SELECT TOP 5 query_stats.query_hash AS “Query Hash”, SUM(query_stats.total_worker_time) / SUM(query_stats.execution_count) AS “Avg CPU Time”, MIN(query_stats.statement_text) AS “Statement Text” FROM (SELECT QS.*, SUBSTRING(ST.text, (QS.statement_start_offset/2) + 1, ((CASE statement_end_offset WHEN -1 THEN DATALENGTH(ST.text) ELSE QS.statement_end_offset END – QS.statement_start_offset)/2) + 1) AS statement_text FROM sys.dm_exec_query_stats AS QS CROSS APPLY sys.dm_exec_sql_text(QS.sql_handle) as ST) as query_stats GROUP BY query_stats.query_hash;

586-533-2737

Store Procedure Syntax The general syntax is: CREATE PROCEDURE <owner>.<procedure name> <Param> <datatype> AS <Body> Example: CREATE PROCEDURE GetEmployee @login nvarchar(30)=null AS SELECT * from [Employee] It will return all the records from Employee table.