T-SQL script to get list of tables which dont have clustered index August 12, 2013 SELECT name AS Table_Name_WithoutClusteredIndex FROM SYS.TABLES WHERE OBJECTPROPERTY(OBJECT_ID,‘TableHasClustIndex’) = 0 ORDER BY NAME GO
SQL Server – How Primary Key Ensures Unique Records in Database In relational databases like SQL Server, MySQL, PostgreSQL, or Oracle, data integrity is crucial. One of the key constraints that…
Does Primary Key Allow NULL in SQL Server? Let’s Test It A Primary Key doesn’t allow NULL values because it must uniquely identify each row in the table. If NULLs were…
SSIS – Data Flow Diagram for consuming Web API using OAuth In Microsoft technology platform, we can use SSIS package to consume the Web API. We need to use the script…