Showing posts with label StructuredQueryLanguage(SQL). Show all posts
Showing posts with label StructuredQueryLanguage(SQL). Show all posts

Wednesday, 19 June 2013

Declare Variable in SQL

VARIABLES :- Variables are particular amount of memory area that are used to store the data values required to get producing the desired output from the program or SQL query . But Before using or allowing these variable to hold the specified data values we must declare them . The Declaration Statement of variable also tells the type of data that the variable will hold.

Tuesday, 18 June 2013

Create Functions in SQL

Functions provide a good way to group some set of statements under a particular valid Function -Name that can used in various portions in Program . Functions allows us to use particular set of statements that will be used a number of times in different portions of program by single name. A particular set of statements used to perform specific function and

Monday, 17 June 2013

Friday, 14 June 2013

Joins in SQL

Joins in Structured Query Language (S Q L) are used to Store and Retrieve data from two or more Tables . Joins Store and Retrieve data On the basis of given Join Condition. The Given Join condition tells how and which data to retrieve / store in and from Database Tables.

Wednesday, 12 June 2013

datediff in sql

Structured Query Language Provides Several Functions to perform date and time related operations. These functions allow you to add dates , times. To Find difference between dates and time etc.

1. CurrentDate :- Current Date is used to display current date according to date set in computer system.

Monday, 10 June 2013

Friday, 7 June 2013

Thursday, 6 June 2013

Wednesday, 5 June 2013