Functions

Create table if not exists SQL Server

by
Create table if not exists SQL Server

SQL Server does not directly approach the “CREATE TABLE IF NOT EXISTS” syntax like MySQL. Recently, I was required to check if one of the tables in the SQL server database exists. If it doesn’t, I must create a new table with the same name. After analysis, I have identified 4 best approaches to achieve … Read more

How To Check SQL Server Version

by
how to check sql server version

For one of the requirements, my client asked me, “What is the SQL server version you are using?” Let me tell you there are four simple approaches to checking this. Approach-1: Using SQL Server Management Studio Object Explorer 1. Open your SQL Server Management Studio and login using the required credentials. 2. You will find … Read more