CREATE FUNCTION [dbo].[GetCurrentIP] () RETURNS varchar(255) AS BEGIN DECLARE @IP_Address varchar(255); SELECT @IP_Address = client_net_address FROM sys.dm_exec_connections WHERE Session_id = @@SPID; Return @IP_Address; END
asp寫入,asp.net讀取 [asp寫入] response.Cookies("CookieName")= "ASPValue" [asp.net讀取] Dim cookieFromAsp As HttpCookie=Request.Cookies.Get("CookieName") Dim v as string=cookieFromAsp.value asp.net寫入 asp讀取 [asp.net寫入] Dim cookieFromDotNet As New HttpCookie("CookieNameDotnet") cookie.Value = "ASP.netVALUE" [asp讀取] v=request.Cookies("CookieNameDotnet")
Encode Function /* Base64 Encode */ CREATE FUNCTION [dbo].[f_Base64_Encode] ( @var VARCHAR(MAX) ) RETURNS VARCHAR(MAX) AS BEGIN DECLARE @Base64 VARCHAR(MAX) DECLARE @bin VARBINARY(MAX) SET @bin=CONVERT(VARBINARY(MAX),@var) SET @Base64 = CAST(N'' AS XML).value('xs:base64Binary(xs:hexBinary(sql:variable("@bin")))', 'VARCHAR(MAX)') RETURN @Base64 END Decode Function /* Base64 Decode */ CREATE FUNCTION [dbo].[f_Base64_Decode] ( @Base64 VARCHAR(MAX) ) RETURNS VARCHAR(MAX) AS BEGIN DECLARE @Bin VARBINARY(MAX) DECLare @Var VARCHAR(MAX) SET @Base64= CASE WHEN len(@Base64)%3=2 THEN @Base64+'==' WHEN len(@Base64)%3=1 THEN @Base64+'=' END SET @Bin = CAST(N'' AS XML).value('xs:base64Binary(sql:variable("@Base64"))', 'VARBINARY(MAX)') ...
Can use this method List.indexof(item) List data = new List { "A","B","A","C","B","C","D","E" }; List preferences = new List { "A","B","C" }; IEnumerable orderedData = data.OrderBy( item => preferences.IndexOf(item));