|
excel+vba insert to ms sql - кодировка русских букв
#39354637
Ссылка:
Ссылка на сообщение:
Ссылка с названием темы:
Ссылка на профиль пользователя:
|
Участник
Откуда: Запорожье
Сообщения: 56 486
|
|
Shocker.Pro,
N' вставляли для инсерта в студии
Когда в экселе убрали, ничего не поменялось
Коллейты вручную не писал, ибо некопенгаген в субже
скрипт 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.
USE [Assets]
GO
/****** Object: Table [dbo].[scsm_access_groups] Script Date: 11/25/2016 2:03:42 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[scsm_access_groups](
[group_id] [int] IDENTITY(1,1) NOT NULL,
[access_group] [varchar](200) NOT NULL,
[company_id] [int] NOT NULL,
[description] [nvarchar](200) NULL,
[GlobalInfSecurity] [int] NOT NULL,
[LocalInfSecurity] [int] NOT NULL,
[it_service] [varchar](200) NULL,
[created_user] [varchar](200) NULL,
[created_date] [date] NULL,
[change_user] [varchar](200) NULL,
[change_date] [date] NULL,
[date_from] [date] NULL,
[date_to] [date] NULL,
CONSTRAINT [pk_access_groups] UNIQUE NONCLUSTERED
(
[group_id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY],
CONSTRAINT [uk_access_groups] UNIQUE NONCLUSTERED
(
[access_group] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
ALTER TABLE [dbo].[scsm_access_groups] WITH CHECK ADD CONSTRAINT [fk_scsm_access_groups_company] FOREIGN KEY([company_id])
REFERENCES [dbo].[scsm_company] ([company_id])
ON DELETE CASCADE
GO
ALTER TABLE [dbo].[scsm_access_groups] CHECK CONSTRAINT [fk_scsm_access_groups_company]
GO
ALTER TABLE [dbo].[scsm_access_groups] WITH CHECK ADD CHECK (([GlobalInfSecurity]=(1) OR [GlobalInfSecurity]=(0)))
GO
ALTER TABLE [dbo].[scsm_access_groups] WITH CHECK ADD CHECK (([LocalInfSecurity]=(1) OR [LocalInfSecurity]=(0)))
GO
|
|
|
