Results for "MSSQL"
6 / 11 posts
Filter by Category
Comparison of WHERE Clause Operators in MSSQL vs PostgreSQL
...ators in the WHERE clause are used in Microsoft SQL Server (MSSQL) vs PostgreSQL : Operator Purpose Used in MSSQL Used in Po…
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 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 …
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, o...
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…
SQL Server Database Shrink Maintenance
Database shrink ka matlab hai database file (ya log file) ke size ko chhota karna by removing unused space . Matlab, agar tumhare DB me data delete ho gaya h...