Posts

Showing posts from February, 2024

Open Street Map Sample For HTML and JS

-
 <html xmlns="http://www.w3.org/1999/xhtml"> <head runat="server">     <title>POCRA MAP</title>      <link rel="stylesheet" href="https://unpkg.com/leaflet@1.9.4/dist/leaflet.css"      integrity="sha256-p4NxAoJBhIIN+hmNHrzRCf9tD/miZyoHS5obTRR9BMY="      crossorigin=""/>      <!-- Make sure you put this AFTER Leaflet's CSS -->  <script src="https://unpkg.com/leaflet@1.9.4/dist/leaflet.js"      integrity="sha256-20nQCchB9co0qIjJZRGuk2/Z9VM+kNiyxNV1lvTlZBo="      crossorigin=""></script>     <style>         #map { height:100vh; }     </style> </head> <body>     <form id="form1" runat="server">                  <span>Map Location</span>         <div>       ...
Post a Comment
Read more

Download HTML Page / Div to Pdf or Image Using JQUERY / JS / CANVAS JS

-
 <html> <head> <title>Test Download</title> <style> .down-pdf{ display:inline-block;     color:#444;     border:1px solid #CCC;     background:#DDD;     box-shadow: 0 0 5px -1px rgba(0,0,0,0.2);     cursor:pointer;     vertical-align:middle;     max-width: 100px;     padding: 5px;     text-align: center; } </style> </head> <div class="down-pdf printpdf" style="font-weight: normal; padding: 0px;">                                                         Download PDF                                                     </div> <div id="pageWrapperProcess"> <b>संकष्टी च...
Post a Comment
Read more

GET LIST OF TABLES WITH ROWS COUNT in SQL SERVER

-
 SELECT o.NAME,   i.rowcnt  FROM sysindexes AS i   INNER JOIN sysobjects AS o ON i.id = o.id  WHERE i.indid < 2  AND OBJECTPROPERTY(o.id, 'IsMSShipped') = 0 ORDER BY i.rowcnt desc
Post a Comment
Read more

Get List of Table Valued Function in SQL SERVER Using Query

-
 select o.name, p.*, t.name as type_name from sys.parameters p join sys.types t on t.user_type_id = p.system_type_id join sys.objects o on o.object_id = p.object_id where o.[type] in ('IF', 'TF') -- IF is inline, TF is multi-statement
Post a Comment
Read more

Get All Table Status with Data Available Summary in SQL SERVER

-
 SELECT      t.name AS TableName,     s.name AS SchemaName,     p.rows,     SUM(a.total_pages) * 8 AS TotalSpaceKB,      CAST(ROUND(((SUM(a.total_pages) * 8) / 1024.00), 2) AS NUMERIC(36, 2)) AS TotalSpaceMB,     SUM(a.used_pages) * 8 AS UsedSpaceKB,      CAST(ROUND(((SUM(a.used_pages) * 8) / 1024.00), 2) AS NUMERIC(36, 2)) AS UsedSpaceMB,      (SUM(a.total_pages) - SUM(a.used_pages)) * 8 AS UnusedSpaceKB,     CAST(ROUND(((SUM(a.total_pages) - SUM(a.used_pages)) * 8) / 1024.00, 2) AS NUMERIC(36, 2)) AS UnusedSpaceMB 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 LEFT OUTER JOIN      sy...
Post a Comment
Read more