Results for "SCOPE_IDENTITY"

3 / 3 posts

Search: SCOPE_IDENTITY
SQLPythonPySparkData ScienceMisc.data visualizationPower BIData World
DATA
SQL

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
Match in tagsMatch in content
Mar 19, 2026 2 min read
DATA
SQL

SQL Server me Default Constraint Maintenance System (Auto Fix + Logging + Rollback)

Introduction Agar tum SQL Server me kaam karte ho, to tumne ye problem zarur dekhi hogi: Different tables me different default values Constraint naming rando...

SQL Server Default Constraints SQL Optimization
Match in contentMatch in code
Mar 26, 2026 12 min read
DATA
SQL

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...

Database shrink compress DB shrink
Match in contentMatch in code
Mar 25, 2026 16 min read

SQLDataDev footer

SQLDataDev

Practical SQL, Python, analytics, and data engineering tutorials for builders who learn by shipping.

Browse practical tutorials for SQL, Python, analytics, and data engineering with crawlable internal links that help readers discover related articles quickly.

Explore

  • SQL
  • Python
  • PySpark
  • Data Science
  • Misc.
  • data visualization

Categories

  • Data Science
  • Database maintenance

Tools

  • SQL Formatter
  • All Tools

Search & Indexing

  • Homepage
  • About
  • Main Sitemap
  • Post Archive
  • Contact Us
  • Robots Rules

Copyright 2026 SQLDataDev. Practical tutorials for data builders.

Everything's organized so you can discover exactly what you're looking for — browse by category, search the archive, or explore related posts.