Code Archives - Page 25 of 27

Truncate, Delete and Drop

Apr

16

2013

DELETE The DELETE command is used to remove rows from a table. A WHERE clause can be used to only remove some rows. If no WHERE condition is specified, all rows will be removed. After performing a DELETE operation you need to COMMIT or ROLLBACK the transaction to make the change permanent or to undo ...

Triggers and Indexes

Apr

16

2013

Triggers SQL Triggers are SQL Statements or a set SQL of statements which is stored to be activated or fired when an event associating with a database table , view or schema occurs. The event can be INSERT, UPDATE and DELETE. SQL Triggers provides an alternative way to check integrity and to run scheduled tasks. However, ...

Stored Procedures and Functions

Apr

16

2013

Difference between Stored Procedures and Functions Stored procedures are a set of actions already written and stored inside database for achieving a particular task. Functions are general databse objects which are used for general purpose programming. S.No. Stored Procedures Functions 1. Procedures may return none or more values Functions must always return one value either a ...

tan x Graph

Apr

16

2013

Description: This program creates a graph for tan x. Primary Inputs: —— Primary Output: tan x Graph Platform Used: Turbo C++ version 3.0, Borland International Inc. #include #include #include #include void main() { int gd=DETECT,gm; int x,y; initgraph(&gd,&gm,"c:\\tc\\bgi"); for(x=0;x

Sine Curve

Apr

16

2013

Description: This program creates a sine curve Primary Inputs: —– Primary Output: A sine curve for prespecifed parameters. Platform Used: Turbo C++ version 3.0, Borland International Inc. /*This program generates the sine curve for prespecified parameters. */ #include #include #include #include #include void main() { int gdriver=DETECT,gmode,i; float x=0; clrscr(); initgraph(&gdriver,&gmode,"c:\\tc\\bgi"); for(i=0;i

Rolling Circle

Apr

16

2013

Description: This program creates a graphic in which one circle (small) is rolling on the surface of other circle(large). Primary Inputs: —– Primary Output: small circle rolling on the circumference of large circle Platform Used: Turbo C++ version 3.0, Borland International Inc. #include #include #include #include #include #include #define ROUND(a) (int)(a+0.5) void main() { int i,ang; ...

Parabola

Apr

16

2013

Description: This program creates a graphic describing the path of parabola. Primary Inputs: (x,y) coordinates and value of a Primary Output: parabola Platform Used: Turbo C++ version 3.0, Borland International Inc. #include #include #include #include void main() { float x, y, a; int gdriver=DETECT; int gmode,i; initgraph(&gdriver, &gmode, "c:\\tc\\bgi"); printf("Enter the coordinates x and y:"); scanf("%f ...

Fan

Apr

16

2013

Description: This program creates a graphic for fan motion. Primary Inputs: —– Primary Output: fan in motion Platform Used: Turbo C++ version 3.0, Borland International Inc. #include #include #include #include #include void main() { int gdriver=DETECT; int gmode; float x,y,u,g,h,x1,y1,x2,y2,r,r1,x3,y3,x4,y4,x5,y5,x6,y6,x7,y7,x8,y8,x9,y9; initgraph(&gdriver, &gmode,"c:\\tc\\bgi"); x=getmaxx()/2; y=getmaxy()/2; r=20; r1=200; for(h=0;h

DDA Line

Apr

16

2013

Description: This program implements the DDA algorithm of line drawing. Primary Input: Two end point coordinates of the line. Primary Output: A line drawn according to the given end points. Platform Used: Turbo C++ version 3.0, Borland International Inc. /*This program generates a line according to DDA algorithm for given end points. */ #include #include #include #define ROUND(a) ...

Car

Apr

16

2013

Description: This program creates graphic for moving car. Primary Inputs: ——- Primary Output: moving car Platform Used: Turbo C++ version 3.0, Borland International Inc. #include #include #include #include void main() { int gdriver = DETECT; int gmode; int i; initgraph(&gdriver,&gmode,"c:\\tc\\bgi"); line(0,400,640,400); for(i=0;i