rajendra guptaMar 29, 20222 minLearn SQL NOT IN OperatorThe SQL NOT IN operator is used to find entries in a table that are not in a list of values. Learn how to use this SQL operator
rajendra guptaMar 28, 20222 minDifference between SQL COUNT(*), COUNT(1), COUNT(column_name) In SQL SERVERWhat is the difference between COUNT(*), COUNT(1), and COUNT(column_name) in SQL Server? Read all about it here.
rajendra guptaFeb 27, 20221 minAn Overview of the SQL CHARINDEX function The SQL CHARINDEX function is used to find the position of a character or substring within a string.
rajendra guptaJan 19, 20221 minT-SQL Query to find SQL database age and number of tables in SQL ServerSQL Server - The following T-SQL statement helps find the SQL Database age based on the created date and number of tables.