Notes - programming:sql http://www.de12werken.nl/ 2026-04-05T13:11:01+00:00 Notes http://www.de12werken.nl/ http://www.de12werken.nl/lib/exe/fetch.php?media=wiki:dokuwiki.svg text/html 2026-01-27T09:00:35+00:00 Anonymous (anonymous@undisclosed.example.com) mssql http://www.de12werken.nl/doku.php?id=programming:sql:mssql&rev=1769504435&do=diff Programming - SQL - Microsoft SQL Code Snippets Get the size of all tables in a database DECLARE @TableName VARCHAR(100) --For storing values in the cursor --Cursor to get the name of all user tables from the sysobjects listing DECLARE tableCursor CURSOR FOR select [name] from dbo.sysobjects where OBJECTPROPERTY(id, N'IsUserTable') = 1 FOR READ ONLY --A procedure level temp table to store the results CREATE TABLE #TempTable ( tableName varchar(100), numberofRows varchar(100),…