Wildcard Operator
Wildcard Operator/Like Operator: The like operator is used to compare a value to similar values using wildcard operators. It always use Like oper…
Showing posts with the label MCTS 70-433Show all
Operators (Transact-SQL)
Null Operator : It is a very special operator in Sql server.The NULL operator is used to compare a value with NULL value. Ex: Select * from empl…
Comparison Operators (Transact-SQL)
Where clause must have one condition statement in Select statement. To restrict depending upon condition min requirement is an operator. 1. Relat…
Where Clause
It is concept through which those many records are displayed where a condition is satisfied. It is also called Row restriction. The Where clause i…
Select Query
Select statement can perform two types of job 1. Selection 2. Projection --> It can be possible in two different manners i. Column wise…
Data Retrieval
The primary function of database is to store and provide to user request. In SSMS, The Select statement provides the data retrieval functionality. …
SSMS (SQL Server Management Studio) Database Connection
SQL Server Management Studio is the principal tool for administering the Database Engine and writing Transact-SQL code. Step - 1 Open your data…
Introduction of SQL Server
Data : It is raw fact through which an object can’t be identified. Ex – employee no. name, salary of an employee are individually known a…
Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry's.
