PDA

View Full Version : سوال: مشکل در اجرای فایل سکریپت



arman_Delta2002
شنبه 16 دی 1391, 19:02 عصر
سلام بچها
من میخواستم یک فایل سکریپت اس کیو ال رو در برنامم اجرا کنم از روش های معمول استفاده کردم ولی نشد خطا داد!!
در صورتی که همون فایل در خود اس کو ال سرور هیچ خطایی نمیده و درست اجرا میشه
تو برنامه به کد Go موجود در فایل اسکریپت گیر میده اینم فایل اسکریپت
97921

IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[D_Acc_Naghdinegi]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[D_Acc_Naghdinegi](
[ID] [bigint] NOT NULL IDENTITY (1, 1) PRIMARY KEY,
[L_D_Acc_DaftarMali] [bigint] NULL ,
[Name1] [nvarchar](255) NULL ,
[Bedehkar] [nvarchar](255) NULL ,
[Bestankar] [nvarchar](255) NULL ,
[Roz1] [nvarchar](255) NULL ,
[Mah1] [nvarchar](255) NULL ,
[Sal1] [nvarchar](255) NULL ,
[Tozihat] [nvarchar](255) NULL ,
[DateAdd] [nvarchar](25) NULL ,
[Select1] [bit] NULL );
END
Else
BEGIN
if Exists(select * from sys.columns where Name = N'L_D_Acc_DaftarMali' and Object_ID = Object_ID(N'D_Acc_Naghdinegi'))
BEGIN
alter table D_Acc_Naghdinegi ALTER COLUMN [L_D_Acc_DaftarMali] [bigint] NULL ;
END
Else
BEGIN
alter table D_Acc_Naghdinegi ADD [L_D_Acc_DaftarMali] [bigint] NULL ;
END
if Exists(select * from sys.columns where Name = N'Name1' and Object_ID = Object_ID(N'D_Acc_Naghdinegi'))
BEGIN
alter table D_Acc_Naghdinegi ALTER COLUMN [Name1] [nvarchar](255) NULL ;
END
Else
BEGIN
alter table D_Acc_Naghdinegi ADD [Name1] [nvarchar](255) NULL ;
END
if Exists(select * from sys.columns where Name = N'Bedehkar' and Object_ID = Object_ID(N'D_Acc_Naghdinegi'))
BEGIN
alter table D_Acc_Naghdinegi ALTER COLUMN [Bedehkar] [nvarchar](255) NULL ;
END
Else
BEGIN
alter table D_Acc_Naghdinegi ADD [Bedehkar] [nvarchar](255) NULL ;
END
if Exists(select * from sys.columns where Name = N'Bestankar' and Object_ID = Object_ID(N'D_Acc_Naghdinegi'))
BEGIN
alter table D_Acc_Naghdinegi ALTER COLUMN [Bestankar] [nvarchar](255) NULL ;
END
Else
BEGIN
alter table D_Acc_Naghdinegi ADD [Bestankar] [nvarchar](255) NULL ;
END
if Exists(select * from sys.columns where Name = N'Roz1' and Object_ID = Object_ID(N'D_Acc_Naghdinegi'))
BEGIN
alter table D_Acc_Naghdinegi ALTER COLUMN [Roz1] [nvarchar](255) NULL ;
END
Else
BEGIN
alter table D_Acc_Naghdinegi ADD [Roz1] [nvarchar](255) NULL ;
END
if Exists(select * from sys.columns where Name = N'Mah1' and Object_ID = Object_ID(N'D_Acc_Naghdinegi'))
BEGIN
alter table D_Acc_Naghdinegi ALTER COLUMN [Mah1] [nvarchar](255) NULL ;
END
Else
BEGIN
alter table D_Acc_Naghdinegi ADD [Mah1] [nvarchar](255) NULL ;
END
if Exists(select * from sys.columns where Name = N'Sal1' and Object_ID = Object_ID(N'D_Acc_Naghdinegi'))
BEGIN
alter table D_Acc_Naghdinegi ALTER COLUMN [Sal1] [nvarchar](255) NULL ;
END
Else
BEGIN
alter table D_Acc_Naghdinegi ADD [Sal1] [nvarchar](255) NULL ;
END
if Exists(select * from sys.columns where Name = N'Tozihat' and Object_ID = Object_ID(N'D_Acc_Naghdinegi'))
BEGIN
alter table D_Acc_Naghdinegi ALTER COLUMN [Tozihat] [nvarchar](255) NULL ;
END
Else
BEGIN
alter table D_Acc_Naghdinegi ADD [Tozihat] [nvarchar](255) NULL ;
END
if Exists(select * from sys.columns where Name = N'DateAdd' and Object_ID = Object_ID(N'D_Acc_Naghdinegi'))
BEGIN
alter table D_Acc_Naghdinegi ALTER COLUMN [DateAdd] [nvarchar](25) NULL ;
END
Else
BEGIN
alter table D_Acc_Naghdinegi ADD [DateAdd] [nvarchar](25) NULL ;
END
if Exists(select * from sys.columns where Name = N'Select1' and Object_ID = Object_ID(N'D_Acc_Naghdinegi'))
BEGIN
alter table D_Acc_Naghdinegi ALTER COLUMN [Select1] [bit] NULL ;
END
Else
BEGIN
alter table D_Acc_Naghdinegi ADD [Select1] [bit] NULL ;
END
END

کد اسکریپت درسته والی نمیشه با کمند اکسیکوت کرد!!!