 |
| |
easy Install on Visual studio 2008 Restore database.sql แล้ว error Incorrect syntax near 'GO' |
| |
 |
|
|
 |
 |
|
เมื่อทำการเรียกไฟล์ Script SQL แล้วเป็นดังถาพครับ
Code ที่ใช้เรียกไฟล์
Code (C#)
StreamReader strReadSQLScript = new StreamReader(Application.StartupPath + "\\SQL Script\\Restore database.sql", Encoding.Default);
string strSql = strReadSQLScript.ReadToEnd();
strReadSQLScript.Close();
strSql = strSql.Replace("$DbName$", devCbxDatabaseName.Text)
.Replace("$FileRestorePath$", strPathDatabaseFile)
.Replace("$DbFileDataPhysicalName$", InstallDatabaseDAL.DbFileDataPhysicalName)
.Replace("$LogFileDataPhysicalName$", InstallDatabaseDAL.LogFileDataPhysicalName)
.Replace("$DbLogicalLog$", DbLogicalLog)
.Replace("$DbLogicalData$", DbLogicalData);
/*Restore Database*/
new InstallDatabaseDAL().ExecuteSQLCommand(GetConnectionString(), strSql);
Tag : .NET, Ms SQL Server 2005, Excel (Excel.Application), Win (Windows App), C#
|
|
|
 |
 |
 |
 |
| Date :
2011-09-15 12:00:14 |
By :
adunafah |
View :
1334 |
Reply :
7 |
|
 |
 |
 |
 |
|
|
|
|
 |
 |
|
 |
 |
| |
|
|
|
| |
|
|
| |
|
|
| |
| Date :
2011-09-15 22:30:47 |
By :
adunafah |
|
|
| |
|
|
|
|
|
| |
|
|
|
| |
|
|
|
| |
|
เอาไฟล์ Restore database.sql มาให้ดูหน่อยครับ
|
| |
|
|
| |
| Date :
2011-09-16 06:23:49 |
By :
webmaster |
|
|
| |
|
|
|
|
|
| |
|
|
|
| |
|
|
|
| |
|
Restore database.sql Generate มาจาก SQL SERVER 2005 ครับ เวลาเอามารันในโปรแกรมผ่านครับ ไม่มีปัญหาอะไรครับ แต่เวลารันโดยใช้ code ข้างบนเรียก แล้ว error ครับ
Code (C#)
USE [dbEmail_New]
GO
/****** Object: UserDefinedDataType [dbo].[IDString] Script Date: 09/09/2011 10:20:07 ******/
CREATE TYPE [dbo].[IDString] FROM [varchar](36) NULL
GO
/****** Object: UserDefinedDataType [dbo].[ImageFile] Script Date: 09/09/2011 10:20:07 ******/
CREATE TYPE [dbo].[ImageFile] FROM [image] NULL
GO
/****** Object: UserDefinedDataType [dbo].[ListNo] Script Date: 09/09/2011 10:20:07 ******/
CREATE TYPE [dbo].[ListNo] FROM [decimal](10, 6) NOT NULL
GO
/****** Object: UserDefinedDataType [dbo].[LongAscii] Script Date: 09/09/2011 10:20:07 ******/
CREATE TYPE [dbo].[LongAscii] FROM [varchar](255) NULL
GO
/****** Object: UserDefinedDataType [dbo].[LongFloat] Script Date: 09/09/2011 10:20:07 ******/
CREATE TYPE [dbo].[LongFloat] FROM [decimal](28, 6) NULL
GO
/****** Object: UserDefinedDataType [dbo].[LongNumber] Script Date: 09/09/2011 10:20:07 ******/
CREATE TYPE [dbo].[LongNumber] FROM [int] NULL
GO
/****** Object: UserDefinedDataType [dbo].[LongString] Script Date: 09/09/2011 10:20:07 ******/
CREATE TYPE [dbo].[LongString] FROM [nvarchar](255) NULL
GO
/****** Object: UserDefinedDataType [dbo].[MediumFloat] Script Date: 09/09/2011 10:20:07 ******/
CREATE TYPE [dbo].[MediumFloat] FROM [decimal](16, 6) NULL
GO
/****** Object: UserDefinedDataType [dbo].[MediumString] Script Date: 09/09/2011 10:20:07 ******/
CREATE TYPE [dbo].[MediumString] FROM [nvarchar](100) NULL
GO
/****** Object: UserDefinedDataType [dbo].[SQLString] Script Date: 09/09/2011 10:20:07 ******/
CREATE TYPE [dbo].[SQLString] FROM [varchar](1500) NULL
GO
/****** Object: UserDefinedDataType [dbo].[ShortFloat] Script Date: 09/09/2011 10:20:07 ******/
CREATE TYPE [dbo].[ShortFloat] FROM [decimal](10, 4) NULL
GO
/****** Object: UserDefinedDataType [dbo].[ShortNumber] Script Date: 09/09/2011 10:20:07 ******/
CREATE TYPE [dbo].[ShortNumber] FROM [tinyint] NULL
GO
/****** Object: UserDefinedDataType [dbo].[ShortString] Script Date: 09/09/2011 10:20:07 ******/
CREATE TYPE [dbo].[ShortString] FROM [nvarchar](50) NULL
GO
/****** Object: UserDefinedDataType [dbo].[VeryLongString] Script Date: 09/09/2011 10:20:07 ******/
CREATE TYPE [dbo].[VeryLongString] FROM [nvarchar](500) NULL
GO
/****** Object: UserDefinedDataType [dbo].[VeryLongString2] Script Date: 09/09/2011 10:20:07 ******/
CREATE TYPE [dbo].[VeryLongString2] FROM [nvarchar](4000) NULL
GO
/****** Object: UserDefinedDataType [dbo].[VeryShortString] Script Date: 09/09/2011 10:20:07 ******/
CREATE TYPE [dbo].[VeryShortString] FROM [nvarchar](25) NULL
GO
/****** Object: StoredProcedure [dbo].[up_ExportDupli_MailingList_Sel] Script Date: 09/09/2011 10:20:07 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROCEDURE [dbo].[up_ExportDupli_MailingList_Sel]
(
@WhereCause nvarchar(2000)
)
AS
BEGIN
DECLARE @SqlString nvarchar(2000)
SET @SqlString =
'select count(EmailAddress),EmailAddress
from MailingListDetail '+ @WhereCause+'
group by EmailAddress
having count(EmailAddress)> 1'
EXEC (@SqlString)
END
GO
/****** Object: StoredProcedure [dbo].[up_SendEmail_Sel_All] Script Date: 09/09/2011 10:20:08 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROCEDURE [dbo].[up_SendEmail_Sel_All]
(
@WhereCause nvarchar(2000)
)
AS
BEGIN
DECLARE @SqlString nvarchar(4000)
Set @SqlString ='SELECT * FROM SendEmail SE
WHERE SE.IsDeleted = 0
'+@WhereCause
EXEC (@SqlString)
END
ยังไม่หมดนะครับมันยาวมาก
|
ประวัติการแก้ไข
2011-09-19 14:36:38
| |
|
|
| |
| Date :
2011-09-19 14:35:46 |
By :
adunafah |
|
|
| |
|
|
|
|
|
| |
|
|
|
| |
|
|
|
| |
|
ยังไม่ได้เลยครับ
|
| |
|
|
| |
| Date :
2011-09-20 09:15:34 |
By :
adunafah |
|
|
| |
|
|
|
|
|
| |
|
|
|
| |
|
|
|
| |
|
ผมไปลองแล้วครับ แต่เจอปัญหาใหม่ ดังรูปครับ ไม่รู้แก้ไง?
ก่อนหน้านี้ยังใช่งานได้ปกติดีครับ
|
ประวัติการแก้ไข
2011-09-22 09:54:06
| |
|
|
| |
| Date :
2011-09-22 09:53:16 |
By :
adunafah |
|
|
| |
|
|
|
|
|
| |
|
|
|
| |
|
|
|
| |
|
Error นี้น่าจะติดเรื่องสิทธ์ครับ ลองดูใน Event Viewer ก็ได้ครับ
|
| |
|
|
| |
| Date :
2011-09-22 22:57:49 |
By :
webmaster |
|
|
| |
|
|
|
|
|
| |
|
|
|
|
|
