Results for "MSSQL"
5 / 184 posts
What difference between between MySQL and MSSQL
Feature MySQL MSSQL Ownership Oracle Corporation Microsoft Licensing Open-source (GPL) and commercial versions Commercial with free Express Edition Operati…
Understanding Stored Procedures in MSSQL
What is a Stored Procedure? A stored procedure is a group of SQL statements that are compiled and saved in the database. Instead of writing the same SQL qu…
The ALTER TABLE statement in Microsoft SQL Server (MSSQL) and PostgreSQL
The ALTER TABLE statement in Microsoft SQL Server (MSSQL) and PostgreSQL is used to modify the structure of an existing table. It allows you to: Add, drop,…
Comparison of WHERE Clause Operators in MSSQL vs PostgreSQL
Here's a comparison of how operators in the WHERE clause are used in Microsoft SQL Server (MSSQL) vs PostgreSQL : Operator Purpose Used in MSSQL Used in Po…
Understanding Data Types and Variables in MSSQL vs PostgreSQL
📊 Data Types Comparison Table 🚩 Category 🟦 MSSQL 🟨 PostgreSQL Integer Types INT , BIGINT , SMALLINT INTEGER , BIGINT , SMALLINT , SERIAL Decimal Types …