Гость
Войти | Профиль | Очистить
Целевая тема:
Создать новую тему:
Автор:
Действия ...
Форумы / ADO.NET, LINQ, Entity Framework, NHibernate, DAL, ORM [игнор отключен] [закрыт для гостей] / Не работает SQL скрипт... / 4 сообщений из 4, страница 1 из 1
13.03.2007, 03:59
    #34385806
Super_p
Super_p
Участник
Скрыть профиль Поместить в игнор-лист Сообщения автора в теме
Не работает SQL скрипт...
Есть скрипт создания БД:

Код: plaintext
1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
11.
12.
13.
14.
15.
16.
17.
18.
19.
20.
21.
22.
23.
24.
25.
26.
27.
28.
29.
30.
31.
32.
33.
34.
35.
36.
37.
38.
39.
40.
41.
42.
43.
44.
45.
46.
47.
48.
49.
50.
51.
52.
53.
54.
55.
56.
57.
58.
59.
60.
61.
62.
63.
USE [LifeManager]
GO
/****** Object:  Table [dbo].[Clients]    Script Date: 03/12/2007 16:35:39 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[Clients](
	[ID] [int] IDENTITY( 1 , 1 ) NOT NULL,
	[Name] [varchar](max) COLLATE Cyrillic_General_CI_AS NULL,
	[Email] [varchar](max) COLLATE Cyrillic_General_CI_AS NULL,
	[Speciality] [varchar](max) COLLATE Cyrillic_General_CI_AS NULL,
	[Kurs] [int] NULL,
	[UniversityID] [int] NOT NULL,
 CONSTRAINT [PK_Clients] PRIMARY KEY CLUSTERED 
(
	[ID] ASC
)WITH (PAD_INDEX  = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[ClientsPhons]    Script Date: 03/12/2007 16:35:39 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[ClientsPhons](
	[ID] [int] IDENTITY( 1 , 1 ) NOT NULL,
	[Phone] [nvarchar](max) COLLATE Cyrillic_General_CI_AS NULL,
	[ClientID] [int] NOT NULL,
 CONSTRAINT [PK_ClientsPhons] PRIMARY KEY CLUSTERED 
(
	[ID] ASC
)WITH (PAD_INDEX  = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]

...

GO
SET ANSI_PADDING OFF
GO
ALTER TABLE [dbo].[Clients]  WITH CHECK ADD  CONSTRAINT [FK_Clients_University] FOREIGN KEY([UniversityID])
REFERENCES [dbo].[University] ([ID])
ON UPDATE CASCADE
ON DELETE CASCADE
GO
ALTER TABLE [dbo].[Clients] CHECK CONSTRAINT [FK_Clients_University]
GO
ALTER TABLE [dbo].[ClientsPhons]  WITH CHECK ADD  CONSTRAINT [FK_ClientsPhons_Clients] FOREIGN KEY([ClientID])
REFERENCES [dbo].[Clients] ([ID])
ON UPDATE CASCADE
ON DELETE CASCADE
GO
ALTER TABLE [dbo].[ClientsPhons] CHECK CONSTRAINT [FK_ClientsPhons_Clients]
GO
ALTER TABLE [dbo].[GroupActions]  WITH CHECK ADD  CONSTRAINT [FK_GroupActions_UserGroups] FOREIGN KEY([UserGroupID])
REFERENCES [dbo].[UserGroups] ([ID])
ON UPDATE CASCADE
ON DELETE CASCADE
...

при создании SqlCommand, а потом ExecuteNonQuery() пишет такое:

"Incorrect syntax near 'GO'.\r\nIncorrect syntax near 'GO'.\r\nIncorrect syntax near 'GO'.\r\nIncorrect syntax near 'GO'.\r\nIncorrect syntax near the keyword 'SET'.\r\nIncorrect syntax near 'GO'.\r\nIncorrect syntax near 'GO'.\r\nIncorrect syntax near 'GO'.\r\nIncorrect syntax near the keyword 'SET'.\r\nIncorrect syntax near 'GO'.\r\nIncorrect syntax near 'GO'.\r\nIncorrect syntax near 'GO'.\r\nIncorrect syntax near the keyword 'SET'.\r\nIncorrect syntax near 'GO'.\r\nIncorrect syntax near 'GO'.\r\nIncorrect syntax near 'GO'.\r\nIncorrect syntax near the keyword 'SET'.\r\nIncorrect syntax near 'GO'.\r\nIncorrect syntax near 'GO'.\r\nIncorrect syntax near 'GO'.\r\nIncorrect syntax near the keyword 'SET'.\r\nIncorrect syntax near 'GO'.\r\nIncorrect syntax near 'GO'.\r\nIncorrect syntax near 'GO'.\r\nIncorrect syntax near the keyword 'SET'.\r\nIncorrect syntax near 'GO'.\r\nIncorrect syntax near 'GO'.\r\nIncorrect syntax near 'GO'.\r\nIncorrect syntax near the keyword 'SET'.\r\nIncorrect syntax near 'GO'.\r\nIncorrect syntax near 'GO'.\r\nIncorrect syntax near 'GO'.\r\nIncorrect syntax near the keyword 'SET'.\r\nIncorrect syntax near 'GO'.\r\nIncorrect syntax near 'GO'.\r\nIncorrect syntax near the keyword 'SET'.\r\nIncorrect syntax near 'GO'.\r\nIncorrect syntax near 'GO'.\r\nIncorrect syntax near 'GO'.\r\nIncorrect syntax near the keyword 'SET'.\r\nIncorrect syntax near 'GO'.\r\nIncorrect syntax near 'GO'.\r\nIncorrect syntax near 'GO'.\r\nIncorrect syntax near the keyword 'SET'.\r\nIncorrect syntax near 'GO'.\r\nIncorrect syntax near 'GO'.\r\nIncorrect syntax near the keyword 'SET'.\r\nIncorrect syntax near 'GO'.\r\nIncorrect syntax near 'GO'.\r\nIncorrect syntax near 'GO'.\r\nIncorrect syntax near the keyword 'SET'.\r\nIncorrect syntax near 'GO'.\r\nIncorrect syntax near 'GO'.\r\nIncorrect syntax near 'GO'.\r\nIncorrect syntax near 'GO'.\r\nIncorrect syntax near the keyword 'SET'.\r\nIncorrect syntax near 'GO'.\r\nIncorrect syntax near 'GO'.\r\nIncorrect syntax near 'GO'.\r\nIncorrect syntax near 'GO'.\r\nIncorrect syntax near the keyword 'SET'.\r\nIncorrect syntax near 'GO'.\r\nIncorrect syntax near 'GO'.\r\nIncorrect syntax near 'GO'.\r\nIncorrect syntax near 'GO'.\r\nIncorrect syntax near 'GO'.\r\nIncorrect syntax near 'GO'.\r\nIncorrect syntax ...
...
Рейтинг: 0 / 0
| Ответить | Цитировать | Написать  
13.03.2007, 09:41
    #34386055
buser
buser
Участник
Скрыть профиль Поместить в игнор-лист Сообщения автора в теме
Не работает SQL скрипт...
GO - нет такой инструкции.... ПАрсить через GO и запускать кусками.
авторGO is not a Transact-SQL statement; it is a command recognized by the osql and isql utilities and SQL Query Analyzer.
...
Рейтинг: 0 / 0
| Ответить | Цитировать | Написать  
13.03.2007, 10:37
    #34386256
pavel73
pavel73
Участник
Скрыть профиль Поместить в игнор-лист Сообщения автора в теме
Не работает SQL скрипт...
можно запустить sqlcmd -i scrpt.sql в вашей программе
...
Рейтинг: 0 / 0
| Ответить | Цитировать | Написать  
13.03.2007, 11:39
    #34386514
Super_p
Super_p
Участник
Скрыть профиль Поместить в игнор-лист Сообщения автора в теме
Не работает SQL скрипт...
проблема решена!
osql -S "localhost\sqlexpress" -E -i "patch.sql"
...
Рейтинг: 0 / 0
| Ответить | Цитировать | Написать  
Форумы / ADO.NET, LINQ, Entity Framework, NHibernate, DAL, ORM [игнор отключен] [закрыт для гостей] / Не работает SQL скрипт... / 4 сообщений из 4, страница 1 из 1
Найденые пользователи ...
Разблокировать пользователей ...
Читали тему (0):
Читали форум (0):
Пользователи онлайн (0):
Польз. соглашение  
Полит. конфиден.  
созд. / загр.: 381ms
Закрыть
start [/forum/topic.php?fid=17&mobile=1&tid=1352909]:
 0ms
get settings:
 7ms
get forum list:
 13ms
check forum access:
 3ms
check topic access:
 3ms
track hit:
 71ms
get topic data:
 11ms
get forum data:
 2ms
get page messages:
 44ms
get tp. blocked users:
 1ms
others: 226ms
total:  381ms
x
x
Закрыть


Просмотр
0 / 0
Close
Debug Console [Select Text]