aspsessionstate.sql

来自「asp.net和asp如何通用一个Session」· SQL 代码 · 共 29 行

/*
This query creates the ASPSessionState table used to temporarily hold
Session State information for use when switching between ASP "Classic" and 
ASP.NET. The index below is optional and not recommended on small scale 
applications/systems.
*/
CREATE TABLE ASPSessionState
(
	GUID CHAR(38),			-- The Globally unique identifier
	SessionKey VARCHAR(254),	-- The Session value's "name"
	SessionValue VARCHAR(254)	-- The Session data
)
GO

/*
Optional Index for the ASPSessionState table, unless there will be frequent 
switching from Classic to .NET , this is not needed. 

Since the data is cleaned up after each use, searching for the correct 
GUID in a non-enterprise application should generally be fast 
without an index.
*/
CREATE NONCLUSTERED INDEX idxSessionStateGUID
ON ASPSessionState
(
	GUID
)
GO