SQL NOT EXISTS
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
362 total views
SQL Server Basics Concepts includes SQL Database Creation, Tables, SQL DML , and DDL Commands, Joins, Key Constraints, Functions and so on..
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
362 total views
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
1,391 total views
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
1,416 total views, 2 views today
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
1,161 total views
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
3,708 total views
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
7,985 total views, 1 views today
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
4,314 total views, 3 views today
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
4,098 total views, 3 views today
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
2,069 total views, 1 views today
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
1,966 total views
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
2,485 total views
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
2,704 total views
SQL OVER clause allows the use of aggregation without using a group by clause. OVER caluse aggregate rows across groups of another field using the… Read More »SQL Over Clause
5,070 total views, 3 views today
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
1,310 total views, 1 views today
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
2,321 total views
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
1,309 total views, 1 views today
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
2,652 total views
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
2,446 total views
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
1,526 total views, 3 views today
Detaching and attaching a SQL database, is helpful in case in case when you want to move to move a database to a different SQL Server instance. So Bascially, first we detach database from SQL Server and move those files to another SQL Server and then attach files.
2,446 total views, 2 views today