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 Mathematica – How to get the Area & Circumference of a Circle This simple stored procedure calculates the area & circumference of a circle using radius—an ideal example for beginners. It’s designed…
How to enable xp_cmdshell in SQL Server Xp_cmdshell is an extended stored procedure that provides an environment analogous to a Windows command shell and passes in a…
How to Get All SQL Server Error Codes and Messages Using T-SQL When working with Microsoft SQL Server, understanding system errors is crucial for effective debugging and troubleshooting. SQL Server comes with…