To get a rough view of how many rows, total, used and unused space each table has, in a sql server database you can run the following query: USE {Database_Name};…
t-sql
2 Articles
2
DECLARE @DesiredLength AS INT = 10; SELECT Lower(substring(replace(newID(), ‘-‘, ”), cast(RAND() * (31 – @DesiredLength) AS INT), @DesiredLength)) AS RandomString;
Page 1 of 1