SQL Server Basics Concepts includes SQL Database Creation, Tables, SQL DML , and DDL Commands, Joins, Key Constraints, Functions and so on..
SQL (Structured Query Language) is a programming language, It is used for managing and manipulating relational databases using various command such as DDL (Data Definition… Read More »SQL DDL, DML, DCL and TCL commands
The SQL NOT EXISTS Operator is used to check the existence of any record in a subquery. The NOT EXISTS operator returns true if the… Read More »SQL NOT EXISTS
Date data type allows you to store the date data in the database. It takes 3 bytes to store a date value. SYNTAX date The… Read More »SQL Server Date
SQL NULLIF expression compares two expression and returns a null value if the two specified expressions are equal, else it returns the first expression. NULLIF … Read More »SQL NULLIF
The IS NOT NULL is used in SQL to find a non-NULL value. It returns TRUE if a non-NULL value is found, otherwise it returns… Read More »SQL IS NOT NULL
SQL Server update statement is used used to modify an existing records in a table, you can also update records in table based on some… Read More »How to Update from Select Statement in SQL
SQL RAND function is a mathematical function which returns a pseudo-random float value from 0 through 1, exclusive or a random value within any range.… Read More »SQL Random Number
SQL delete statement is used to delete records from table based on specific conditions which are specified in where clause. Delete statement can also be… Read More »SQL Delete TOP
Sometimes you need to format a date in specific format such as format a date time string YYYY-MM-DD hh:mm:ss. mmm to date MM:DD:YY. SQL Server… Read More »Date and Time Conversions in SQL Server
SQL SELECT TOP statement is used to retrieve records from tables and limit the number of rows or percentage of rows returned based on a… Read More »SQL SELECT TOP
Table Value Constructor (TVC) allows to group multiple rows of data in a single DML statement. It can be used as a part of either… Read More »Table Value Constructor
SQL QUOTENAME function is a string function which returns a Unicode string with the delimiters added to make the input string a valid SQL Server… Read More »SQL QUOTENAME Function
A correlated subquery is a subquery that uses the values of the outer query and it is evaluated for each row processed by the outer… Read More »SQL Correlated Subquery
SQL OVER clause allows the use of aggregation without using a group by clause. OVER clause aggregate rows across groups of another field using the… Read More »SQL Over Clause
The SQL ROUND function is a SQL Mathematical Function which is used to round a number to a specified length or precision. It returns a… Read More »SQL ROUND Function
SQL NOT NULL Constraint is used to prevent inserting NULL values into the specified column. When value for any specific column is not provided while… Read More »SQL NOT NULL Constraint
SQL Between Operator is a logical operator that selects the records whose values are in between the given values. SYNTAX SELECT * FROM table_name WHERE … Read More »SQL Between Operator
The SQL PARSE function is a SQL Conversions Function that is used to convert the string data to the requested data type and returns the… Read More »SQL PARSE Function
A Subquery is a query within another query. The outer query is called as main query and inner query is called as subquery. A subquery (inner… Read More »SQL Subquery
The SQL EXISTS Operator is used to check the existence of any record in a subquery. The EXISTS operator returns true if the subquery returns… Read More »SQL EXISTS Operator