The WHERE clause is used to filter records by conditionally. The WHERE clause is used to select only those records that fulfill a specifi...
Latest Posts
SQL SELECT DISTINCT Command
The SELECT DISTINCT Command is used to return only different and unique values. In a table and column may contain many duplicate values a...
SQL SELECT Commands
The SELECT command is used to select data from a database and table. MS-SQL SELECT Syntax: SELECT column_1_name,column_2_name,..... ...
MS-SQL Date Functions
The following lists the most important date functions in MS-SQL Server: GETDATE() DATEPART() DATEADD() DATEDIFF() CONV...
ALTER TABLE
The ALTER TABLE statement is used to add, delete, or modify columns in an existing table. To change the data type of a multiple column in...
AUTO INCREMENT or IDENTITY
The primary key field to be created automatically every time a new record is inserted. CREATE TABLE CANDIDATE ( CandidateId int ID...
SQL Constraints(DEFAULT)
The DEFAULT Constraints is used to add a default value in a table columns. The default value will be added to all new records, if no othe...
Subscribe to:
Posts
(
Atom
)
