Results for "SCOPE_IDENTITY"

2 / 2 posts

Search: SCOPE_IDENTITY
SQLPythonPySparkMachine learningPower BIData WorldNumPyADF
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

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
  • Machine learning
  • Power BI
  • Data World

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.