Results for "Identity"
3 / 184 posts
Store Error Logs In SQL
Create Table for Error log: CREATE TABLE [dbo].[ErrorLog]( [ErrorLogID] [int] IDENTITY(1,1) NOT NULL, [ErrorTime] [datetime] …
azure mysql programming
Mar 19, 2026 2 min read
Database trigger to audit (Transaction logs) all of the DDL changes made to the Database
Create table DatabaseLog: CREATE TABLE [dbo].[DatabaseLog]( [DatabaseLogID] [int] IDENTITY(1,1) NOT NULL, [PostTime] [datetim…
azure database oracle
Mar 19, 2026 2 min read
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 …
Data Types Identity RETURNING id
Mar 19, 2026 2 min read