亚洲欧美第一页_禁久久精品乱码_粉嫩av一区二区三区免费野_久草精品视频

? 歡迎來到蟲蟲下載站！ | ?? 資源下載 ?? 資源專輯 ?? 關于我們
? 蟲蟲下載站

?? createdbobjects.sql

?? Portal Starter Kit提供了在線管理工具
?? SQL
?? 第 1 頁 / 共 3 頁
字號: 
    Title,
    ModuleID,
    MoreLink,
    MobileMoreLink,
    ExpireDate,
    Description

FROM Portal_Announcements

WHERE
    ItemID = @ItemID


GO
SET QUOTED_IDENTIFIER OFF 
GO
SET ANSI_NULLS ON 
GO

SET QUOTED_IDENTIFIER ON 
GO
SET ANSI_NULLS ON 
GO





CREATE  PROCEDURE Portal_GetSingleContact
(
    @ItemID int
)
AS

SELECT
    CreatedByUser,
    CreatedDate,
    ModuleID,
    Name,
    Role,
    Email,
    Contact1,
    Contact2

FROM Portal_Contacts

WHERE
    ItemID = @ItemID




GO
SET QUOTED_IDENTIFIER OFF 
GO
SET ANSI_NULLS ON 
GO

SET QUOTED_IDENTIFIER ON 
GO
SET ANSI_NULLS ON 
GO




CREATE  PROCEDURE Portal_GetSingleDocument
(
    @ItemID int
)
AS

SELECT
    FileFriendlyName,
    FileNameUrl,
    CreatedByUser,
    CreatedDate,
    Category,
    ContentSize,
    ModuleID

FROM Portal_Documents

WHERE
    ItemID = @ItemID




GO
SET QUOTED_IDENTIFIER OFF 
GO
SET ANSI_NULLS ON 
GO

SET QUOTED_IDENTIFIER ON 
GO
SET ANSI_NULLS ON 
GO




CREATE  PROCEDURE Portal_GetSingleEvent
(
    @ItemID int
)
AS

SELECT
    CreatedByUser,
    CreatedDate,
    ModuleID,
    Title,
    ExpireDate,
    Description,
    WhereWhen

FROM Portal_Events

WHERE
    ItemID = @ItemID




GO
SET QUOTED_IDENTIFIER OFF 
GO
SET ANSI_NULLS ON 
GO

SET QUOTED_IDENTIFIER ON 
GO
SET ANSI_NULLS ON 
GO




CREATE  PROCEDURE Portal_GetSingleLink
(
    @ItemID int
)
AS

SELECT
    CreatedByUser,
    CreatedDate,
    ModuleID,
    Title,
    Url,
    MobileUrl,
    ViewOrder,
    Description

FROM Portal_Links

WHERE
    ItemID = @ItemID




GO
SET QUOTED_IDENTIFIER OFF 
GO
SET ANSI_NULLS ON 
GO

SET QUOTED_IDENTIFIER ON 
GO
SET ANSI_NULLS ON 
GO




CREATE  PROCEDURE Portal_GetSingleMessage
(
    @ItemID int
)
AS

DECLARE @nextMessageID int
EXECUTE Portal_GetNextMessageID @ItemID, @nextMessageID OUTPUT
DECLARE @prevMessageID int
EXECUTE Portal_GetPrevMessageID @ItemID, @prevMessageID OUTPUT

SELECT
    ItemID,
    ModuleID,
    Title,
    CreatedByUser,
    CreatedDate,
    Body,
    DisplayOrder,
    NextMessageID = @nextMessageID,
    PrevMessageID = @prevMessageID

FROM Portal_Discussion

WHERE
    ItemID = @ItemID




GO
SET QUOTED_IDENTIFIER OFF 
GO
SET ANSI_NULLS ON 
GO

SET QUOTED_IDENTIFIER ON 
GO
SET ANSI_NULLS ON 
GO




CREATE PROCEDURE Portal_GetSingleRole
(
    @RoleID int
)
AS

SELECT
    RoleName

FROM Portal_Roles

WHERE
    RoleID = @RoleID



GO
SET QUOTED_IDENTIFIER OFF 
GO
SET ANSI_NULLS ON 
GO

SET QUOTED_IDENTIFIER ON 
GO
SET ANSI_NULLS ON 
GO



CREATE PROCEDURE Portal_GetSingleUser
(
    @Email nvarchar(100)
)
AS

SELECT
    Email,
    Password,
    Name

FROM Portal_Users

WHERE
    Email = @Email



GO
SET QUOTED_IDENTIFIER OFF 
GO
SET ANSI_NULLS ON 
GO

SET QUOTED_IDENTIFIER ON 
GO
SET ANSI_NULLS ON 
GO




CREATE PROCEDURE Portal_GetThreadMessages
(
    @Parent nvarchar(750)
)
AS

SELECT
    ItemID,
    DisplayOrder,
    REPLICATE( ' ', ( ( LEN( DisplayOrder ) / 23 ) - 1 ) * 5 ) AS Indent,
    Title,  
    CreatedByUser,
    CreatedDate,
    Body

FROM Portal_Discussion

WHERE
    LEFT(DisplayOrder, 23) = @Parent
  AND
    (LEN( DisplayOrder ) / 23 ) > 1

ORDER BY
    DisplayOrder



GO
SET QUOTED_IDENTIFIER OFF 
GO
SET ANSI_NULLS ON 
GO

SET QUOTED_IDENTIFIER ON 
GO
SET ANSI_NULLS ON 
GO



CREATE PROCEDURE Portal_GetTopLevelMessages
(
    @ModuleID int
)
AS

SELECT
    ItemID,
    DisplayOrder,
    LEFT(DisplayOrder, 23) AS Parent,    
    (SELECT COUNT(*) -1  FROM Portal_Discussion Disc2 WHERE LEFT(Disc2.DisplayOrder,LEN(RTRIM(Disc.DisplayOrder))) = Disc.DisplayOrder) AS ChildCount,
    Title,  
    CreatedByUser,
    CreatedDate

FROM Portal_Discussion Disc

WHERE 
    ModuleID=@ModuleID
  AND
    (LEN( DisplayOrder ) / 23 ) = 1

ORDER BY
    DisplayOrder



GO
SET QUOTED_IDENTIFIER OFF 
GO
SET ANSI_NULLS ON 
GO

SET QUOTED_IDENTIFIER ON 
GO
SET ANSI_NULLS ON 
GO




CREATE PROCEDURE Portal_GetUsers
AS

SELECT  
    UserID,
    Email

FROM Portal_Users
    
ORDER BY Email




GO
SET QUOTED_IDENTIFIER OFF 
GO
SET ANSI_NULLS ON 
GO

SET QUOTED_IDENTIFIER ON 
GO
SET ANSI_NULLS ON 
GO




CREATE PROCEDURE Portal_UpdateAnnouncement
(
    @ItemID         int,
    @UserName       nvarchar(100),
    @Title          nvarchar(150),
    @MoreLink       nvarchar(150),
    @MobileMoreLink nvarchar(150),
    @ExpireDate     datetime,
    @Description    nvarchar(2000)
)
AS

UPDATE Portal_Announcements

SET
    CreatedByUser   = @UserName,
    CreatedDate     = GetDate(),
    Title           = @Title,
    MoreLink        = @MoreLink,
    MobileMoreLink  = @MobileMoreLink,
    ExpireDate      = @ExpireDate,
    Description     = @Description

WHERE
    ItemID = @ItemID



GO
SET QUOTED_IDENTIFIER OFF 
GO
SET ANSI_NULLS ON 
GO

SET QUOTED_IDENTIFIER ON 
GO
SET ANSI_NULLS ON 
GO



CREATE PROCEDURE Portal_UpdateContact
(
    @ItemID   int,
    @UserName nvarchar(100),
    @Name     nvarchar(50),
    @Role     nvarchar(100),
    @Email    nvarchar(100),
    @Contact1 nvarchar(250),
    @Contact2 nvarchar(250)
)
AS

UPDATE Portal_Contacts

SET
    CreatedByUser = @UserName,
    CreatedDate   = GetDate(),
    Name          = @Name,
    Role          = @Role,
    Email         = @Email,
    Contact1      = @Contact1,
    Contact2      = @Contact2

WHERE
    ItemID = @ItemID



GO
SET QUOTED_IDENTIFIER OFF 
GO
SET ANSI_NULLS ON 
GO

SET QUOTED_IDENTIFIER ON 
GO
SET ANSI_NULLS ON 
GO



CREATE PROCEDURE Portal_UpdateDocument
(
    @ItemID           int,
    @ModuleID         int,
    @FileFriendlyName nvarchar(150),
    @FileNameUrl      nvarchar(250),
    @UserName         nvarchar(100),
    @Category         nvarchar(50),
    @Content          image,
    @ContentType      nvarchar(50),
    @ContentSize      int
)
AS
IF (@ItemID=0) OR NOT EXISTS (
    SELECT 
        * 
    FROM Portal_Documents 
    WHERE 
        ItemID = @ItemID
)
INSERT INTO Portal_Documents
(
    ModuleID,
    FileFriendlyName,
    FileNameUrl,
    CreatedByUser,
    CreatedDate,
    Category,
    Content,
    ContentType,
    ContentSize
)

VALUES
(
    @ModuleID,
    @FileFriendlyName,
    @FileNameUrl,
    @UserName,
    GetDate(),
    @Category,
    @Content,
    @ContentType,
    @ContentSize
)
ELSE

BEGIN

IF (@ContentSize=0)

UPDATE Portal_Documents

SET 
    CreatedByUser    = @UserName,
    CreatedDate      = GetDate(),
    Category         = @Category,
    FileFriendlyName = @FileFriendlyName,
    FileNameUrl      = @FileNameUrl

WHERE
    ItemID = @ItemID
ELSE

UPDATE Portal_Documents

SET
    CreatedByUser     = @UserName,
    CreatedDate       = GetDate(),
    Category          = @Category,
    FileFriendlyName  = @FileFriendlyName,
    FileNameUrl       = @FileNameUrl,
    Content           = @Content,
    ContentType       = @ContentType,
    ContentSize       = @ContentSize

WHERE
    ItemID = @ItemID

END


GO
SET QUOTED_IDENTIFIER OFF 
GO
SET ANSI_NULLS ON 
GO

SET QUOTED_IDENTIFIER ON 
GO
SET ANSI_NULLS ON 
GO




CREATE PROCEDURE Portal_UpdateEvent
(
    @ItemID      int,
    @UserName    nvarchar(100),
    @Title       nvarchar(100),
    @ExpireDate  datetime,
    @Description nvarchar(2000),
    @WhereWhen   nvarchar(100)
)

AS

UPDATE Portal_Events

SET
    CreatedByUser = @UserName,
    CreatedDate   = GetDate(),
    Title         = @Title,
    ExpireDate    = @ExpireDate,
    Description   = @Description,
    WhereWhen     = @WhereWhen

WHERE
    ItemID = @ItemID



GO
SET QUOTED_IDENTIFIER OFF 
GO
SET ANSI_NULLS ON 
GO

SET QUOTED_IDENTIFIER ON 
GO
SET ANSI_NULLS ON 
GO




CREATE PROCEDURE Portal_UpdateHtmlText
(
    @ModuleID      int,
    @DesktopHtml   ntext,
    @MobileSummary ntext,
    @MobileDetails ntext
)
AS

IF NOT EXISTS (
    SELECT 
        * 
    FROM Portal_HtmlText 
    WHERE 
        ModuleID = @ModuleID
)
INSERT INTO Portal_HtmlText (
    ModuleID,
    DesktopHtml,
    MobileSummary,
    MobileDetails
) 
VALUES (
    @ModuleID,
    @DesktopHtml,
    @MobileSummary,
    @MobileDetails
)
ELSE
UPDATE Portal_HtmlText

SET
    DesktopHtml   = @DesktopHtml,
    MobileSummary = @MobileSummary,
    MobileDetails = @MobileDetails

WHERE
    ModuleID = @ModuleID



GO
SET QUOTED_IDENTIFIER OFF 
GO
SET ANSI_NULLS ON 
GO

SET QUOTED_IDENTIFIER ON 
GO
SET ANSI_NULLS ON 
GO




CREATE PROCEDURE Portal_UpdateLink
(
    @ItemID      int,
    @UserName    nvarchar(100),
    @Title       nvarchar(100),
    @Url         nvarchar(250),
    @MobileUrl   nvarchar(250),
    @ViewOrder   int,
    @Description nvarchar(2000)
)
AS

UPDATE Portal_Links

SET
    CreatedByUser = @UserName,
    CreatedDate   = GetDate(),
    Title         = @Title,
    Url           = @Url,
    MobileUrl     = @MobileUrl,
    ViewOrder     = @ViewOrder,
    Description   = @Description

WHERE
    ItemID = @ItemID



GO
SET QUOTED_IDENTIFIER OFF 
GO
SET ANSI_NULLS ON 
GO

SET QUOTED_IDENTIFIER ON 
GO
SET ANSI_NULLS ON 
GO



CREATE PROCEDURE Portal_UpdateRole
(
    @RoleID      int,
    @RoleName    nvarchar(50)
)
AS

UPDATE Portal_Roles

SET
    RoleName = @RoleName

WHERE
    RoleID = @RoleID



GO
SET QUOTED_IDENTIFIER OFF 
GO
SET ANSI_NULLS ON 
GO

SET QUOTED_IDENTIFIER OFF 
GO
SET ANSI_NULLS ON 
GO




CREATE  PROCEDURE Portal_UpdateUser
(
    @UserID        int,
    @Email           nvarchar(100),
    @Password    nvarchar(50)
)
AS

UPDATE Portal_Users

SET
    Email    = @Email,
    Password = @Password

WHERE
    UserID    = @UserID


GO
SET QUOTED_IDENTIFIER OFF 
GO
SET ANSI_NULLS ON 
GO

SET QUOTED_IDENTIFIER ON 
GO
SET ANSI_NULLS ON 
GO




CREATE  PROCEDURE Portal_UserLogin
(
    @Email    nvarchar(100),
    @Password nvarchar(50),
    @UserName nvarchar(100) OUTPUT
)
AS

SELECT
    @UserName = Name

FROM Portal_Users

WHERE
    Email = @Email
  AND
    Password = @Password




GO
SET QUOTED_IDENTIFIER OFF 
GO
SET ANSI_NULLS ON 
GO


--
-- End make objects
--

?? 快捷鍵說明

復制代碼 Ctrl + C
搜索代碼 Ctrl + F
全屏模式 F11
切換主題 Ctrl + Shift + D
顯示快捷鍵 ?
增大字號 Ctrl + =
減小字號 Ctrl + -
亚洲欧美第一页_禁久久精品乱码_粉嫩av一区二区三区免费野_久草精品视频
欧美性受极品xxxx喷水| 久久综合九色综合97婷婷| 99精品热视频| 在线电影国产精品| 中文字幕免费不卡在线| 日欧美一区二区| 色综合久久综合网欧美综合网| 日韩免费高清av| 亚洲一二三区视频在线观看| 国产+成+人+亚洲欧洲自线| 在线成人av影院| 亚洲精品高清在线| 成人美女视频在线看| 精品欧美久久久| 日本美女视频一区二区| 欧美日韩在线免费视频| 1000部国产精品成人观看| 激情图区综合网| 亚洲精品一区二区精华| 日韩和欧美的一区| 欧美日韩亚洲综合在线| 一区二区三区加勒比av| 91看片淫黄大片一级在线观看| 久久精品免视看| 国产一区二区三区四区五区美女| 3atv在线一区二区三区| 日韩高清在线不卡| 欧美一区二区三区在线观看| 丝袜亚洲另类丝袜在线| 91精品国产综合久久久蜜臀粉嫩| 亚洲电影一级片| 3d动漫精品啪啪1区2区免费| 视频一区在线播放| 欧美一级高清片| 青青草原综合久久大伊人精品 | 成人小视频在线| 久久综合九色综合欧美98| 久久99精品久久只有精品| 精品少妇一区二区三区视频免付费 | 国产成人99久久亚洲综合精品| 日韩三级在线免费观看| 麻豆极品一区二区三区| 精品国产乱码久久久久久闺蜜| 狠狠色丁香婷婷综合久久片| 国产欧美精品一区二区色综合朱莉 | 欧洲国产伦久久久久久久| 亚洲欧美日韩中文播放 | 欧美电视剧免费观看| 久久精品国产一区二区| 久久九九全国免费| 色天天综合色天天久久| 亚洲成在线观看| 欧美成人免费网站| 91在线小视频| 日韩二区在线观看| 国产日韩精品一区| 欧美偷拍一区二区| 精品一区免费av| 亚洲人精品一区| 欧美日韩国产乱码电影| 精一区二区三区| 亚洲另类春色校园小说| 91精品蜜臀在线一区尤物| 欧美色涩在线第一页| 精品一区二区在线观看| 久久精品视频在线看| 91视视频在线直接观看在线看网页在线看| 亚洲午夜精品久久久久久久久| 日韩美女主播在线视频一区二区三区| 国产aⅴ综合色| 日精品一区二区三区| 国产精品视频一二三| 欧美丰满少妇xxxxx高潮对白| 国产高清精品久久久久| 亚洲va国产va欧美va观看| 久久久激情视频| 欧美日韩不卡视频| 91影视在线播放| 国内精品伊人久久久久av影院| 亚洲免费在线看| 国产欧美日韩在线视频| 91精品国产欧美一区二区| 成人看片黄a免费看在线| 久久国内精品自在自线400部| 亚洲欧美日韩久久| 国产肉丝袜一区二区| 911国产精品| 欧美影院精品一区| 丰满少妇久久久久久久| 激情文学综合插| 日本成人在线看| 亚洲1区2区3区视频| 亚洲另类春色校园小说| 国产精品乱码一区二区三区软件| 久久伊99综合婷婷久久伊| 在线观看91av| 91精品黄色片免费大全| 在线看不卡av| 在线视频你懂得一区| 色综合久久综合网97色综合| 9人人澡人人爽人人精品| 国产成人高清视频| 国产一区二区不卡| 韩国一区二区在线观看| 免费成人美女在线观看| 麻豆91在线播放免费| 天天免费综合色| 爽好多水快深点欧美视频| 亚洲一级二级在线| 亚洲自拍偷拍图区| 午夜欧美2019年伦理| 午夜不卡在线视频| 日韩电影在线免费看| 免费成人小视频| 老司机午夜精品| 韩国成人精品a∨在线观看| 日韩av一区二区三区四区| 久久国产夜色精品鲁鲁99| 精品在线免费观看| 精久久久久久久久久久| 国产一区二区三区精品视频| 国产成人午夜片在线观看高清观看| 狠狠色2019综合网| 成人一级黄色片| 99精品国产91久久久久久 | 99久久er热在这里只有精品66| 不卡在线视频中文字幕| 成人h动漫精品一区二区| 色婷婷一区二区| 在线播放国产精品二区一二区四区| 69久久99精品久久久久婷婷| 日韩欧美国产三级电影视频| 久久久午夜精品理论片中文字幕| 国产欧美在线观看一区| 亚洲黄色尤物视频| 欧美96一区二区免费视频| 韩国一区二区在线观看| av资源站一区| 欧美电影一区二区三区| 国产偷v国产偷v亚洲高清| 亚洲视频在线观看三级| 日韩国产高清影视| 成人精品国产一区二区4080| 欧美日韩一区二区在线观看| 日韩午夜在线观看视频| 中文子幕无线码一区tr| 亚洲成人三级小说| 国产一区在线观看麻豆| 91女人视频在线观看| 欧美一区二区啪啪| 国产精品成人一区二区艾草| 日韩成人午夜电影| 91丨九色丨尤物| 精品免费国产二区三区| 亚洲免费观看视频| 国产乱妇无码大片在线观看| 色吧成人激情小说| 久久亚洲私人国产精品va媚药| 亚洲婷婷在线视频| 精东粉嫩av免费一区二区三区| 91最新地址在线播放| 欧美成人a∨高清免费观看| 亚洲乱码精品一二三四区日韩在线| 热久久国产精品| 在线视频你懂得一区二区三区| 26uuuu精品一区二区| 亚洲成人免费观看| 成a人片亚洲日本久久| 精品99999| 午夜精品爽啪视频| 91九色最新地址| 中文字幕免费一区| 精品夜夜嗨av一区二区三区| 欧美日韩情趣电影| 亚洲精品免费一二三区| 国产福利91精品| 日韩三级视频在线看| 偷窥国产亚洲免费视频| 91黄色免费版| ●精品国产综合乱码久久久久| 国产精品综合视频| 日韩美女视频在线| 美腿丝袜亚洲色图| 日韩欧美一二三区| 蜜臀久久久99精品久久久久久| 欧美日韩精品一区视频| 亚洲一区二区在线免费观看视频| 91免费视频观看| 综合婷婷亚洲小说| 91日韩精品一区| 亚洲另类在线制服丝袜| 91美女片黄在线| 亚洲人xxxx| 91老司机福利 在线| 亚洲精品国产一区二区精华液 | 欧美电影免费观看高清完整版在线观看 | 亚洲一区二区精品久久av| 91网站在线播放| 亚洲综合色自拍一区| 在线精品国精品国产尤物884a|