一个DNN安装时的未知错误
今天在做DNN的一个模块的安装包时遇到一个莫明的错误,数据库的安装文件运行时总是出现错误,以下是我的数据库安装文件。我直接用DNN中的SQL服务作为脚本运行 是没有问题的,但安装时出错。
/************************************************************/
/***** SQLDataProvider *****/
/***** Article *****/
/***** *****/
/***** Note: To manually execute this script you must *****/
/***** perform a search and replace operation *****/
/***** for {databaseOwner} and {objectQualifier} *****/
/***** *****/
/************************************************************/
![](/Images/OutliningIndicators/None.gif)
/***** My Function *****/
if exists (select * from {databaseOwner}{objectQualifier}sysobjects where id = object_id(N'{databaseOwner}[{objectQualifier}f_splitstr]') and xtype in (N'FN', N'IF', N'TF'))
drop function {databaseOwner}[{objectQualifier}f_splitstr]
GO
![](/Images/OutliningIndicators/None.gif)
/***** Procedure *****/
if exists (select * from {databaseOwner}{objectQualifier}sysobjects where id = object_id(N'{databaseOwner}[{objectQualifier}gdlmo_AccesoryGet]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure {databaseOwner}[{objectQualifier}gdlmo_AccesoryGet]
GO
![](/Images/OutliningIndicators/None.gif)
if exists (select * from {databaseOwner}{objectQualifier}sysobjects where id = object_id(N'{databaseOwner}[{objectQualifier}gdlmo_AccesoryListByArticleId]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure {databaseOwner}[{objectQualifier}gdlmo_AccesoryListByArticleId]
GO
![](/Images/OutliningIndicators/None.gif)
if exists (select * from {databaseOwner}{objectQualifier}sysobjects where id = object_id(N'{databaseOwner}[{objectQualifier}gdlmo_ArticleAdd]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure {databaseOwner}[{objectQualifier}gdlmo_ArticleAdd]
GO
![](/Images/OutliningIndicators/None.gif)
if exists (select * from {databaseOwner}{objectQualifier}sysobjects where id = object_id(N'{databaseOwner}[{objectQualifier}gdlmo_ArticleAndAccesoryUpdate]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure {databaseOwner}[{objectQualifier}gdlmo_ArticleAndAccesoryUpdate]
GO
![](/Images/OutliningIndicators/None.gif)
if exists (select * from {databaseOwner}{objectQualifier}sysobjects where id = object_id(N'{databaseOwner}[{objectQualifier}gdlmo_ArticleDelete]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure {databaseOwner}[{objectQualifier}gdlmo_ArticleDelete]
GO
![](/Images/OutliningIndicators/None.gif)
if exists (select * from {databaseOwner}{objectQualifier}sysobjects where id = object_id(N'{databaseOwner}[{objectQualifier}gdlmo_ArticleGet]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure {databaseOwner}[{objectQualifier}gdlmo_ArticleGet]
GO
![](/Images/OutliningIndicators/None.gif)
if exists (select * from {databaseOwner}{objectQualifier}sysobjects where id = object_id(N'{databaseOwner}[{objectQualifier}gdlmo_ArticleGetByCategory]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure {databaseOwner}[{objectQualifier}gdlmo_ArticleGetByCategory]
GO
![](/Images/OutliningIndicators/None.gif)
if exists (select * from {databaseOwner}{objectQualifier}sysobjects where id = object_id(N'{databaseOwner}[{objectQualifier}gdlmo_ArticleGetRcount]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure {databaseOwner}[{objectQualifier}gdlmo_ArticleGetRcount]
GO
![](/Images/OutliningIndicators/None.gif)
if exists (select * from {databaseOwner}{objectQualifier}sysobjects where id = object_id(N'{databaseOwner}[{objectQualifier}gdlmo_ArticleGetRcountByCategory]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure {databaseOwner}[{objectQualifier}gdlmo_ArticleGetRcountByCategory]
GO
![](/Images/OutliningIndicators/None.gif)
if exists (select * from {databaseOwner}{objectQualifier}sysobjects where id = object_id(N'{databaseOwner}[{objectQualifier}gdlmo_ArticleGetRcountByDateCategory]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure {databaseOwner}[{objectQualifier}gdlmo_ArticleGetRcountByDateCategory]
GO
![](/Images/OutliningIndicators/None.gif)
if exists (select * from {databaseOwner}{objectQualifier}sysobjects where id = object_id(N'{databaseOwner}[{objectQualifier}gdlmo_ArticleList]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure {databaseOwner}[{objectQualifier}gdlmo_ArticleList]
GO
![](/Images/OutliningIndicators/None.gif)
if exists (select * from {databaseOwner}{objectQualifier}sysobjects where id = object_id(N'{databaseOwner}[{objectQualifier}gdlmo_ArticleSignedAdd]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure {databaseOwner}[{objectQualifier}gdlmo_ArticleSignedAdd]
GO
![](/Images/OutliningIndicators/None.gif)
if exists (select * from {databaseOwner}{objectQualifier}sysobjects where id = object_id(N'{databaseOwner}[{objectQualifier}gdlmo_ArticleSignedUsers]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure {databaseOwner}[{objectQualifier}gdlmo_ArticleSignedUsers]
GO
![](/Images/OutliningIndicators/None.gif)
if exists (select * from {databaseOwner}{objectQualifier}sysobjects where id = object_id(N'{databaseOwner}[{objectQualifier}gdlmo_ArticleUnSignedGetByUser]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure {databaseOwner}[{objectQualifier}gdlmo_ArticleUnSignedGetByUser]
GO
![](/Images/OutliningIndicators/None.gif)
if exists (select * from {databaseOwner}{objectQualifier}sysobjects where id = object_id(N'{databaseOwner}[{objectQualifier}gdlmo_ArticleUnSignedUsers]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure {databaseOwner}[{objectQualifier}gdlmo_ArticleUnSignedUsers]
GO
![](/Images/OutliningIndicators/None.gif)
if exists (select * from {databaseOwner}{objectQualifier}sysobjects where id = object_id(N'{databaseOwner}[{objectQualifier}gdlmo_ArticleUpdate]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure {databaseOwner}[{objectQualifier}gdlmo_ArticleUpdate]
GO
![](/Images/OutliningIndicators/None.gif)
if exists (select * from {databaseOwner}{objectQualifier}sysobjects where id = object_id(N'{databaseOwner}[{objectQualifier}gdlmo_GetCount]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure {databaseOwner}[{objectQualifier}gdlmo_GetCount]
GO
![](/Images/OutliningIndicators/None.gif)
if exists (select * from {databaseOwner}{objectQualifier}sysobjects where id = object_id(N'{databaseOwner}[{objectQualifier}gdlmo_GetPagingData]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure {databaseOwner}[{objectQualifier}gdlmo_GetPagingData]
GO
![](/Images/OutliningIndicators/None.gif)
/****** Object: Table {databaseOwner}[{objectQualifier}gdlmo_Article] Script Date: 2007-12-17 8:59:40 ******/
if exists (select * from {databaseOwner}{objectQualifier}sysobjects where id = object_id(N'{databaseOwner}[{objectQualifier}gdlmo_Article]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table {databaseOwner}[{objectQualifier}gdlmo_Article]
GO
![](/Images/OutliningIndicators/None.gif)
/****** Object: Table {databaseOwner}[{objectQualifier}gdlmo_ArticleSigned] Script Date: 2007-12-17 8:59:40 ******/
if exists (select * from {databaseOwner}{objectQualifier}sysobjects where id = object_id(N'{databaseOwner}[{objectQualifier}gdlmo_ArticleSigned]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table {databaseOwner}[{objectQualifier}gdlmo_ArticleSigned]
GO
![](/Images/OutliningIndicators/None.gif)
/****** Object: Table {databaseOwner}[{objectQualifier}gdlmo_Article_Accesory] Script Date: 2007-12-17 8:59:40 ******/
if exists (select * from {databaseOwner}{objectQualifier}sysobjects where id = object_id(N'{databaseOwner}[{objectQualifier}gdlmo_Article_Accesory]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table {databaseOwner}[{objectQualifier}gdlmo_Article_Accesory]
GO
![](/Images/OutliningIndicators/None.gif)
/****** Object: Table {databaseOwner}[{objectQualifier}gdlmo_Article] Script Date: 2007-12-17 8:59:42 ******/
CREATE TABLE {databaseOwner}[{objectQualifier}gdlmo_Article] (
[ArticleID] [int] IDENTITY (1, 1) NOT NULL ,
[CategoryID] [int] NULL ,
[Title] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
[CreatedDate] [smalldatetime] NULL ,
[CreatedByUser] [nvarchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
[CopyFrom] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
[Author] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
[Hits] [int] NULL ,
[IsPassed] [bit] NULL ,
[IP] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[DeptName] [nvarchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
[Summary] [nvarchar] (2000) COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY]
GO
![](/Images/OutliningIndicators/None.gif)
/****** Object: Table {databaseOwner}[{objectQualifier}gdlmo_ArticleSigned] Script Date: 2007-12-17 8:59:44 ******/
CREATE TABLE {databaseOwner}[{objectQualifier}gdlmo_ArticleSigned] (
[ArticleSignedId] [int] IDENTITY (1, 1) NOT NULL ,
[UserId] [int] NOT NULL ,
[ArticleId] [int] NOT NULL ,
[SignedDate] [datetime] NULL
) ON [PRIMARY]
GO
![](/Images/OutliningIndicators/None.gif)
/****** Object: Table {databaseOwner}[{objectQualifier}gdlmo_Article_Accesory] Script Date: 2007-12-17 8:59:44 ******/
CREATE TABLE {databaseOwner}[{objectQualifier}gdlmo_Article_Accesory] (
[AccesoryId] [int] IDENTITY (1, 1) NOT NULL ,
[ArticleId] [int] NOT NULL ,
[ArticleName] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
[IsActive] [bit] NULL
) ON [PRIMARY]
GO
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
ALTER TABLE {databaseOwner}[{objectQualifier}gdlmo_Article] WITH NOCHECK ADD
CONSTRAINT [PK{objectQualifier}_gdlmo_Article] PRIMARY KEY CLUSTERED
(
[ArticleID]
) ON [PRIMARY]
GO
![](/Images/OutliningIndicators/None.gif)
ALTER TABLE {databaseOwner}[{objectQualifier}gdlmo_ArticleSigned] WITH NOCHECK ADD
CONSTRAINT [PK{objectQualifier}_gdlmo_ArticleSigned] PRIMARY KEY CLUSTERED
(
[ArticleSignedId]
) ON [PRIMARY]
GO
![](/Images/OutliningIndicators/None.gif)
ALTER TABLE {databaseOwner}[{objectQualifier}gdlmo_Article_Accesory] WITH NOCHECK ADD
CONSTRAINT [PK{objectQualifier}_gdlmo_Article_Accesory] PRIMARY KEY CLUSTERED
(
[AccesoryId]
) ON [PRIMARY]
GO
![](/Images/OutliningIndicators/None.gif)
CREATE function f_splitstr
(
@SourceSql varchar(8000),
@StrSeprate varchar(10)
)
returns @temp table(F1 varchar(100))
as
begin
declare @i int
set @SourceSql=rtrim(ltrim(@SourceSql))
set @i=charindex(@StrSeprate,@SourceSql)
while @i>=1
begin
insert @temp values(left(@SourceSql,@i-1))
set @SourceSql=substring(@SourceSql,@i+1,len(@SourceSql)-@i)
set @i=charindex(@StrSeprate,@SourceSql)
end
if @SourceSql<>''
insert @temp values(@SourceSql)
return
end
![](/Images/OutliningIndicators/None.gif)
GO
![](/Images/OutliningIndicators/None.gif)
CREATE PROCEDURE {databaseOwner}{objectQualifier}gdlmo_AccesoryGet
@AccesoryID int
AS
![](/Images/OutliningIndicators/None.gif)
SELECT
[AccesoryId],
[ArticleId],
[ArticleName]
FROM gdlmo_Article_Accesory
WHERE [AccesoryId] = @AccesoryId
![](/Images/OutliningIndicators/None.gif)
GO
/****** Object: Stored Procedure {databaseOwner}{objectQualifier}gdlmo_AccesoryListByArticleId Script Date: 2007-6-20 21:28:27 ******/
CREATE PROCEDURE {databaseOwner}{objectQualifier}gdlmo_AccesoryListByArticleId
@ArticleId int
AS
![](/Images/OutliningIndicators/None.gif)
SELECT
[AccesoryId],
[ArticleId],
[ArticleName]
FROM gdlmo_Article_Accesory
WHERE [ArticleId] = @ArticleId
![](/Images/OutliningIndicators/None.gif)
GO
/****** Object: Stored Procedure {databaseOwner}{objectQualifier}gdlmo_ArticleDelete Script Date: 2007-6-20 21:28:27 ******/
![](/Images/OutliningIndicators/None.gif)
CREATE PROCEDURE {databaseOwner}{objectQualifier}gdlmo_ArticleDelete
@ArticleID int
AS
![](/Images/OutliningIndicators/None.gif)
DELETE FROM {databaseOwner}{objectQualifier}gdlmo_Article
WHERE
[ArticleID] = @ArticleID
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
GO
/****** Object: Stored Procedure {databaseOwner}{objectQualifier}gdlmo_ArticleGet Script Date: 2007-6-20 21:28:27 ******/
![](/Images/OutliningIndicators/None.gif)
CREATE PROCEDURE {databaseOwner}{objectQualifier}gdlmo_ArticleGet
@ArticleID int
AS
![](/Images/OutliningIndicators/None.gif)
SELECT
[ArticleID],
[CategoryID],
[Title],
[CreatedDate],
[CreatedByUser],
[CopyFrom],
[Author],
[Hits],
[IsPassed],
[IP],
[DeptName],
[Summary]
FROM gdlmo_Article
WHERE
[ArticleID] = @ArticleID
![](/Images/OutliningIndicators/None.gif)
GO
/****** Object: Stored Procedure {databaseOwner}{objectQualifier}gdlmo_ArticleGetByCategory Script Date: 2007-6-20 21:28:27 ******/
![](/Images/OutliningIndicators/None.gif)
CREATE PROCEDURE {databaseOwner}{objectQualifier}gdlmo_ArticleGetByCategory
@CategoryID int
AS
![](/Images/OutliningIndicators/None.gif)
SELECT
[ArticleID],
[CategoryID],
[Title],
[CreatedDate],
[CreatedByUser],
[CopyFrom],
[Author],
[Hits],
[IsPassed],
[IP],
[DeptName],
[Summary]
FROM gdlmo_Article
WHERE
[CategoryID]=@CategoryID
![](/Images/OutliningIndicators/None.gif)
GO
/****** Object: Stored Procedure {databaseOwner}{objectQualifier}gdlmo_ArticleGetRcount Script Date: 2007-6-20 21:28:27 ******/
CREATE PROCEDURE {databaseOwner}{objectQualifier}[gdlmo_ArticleGetRcount]
AS
SELECT COUNT(*) AS ArticleCount
FROM {databaseOwner}{objectQualifier}gdlmo_Article
RETURN
![](/Images/OutliningIndicators/None.gif)
GO
/****** Object: Stored Procedure {databaseOwner}{objectQualifier}gdlmo_ArticleGetRcountByCategory Script Date: 2007-6-20 21:28:27 ******/
CREATE PROCEDURE {databaseOwner}{objectQualifier}[gdlmo_ArticleGetRcountByCategory]
@CategoryID int
AS
SELECT COUNT(*) AS ArticleCount
FROM {databaseOwner}{objectQualifier}gdlmo_Article
where CategoryID = @CategoryID
RETURN
![](/Images/OutliningIndicators/None.gif)
GO
/****** Object: Stored Procedure {databaseOwner}{objectQualifier}gdlmo_ArticleGetRcountByDateCategory Script Date: 2007-6-20 21:28:27 ******/
CREATE PROCEDURE {databaseOwner}{objectQualifier}[gdlmo_ArticleGetRcountByDateCategory]
@CategoryID int,
@StartDate smalldatetime,
@EndDate smalldatetime
AS
SELECT COUNT(*) AS ArticleCount
FROM {databaseOwner}{objectQualifier}gdlmo_Article
where ((CategoryID = @CategoryID) and (CreatedDate between @StartDate and @EndDate))
RETURN
![](/Images/OutliningIndicators/None.gif)
GO
/****** Object: Stored Procedure {databaseOwner}{objectQualifier}gdlmo_ArticleList Script Date: 2007-6-20 21:28:27 ******/
![](/Images/OutliningIndicators/None.gif)
CREATE PROCEDURE {databaseOwner}{objectQualifier}gdlmo_ArticleList
AS
![](/Images/OutliningIndicators/None.gif)
SELECT
[ArticleID],
[CategoryID],
[Title],
[CreatedDate],
[CreatedByUser],
[CopyFrom],
[Author],
[Hits],
[IsPassed],
[IP],
[DeptName],
[Summary]
FROM gdlmo_Article
![](/Images/OutliningIndicators/None.gif)
GO
/****** Object: Stored Procedure {databaseOwner}{objectQualifier}gdlmo_ArticleSignedAdd Script Date: 2007-6-20 21:28:27 ******/
![](/Images/OutliningIndicators/None.gif)
/***************************************************************************************
![](/Images/OutliningIndicators/InBlock.gif)
增加文件签收记录,返回新插入的记录ID或已有记录的ID
****************************************************************************************/
CREATE PROCEDURE {databaseOwner}{objectQualifier}[gdlmo_ArticleSignedAdd]
@UserId int,
@ArticleId int,
@SignedDate DateTime
AS
DECLARE @Rcount INT
SELECT @Rcount = COUNT(*) FROM gdlmo_ArticleSigned WHERE (UserId=@UserId And ArticleId = @ArticleId)
![](/Images/OutliningIndicators/None.gif)
IF @Rcount>0
BEGIN
SELECT ArticleSignedId FROM gdlmo_ArticleSigned WHERE UserId=@UserId And ArticleId = @ArticleId
END
ELSE
BEGIN
INSERT INTO gdlmo_ArticleSigned
(
[UserId],
[ArticleId],
[SignedDate]
) VALUES (
@UserId,
@ArticleId,
@SignedDate
)
![](/Images/OutliningIndicators/None.gif)
SELECT SCOPE_IDENTITY()
END
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
GO
![](/Images/OutliningIndicators/None.gif)
/****** Object: Stored Procedure {databaseOwner}{objectQualifier}gdlmo_ArticleSignedUsers Script Date: 2007-6-20 21:28:27 ******/
/***************************************************************************************
![](/Images/OutliningIndicators/InBlock.gif)
获取指定文件的未签收用户
****************************************************************************************/
CREATE PROCEDURE {databaseOwner}{objectQualifier}gdlmo_ArticleSignedUsers
(
@PortalId int,
@RoleId int,
@ArticleId int
)
AS
/*
名称:GetPagingRecord
作用:获取指定文件的未签收用户
作者:莫光健(gdlmo)
时间:2006-12-14
声明:此代码你可以无偿使用及转载,但在转载时,请勿移称本文字声明
*/
SELECT U.UserID,
UP.PortalId,
U.Username,
U.FirstName,
U.LastName,
U.DisplayName,
U.IsSuperUser,
U.Email,
U.AffiliateId,
U.UpdatePassword
FROM UserPortals AS UP INNER JOIN users AS U ON UP.UserId = U.UserID
WHERE ( UP.PortalId = @PortalId OR @PortalId IS Null ) AND
(u.userid in (SELECT userid FROM gdlmo_ArticleSigned WHERE articleid=@ArticleId)) AND
u.userid in (SELECT userid FROM UserRoles WHERE Roleid=@RoleId)
![](/Images/OutliningIndicators/None.gif)
GO
/****** Object: Stored Procedure {databaseOwner}{objectQualifier}gdlmo_ArticleUnSignedGetByUser Script Date: 2007-6-20 21:28:27 ******/
/*
获取指定用户未签收的文件
*/
CREATE PROCEDURE {databaseOwner}{objectQualifier}[gdlmo_ArticleUnSignedGetByUser]
@UserId int
AS
SELECT [ArticleID],
[CategoryID],
[Title],
[CreatedDate],
[CreatedByUser],
[CopyFrom],
[Author],
[Hits],
[IsPassed],
[IP],
[DeptName]
FROM gdlmo_Article
WHERE ArticleId not in
(
![](/Images/OutliningIndicators/None.gif)
SELECT ArticleId FROM gdlmo_articlesigned WHERE userid =@UserId
![](/Images/OutliningIndicators/None.gif)
)
![](/Images/OutliningIndicators/None.gif)
GO
/****** Object: Stored Procedure {databaseOwner}{objectQualifier}gdlmo_ArticleUnSignedUsers Script Date: 2007-6-20 21:28:27 ******/
/***************************************************************************************
![](/Images/OutliningIndicators/InBlock.gif)
获取指定文件的未签收用户
****************************************************************************************/
CREATE PROCEDURE {databaseOwner}{objectQualifier}gdlmo_ArticleUnSignedUsers
(
@PortalId int,
@RoleId int,
@ArticleId int
)
AS
/*
名称:GetPagingRecord
作用:获取指定文件的未签收用户
作者:莫光健(gdlmo)
时间:2006-12-14
声明:此代码你可以无偿使用及转载,但在转载时,请勿移称本文字声明
*/
SELECT U.UserID,
UP.PortalId,
U.Username,
U.FirstName,
U.LastName,
U.DisplayName,
U.IsSuperUser,
U.Email,
U.AffiliateId,
U.UpdatePassword
FROM UserPortals AS UP INNER JOIN users AS U ON UP.UserId = U.UserID
WHERE ( UP.PortalId = @PortalId OR @PortalId IS Null ) AND
(u.userid not in (SELECT userid FROM gdlmo_ArticleSigned WHERE articleid=@ArticleId)) AND
u.userid in (SELECT userid FROM UserRoles WHERE Roleid=@RoleId)
![](/Images/OutliningIndicators/None.gif)
GO
/****** Object: Stored Procedure {databaseOwner}{objectQualifier}gdlmo_ArticleUpdate Script Date: 2007-6-20 21:28:27 ******/
![](/Images/OutliningIndicators/None.gif)
CREATE PROCEDURE {databaseOwner}{objectQualifier}gdlmo_ArticleUpdate
@ArticleID int,
@CategoryID int,
@Title nvarchar(255),
@CreatedDate smalldatetime,
@CreatedByUser nvarchar(100),
@CopyFrom nvarchar(255),
@Author nvarchar(255),
@Hits int,
@IsPassed bit,
@IP nvarchar(50),
@DeptName nvarchar(100) ,
@Summary nvarchar(2000)
AS
![](/Images/OutliningIndicators/None.gif)
UPDATE gdlmo_Article SET
[CategoryID] = @CategoryID,
[Title] = @Title,
[CreatedDate] = @CreatedDate,
[CreatedByUser] = @CreatedByUser,
[CopyFrom] = @CopyFrom,
[Author] = @Author,
[Hits] = @Hits,
[IsPassed] = @IsPassed,
[IP] = @IP,
[DeptName] = @DeptName,
[Summary] = @Summary
WHERE
[ArticleID] = @ArticleID
![](/Images/OutliningIndicators/None.gif)
GO
![](/Images/OutliningIndicators/None.gif)
/****** Object: Stored Procedure {databaseOwner}{objectQualifier}gdlmo_ArticleAdd Script Date: 2007-6-20 21:28:27 ******/
![](/Images/OutliningIndicators/None.gif)
CREATE PROCEDURE {databaseOwner}{objectQualifier}gdlmo_ArticleAdd
@CategoryID int,
@Title nvarchar(255),
@CreatedDate smalldatetime,
@CreatedByUser nvarchar(100),
@CopyFrom nvarchar(255),
@Author nvarchar(255),
@Hits int,
@IsPassed bit,
@IP nvarchar(50),
@DeptName nvarchar(100),
@Summary nvarchar(2000),
@ArticleNames nvarchar (2000)
AS
![](/Images/OutliningIndicators/None.gif)
DECLARE @ArticleId int
BEGIN
INSERT INTO gdlmo_Article (
[CategoryID],
[Title],
[CreatedDate],
[CreatedByUser],
[CopyFrom],
[Author],
[Hits],
[IsPassed],
[IP],
[DeptName],
[Summary]
) VALUES (
@CategoryID,
@Title,
@CreatedDate,
@CreatedByUser,
@CopyFrom,
@Author,
@Hits,
@IsPassed,
@IP,
@DeptName,
@Summary
)
![](/Images/OutliningIndicators/None.gif)
SELECT @ArticleId = SCOPE_IDENTITY()
END
![](/Images/OutliningIndicators/None.gif)
BEGIN
DECLARE @strSql varchar(1000)
![](/Images/OutliningIndicators/None.gif)
SET @strsql = 'insert into gdlmo_article_accesory(articleid,articlename) '
SET @strsql = @strsql + ' select ' + str(@ArticleId) + ',* from {databaseOwner}{objectQualifier}f_splitstr('''+ @ArticleNames + ''','';'')'
EXEC (@strsql)
END
SELECT @ArticleId
![](/Images/OutliningIndicators/None.gif)
GO
![](/Images/OutliningIndicators/None.gif)
/****** Object: Stored Procedure {databaseOwner}{objectQualifier}gdlmo_ArticleAndAccesoryUpdate Script Date: 2007-6-20 21:28:27 ******/
CREATE PROCEDURE {databaseOwner}{objectQualifier}gdlmo_ArticleAndAccesoryUpdate
@ArticleId int,
@CategoryID int,
@Title nvarchar(255),
@CreatedDate smalldatetime,
@CreatedByUser nvarchar(100),
@CopyFrom nvarchar(255),
@Author nvarchar(255),
@Hits int,
@IsPassed bit,
@IP nvarchar(50),
@DeptName nvarchar(100) ,
@Summary nvarchar(2000),
@ArticleNames nvarchar (2000)
AS
![](/Images/OutliningIndicators/None.gif)
UPDATE gdlmo_Article SET
[CategoryID] = @CategoryID,
[Title] = @Title,
[CreatedDate] = @CreatedDate,
[CreatedByUser] = @CreatedByUser,
[CopyFrom] = @CopyFrom,
[Author] = @Author,
[Hits] = @Hits,
[IsPassed] = @IsPassed,
[IP] = @IP,
[DeptName] = @DeptName,
[Summary] = @Summary
WHERE
[ArticleID] = @ArticleId
![](/Images/OutliningIndicators/None.gif)
BEGIN
![](/Images/OutliningIndicators/None.gif)
DECLARE @strSql varchar(1000)
SET @strsql = 'DELETE FROM gdlmo_article_accesory WHERE ArticleId = '+ cast(@ArticleId as varchar) + ' '
SET @strsql = @strsql + 'insert into gdlmo_article_accesory(articleid,articlename) '
SET @strsql = @strsql + 'select ' + cast(@ArticleId as varchar) + ',* from {databaseOwner}{objectQualifier}f_splitstr('''+ @ArticleNames + ''','';'')'
EXEC (@strsql)
END
![](/Images/OutliningIndicators/None.gif)
GO
有没有高手能给我指指错在那吗?
![](/Images/OutliningIndicators/ExpandedBlockStart.gif)
![](/Images/OutliningIndicators/ExpandedBlockStart.gif)
![](/Images/OutliningIndicators/ExpandedBlockStart.gif)
![](/Images/OutliningIndicators/ExpandedBlockStart.gif)
![](/Images/OutliningIndicators/ExpandedBlockStart.gif)
![](/Images/OutliningIndicators/ExpandedBlockStart.gif)
![](/Images/OutliningIndicators/ExpandedBlockStart.gif)
![](/Images/OutliningIndicators/ExpandedBlockStart.gif)
![](/Images/OutliningIndicators/ExpandedBlockStart.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/ExpandedBlockStart.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/ExpandedBlockStart.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/ExpandedBlockStart.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/ExpandedBlockStart.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/ExpandedBlockStart.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/ExpandedBlockStart.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/ExpandedBlockStart.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/ExpandedBlockStart.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/ExpandedBlockStart.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/ExpandedBlockStart.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/ExpandedBlockStart.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/ExpandedBlockStart.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/ExpandedBlockStart.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/ExpandedBlockStart.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/ExpandedBlockStart.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/ExpandedBlockStart.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/ExpandedBlockStart.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/ExpandedBlockStart.gif)
![](/Images/OutliningIndicators/InBlock.gif)
![](/Images/OutliningIndicators/InBlock.gif)
![](/Images/OutliningIndicators/ExpandedBlockEnd.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/ExpandedBlockStart.gif)
![](/Images/OutliningIndicators/ExpandedBlockStart.gif)
![](/Images/OutliningIndicators/InBlock.gif)
![](/Images/OutliningIndicators/InBlock.gif)
![](/Images/OutliningIndicators/ExpandedBlockEnd.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/ExpandedBlockStart.gif)
![](/Images/OutliningIndicators/InBlock.gif)
![](/Images/OutliningIndicators/InBlock.gif)
![](/Images/OutliningIndicators/InBlock.gif)
![](/Images/OutliningIndicators/InBlock.gif)
![](/Images/OutliningIndicators/InBlock.gif)
![](/Images/OutliningIndicators/ExpandedBlockEnd.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/ExpandedBlockStart.gif)
![](/Images/OutliningIndicators/ExpandedBlockStart.gif)
![](/Images/OutliningIndicators/InBlock.gif)
![](/Images/OutliningIndicators/ExpandedBlockEnd.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/ExpandedBlockStart.gif)
![](/Images/OutliningIndicators/ExpandedBlockStart.gif)
![](/Images/OutliningIndicators/InBlock.gif)
![](/Images/OutliningIndicators/InBlock.gif)
![](/Images/OutliningIndicators/ExpandedBlockEnd.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/ExpandedBlockStart.gif)
![](/Images/OutliningIndicators/InBlock.gif)
![](/Images/OutliningIndicators/InBlock.gif)
![](/Images/OutliningIndicators/InBlock.gif)
![](/Images/OutliningIndicators/InBlock.gif)
![](/Images/OutliningIndicators/InBlock.gif)
![](/Images/OutliningIndicators/ExpandedBlockEnd.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/ExpandedBlockStart.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/ExpandedBlockStart.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/ExpandedBlockStart.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
开始 | 开始 Sql 操作 01.00.00.SqlDataProvider 文件 |
失败 | SQL 操作 异常: System.Data.SqlClient.SqlException: 第 54 行: ' select ' 附近有语法错误。 at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) in D:\web\DNN337\Providers\DataProviders\SqlDataProvider\SqlDataProvider.vb:line 148 at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) in D:\web\DNN337\Providers\DataProviders\SqlDataProvider\SqlDataProvider.vb:line 303 /****** Object: Stored Procedure dbo.gdlmo_ArticleAdd Script Date: 2007-6-20 21:28:27 ******/ CREATE PROCEDURE dbo.gdlmo_ArticleAdd @CategoryID int, @Title nvarchar(255), @CreatedDate smalldatetime, @CreatedByUser nvarchar(100), @CopyFrom nvarchar(255), @Author nvarchar(255), @Hits int, @IsPassed bit, @IP nvarchar(50), @DeptName nvarchar(100), @Summary nvarchar(2000), @ArticleNames nvarchar (2000) AS DECLARE @ArticleId int BEGIN INSERT INTO gdlmo_Article ( [CategoryID], [Title], [CreatedDate], [CreatedByUser], [CopyFrom], [Author], [Hits], [IsPassed], [IP], [DeptName], [Summary] ) VALUES ( @CategoryID, @Title, @CreatedDate, @CreatedByUser, @CopyFrom, @Author, @Hits, @IsPassed, @IP, @DeptName, @Summary ) SELECT @ArticleId = SCOPE_IDENTITY() END BEGIN DECLARE @strSql varchar(1000) SET @strsql = 'insert into gdlmo_article_accesory(articleid,articlename) ' SET @strsql = @strsql ' select ' str(@ArticleId) ',* from dbo.f_splitstr(''' @ArticleNames ''','';'')' EXEC (@strsql) END SELECT @ArticleId System.Data.SqlClient.SqlException: 第 37 行: 'cast' 附近有语法错误。第 38 行: 'insert into gdlmo_article_accesory(articleid,articlename) ' 附近有语法错误。第 39 行: 'select ' 附近有语法错误。 at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) in D:\web\DNN337\Providers\DataProviders\SqlDataProvider\SqlDataProvider.vb:line 148 at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) in D:\web\DNN337\Providers\DataProviders\SqlDataProvider\SqlDataProvider.vb:line 303 /****** Object: Stored Procedure dbo.gdlmo_ArticleAndAccesoryUpdate Script Date: 2007-6-20 21:28:27 ******/ CREATE PROCEDURE dbo.gdlmo_ArticleAndAccesoryUpdate @ArticleId int, @CategoryID int, @Title nvarchar(255), @CreatedDate smalldatetime, @CreatedByUser nvarchar(100), @CopyFrom nvarchar(255), @Author nvarchar(255), @Hits int, @IsPassed bit, @IP nvarchar(50), @DeptName nvarchar(100) , @Summary nvarchar(2000), @ArticleNames nvarchar (2000) AS UPDATE gdlmo_Article SET [CategoryID] = @CategoryID, [Title] = @Title, [CreatedDate] = @CreatedDate, [CreatedByUser] = @CreatedByUser, [CopyFrom] = @CopyFrom, [Author] = @Author, [Hits] = @Hits, [IsPassed] = @IsPassed, [IP] = @IP, [DeptName] = @DeptName, [Summary] = @Summary WHERE [ArticleID] = @ArticleId BEGIN DECLARE @strSql varchar(1000) SET @strsql = 'DELETE FROM gdlmo_article_accesory WHERE ArticleId = ' cast(@ArticleId as varchar) ' ' SET @strsql = @strsql 'insert into gdlmo_article_accesory(articleid,articlename) ' SET @strsql = @strsql 'select ' cast(@ArticleId as varchar) ',* from dbo.f_splitstr(''' @ArticleNames ''','';'')' EXEC (@strsql) END |
结束 | 结束 Sql 操作: 01.00.00.SqlDataProvider 文件 |