How Toastr JS works !!! Very easy - Just follow these 3 steps #Alert #Notification

1 - Include JS CSS in your HTML Page 
CSS - https://cdnjs.cloudflare.com/ajax/libs/toastr.js/latest/css/toastr.css
JS -  https://cdnjs.cloudflare.com/ajax/libs/toastr.js/latest/js/toastr.min.js

2 - Master/Global/Container page add below code - Options of Toastr 
toastr.options = {
        "closeButton": true,
        "debug": false,
        "newestOnTop": false,
        "progressBar": false,
        "positionClass": "toast-bottom-full-width",
        "preventDuplicates": false,
        "onclick": null,
        "showDuration": "300",
        "preventDuplicates": true,
        "hideDuration": "1000",
        "timeOut": "0",
        "extendedTimeOut": "1000",
        "showEasing": "swing",
        "hideEasing": "linear",
        "showMethod": "fadeIn",
        "hideMethod": "fadeOut"
};

3 - Page level below command we can use depending on your message type
Info - toastr["info"]('msg');
Success - toastr["success"]('msg');
Error - toastr["error"]('msg');
toastr["warning"]('msg');

Get the Sql Database tables record count till date

SELECT T.name AS [Table Name],

I.rows AS [Record Count]

FROM sys.tables AS T

INNER JOIN sys.sysindexes AS I

ON T.object_id = I.id

AND I.indid < 2

ORDER BY I.rows DESC




SELECT

t.NAME AS TableName,

i.name as indexName,

p.[Rows],

sum(a.total_pages) as TotalPages,

sum(a.used_pages) as UsedPages,

sum(a.data_pages) as DataPages,

(sum(a.total_pages) * 8) / 1024 as TotalSpaceMB,

(sum(a.used_pages) * 8) / 1024 as UsedSpaceMB,

(sum(a.data_pages) * 8) / 1024 as DataSpaceMB

FROM

sys.tables t

INNER JOIN

sys.indexes i ON t.OBJECT_ID = i.object_id

INNER JOIN

sys.partitions p ON i.object_id = p.OBJECT_ID AND i.index_id = p.index_id

INNER JOIN

sys.allocation_units a ON p.partition_id = a.container_id

WHERE

t.NAME NOT LIKE 'dt%' AND

i.OBJECT_ID > 255 AND

i.index_id <= 1

GROUP BY

t.NAME, i.object_id, i.index_id, i.name, p.[Rows]

ORDER BY

p.[Rows] DESC

--object_name(i.object_id)

Loop through the SQL Table and add columns to it

create table #Temp

(
testID int

)
select object_id('tempdb..#Temp')

SELECT top 10 OBJECT_ID FROM tempdb.sys.columns WHERE object_id = object_id('#Temp')

select * from #Temp

declare @counter_val int = 0

WHILE ( SELECT COUNT(*) FROM tempdb.sys.columns WHERE object_id = object_id('tempdb..#Temp')) < 1000

BEGIN

set @counter_val = @counter_val + 1

DECLARE @SQL NVARCHAR(MAX)

declare @fieldname nvarchar(20)

SET @fieldname = 'niraj' + cast(@counter_val as nvarchar(10))

   

SET @SQL = 'ALTER TABLE #Temp

ADD [' + CAST(@fieldname AS VARCHAR(10)) + '] varchar(30)'

--PRINT @SQL

EXECUTE (@SQL)

END

　

　

drop table #Temp