先在 Hostgator Back-end 中, Create 一個 email account在 DNS 上做好 Domain Mapping, 確定該 email 可以被存取到.在 ASP.net 的 Page 使用下列 CodeMailMessage oMail = new System.Net.Mail.MailMessage();// mailid: should include domain, ex, info@abc.barksoftware.com smtp.Credentials = new System.Net.NetworkCredential(mailid, mailpw); |
SELECT
t.NAME AS TableName,
p.rows AS RowCounts,
SUM(a.total_pages) * 8 AS TotalSpaceKB,
SUM(a.used_pages) * 8 AS UsedSpaceKB,
(SUM(a.total_pages) - SUM(a.used_pages)) * 8 AS UnusedSpaceKB
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 t.is_ms_shipped = 0
AND i.OBJECT_ID > 255
GROUP BY
t.Name, p.Rows
ORDER BY
t.Name| CREATE FUNCTION [dbo].[similar_text] ( @first NVARCHAR(100), @second NVARCHAR(100), @percent BIT = 1 ) RETURNS DECIMAL(10,3) AS BEGIN DECLARE @ret DECIMAL(10,3); DECLARE @s1 NVARCHAR(100); DECLARE @s2 NVARCHAR(100); DECLARE @pos1 INT; DECLARE @pos2 INT; DECLARE @max INT; DECLARE @fl1 INT; DECLARE @fl2 INT; DECLARE @p INT; DECLARE @q INT; DECLARE @l INT; DECLARE @sum INT; SET @s1 = ISNULL(@first,''); SET @s2 = ISNULL(@second,''); IF (@s1='') OR (@s2='') BEGIN SET @ret = 0.00; END ELSE BEGIN SET @pos1 = 1; SET @pos2 = 1; SET @max = 1; SET @fl1 = len(@s1); SET @fl2 = len(@s2); SET @p = 1; WHILE (@p<=@fl1) BEGIN SET @q = 1; WHILE (@q<=@fl2) BEGIN SET @l = 1; WHILE (@p+@l<=@fl1) AND (@q+@l<=@fl2) AND (SUBSTRING( @s1,@p+@l,1)=SUBSTRING( @s2,@q+@l,1)) BEGIN IF (@l>=@max) BEGIN SET @max = @l; SET @pos1 = @p; SET @pos2 = @q; END; SET @l = @l+1; END; SET @q = @q+1; END; SET @p = @p+1; END; SET @sum = @max; IF (@sum>1) BEGIN IF (@pos1>=1) AND (@pos2>=1) BEGIN SET @sum = @sum + dbo.similar_text(SUBSTRING(@s1,1,@pos2),SUBSTRING(@s2,1,@pos2),0); END; IF (@pos1+@max<=@fl1) AND (@pos2+@max<=@fl2) BEGIN SET @sum = @sum + dbo.similar_text(SUBSTRING(@s1,@pos1+@max,@fl1-@pos1-@max),SUBSTRING(@s2,@pos2+@max,@fl2-@pos2-@max),0); END; END; IF (@percent=0) SET @ret = @sum; ELSE SET @ret = (@sum * 200.00) / (@fl1 + @fl2); END; RETURN @ret; END GO |
using System;
using System.Net;
public class IPNetworking
{
public static string GetIP4Address()
{
string IP4Address = String.Empty;
foreach (IPAddress IPA in Dns.GetHostAddresses(HttpContext.Current.Request.UserHostAddress))
{
if (IPA.AddressFamily.ToString() == "InterNetwork")
{
IP4Address = IPA.ToString();
break;
}
}
if (IP4Address != String.Empty)
{
return IP4Address;
}
foreach (IPAddress IPA in Dns.GetHostAddresses(Dns.GetHostName()))
{
if (IPA.AddressFamily.ToString() == "InterNetwork")
{
IP4Address = IPA.ToString();
break;
}
}
return IP4Address;
}
}