rajendra gupta
- Jul 9
- 2 min
Fundamental SQL: SQL Query examples for CREATE DATABASE
CREATE DATABASE: CREATE DATABASE is a fundamental SQL command that you need to know in order to work with databases.
41 views0 comments
rajendra gupta
- Jul 5
- 2 min
Learn about Case Statement in SQL Server
Case statements are used to provide instructions to be executed based on conditions. Case statements can be used in SELECT, INSERT, UPDATE,
16 views0 comments
rajendra gupta
- Jul 5
- 1 min
Convert Unix Timestamp in SQL Server (T-SQL)
Want to know how to convert a Unix timestamp to a SQL Server timestamp or vice-a-versa? This article shows you how to do it using T-SQL. Rea
70 views0 comments
rajendra gupta
- Mar 29
- 2 min
Learn SQL NOT IN Operator
The 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
56 views0 comments
rajendra gupta
- Mar 28
- 2 min
Difference between SQL COUNT(*), COUNT(1), COUNT(column_name) In SQL SERVER
What is the difference between COUNT(*), COUNT(1), and COUNT(column_name) in SQL Server? Read all about it here.
422 views0 comments
rajendra gupta
- Feb 27
- 1 min
An Overview of the SQL CHARINDEX function
The SQL CHARINDEX function is used to find the position of a character or substring within a string.
36 views0 comments
rajendra gupta
- Jan 19
- 1 min
T-SQL Query to find SQL database age and number of tables in SQL Server
SQL Server - The following T-SQL statement helps find the SQL Database age based on the created date and number of tables.
33 views0 comments
rajendra gupta
- Jan 18
- 2 min
The SQL NULLIF function
NULLIF is a SQL function that is used to compare two columns. Use NULLIF to compare two columns and return NULL if they are equal to each ot
18 views0 comments
rajendra gupta
- Jan 13
- 1 min
T-SQL query to check SQL Server min server memory(MB) and max server memory(MB)
T-SQL query to check SQL Server min server memory(MB) and max server memory(MB)
75 views0 comments
rajendra gupta
- Jan 11
- 1 min
Enclose a list of values into single quotes from CSV for T-SQL query for SQL Server database
Enclose a list of values into single quotes from CSV for T-SQL query for SQL Server database
5 views0 comments
rajendra gupta
- Jan 7
- 1 min
What is SET NOEXEC ON in the T-SQL statement?
Do you want to compile the query without executing it? If yes, you can use SET NOEXEC ON at the beginning of the T-SQL statement.
26 views0 comments
rajendra gupta
- Jan 7
- 1 min
SQL Server Management Studio Query Commands completed successfully without any Results
I recently came across a strange issue where the query does not return any row in SQL Server Management Studio. How do we solve this issue?
21 views0 comments
rajendra gupta
- Jan 5
- 1 min
T-SQL statement to Enable and Disable XP_CMDSHELL using SP_CONFIGURE in SQL Server
This article outlines the steps to Enable and Disable XP_CMDSHELL using the SP_CONFIGURE system stored procedure.
25 views0 comments
rajendra gupta
- Jan 5
- 1 min
T-SQL Script to generate Six Digit One Time Password (OTP)
This blog will give a T-SQL script o create and use Six Digit One Time Password using the SQL Server RAND function
25 views0 comments
rajendra gupta
- Dec 17, 2021
- 1 min
Approx_Count_Distinct in SQL Server 2019 and Azure SQL Database
Approx_Count_Distinct in SQL Server 2019 and Azure SQL Database
12 views0 comments
rajendra gupta
- Dec 13, 2021
- 2 min
SQL Server table Columns with NULL and NOT NULL values
This SQL article explains the SQL Server column property that has NULL or NOT NULL keywords specified in the CREATE OR ALTER table...
107 views0 comments
rajendra gupta
- Dec 10, 2021
- 1 min
Get a list of supported Time Zones in SQL Server and Azure SQL Database
Do you want to find out supported time zones in SQL Server and Azure SQL Database? If yes, get the query in this article. The...
4 views0 comments
rajendra gupta
- Dec 10, 2021
- 1 min
When my SQL Server database was restored ?
When my SQL Server database was restored ?
17 views0 comments