Epigraphแ
"แแ แแแแแแแขแแแแแถแแแแฝแแแ แแแแปแแแแแแแแขแแแ แขแแแธแแแ แแปแแแทแแขแแแแแพแแแ แแผแ แแถแแแแ แ"แ
แแถแแแแแแฝแ แแถแ แถแแแแธแแผแ
แแถ - แแถแแแธแแแแแแปแแแแแปแ แแแแแแแแแแแพแแแปแแแทแแแแแแถแแแแแแถแแทแแถแแแ แ
แ
แ แแแถแแแถแแแแแแแแผแแแแแแถแแถแแถแแแแแฝแแแถแแแแแแถแแแแปแแแแแปแแ
แแแถแแแแแแ
แแแแแ แแทแแแทแแแธแแแแถ แแทแแแแแถแ
- แ แแแปแขแแแธแแถแแแถแขแแแแแทแแแถแแแ FIAS แแทแแแแแถแแธแแแแกแถแแแแแแแแแแปแ! - แแถแแแทแแถแแแถแขแถแแแแถแแแ โแแแแแถแแแแขแแแแแถแแขแถแแธแแแแแแแแแแแพแแแทแแ
แผแแ
แทแแแแแแแพแแแถแแแแแถแแแถแแแแแถแแแ แขแแแแแแแแแแถแแผแ แแฝแแแแแทแแถแแแถแแแแปแแแแแปแ แแแแปแแแแถแแแธแแแแแแแฟแแแแ แ แพแแขแแแแแแแแแแแแพแแแถแแแแแปแแแถแแแแแแธแแฝแแแแแแแ
แแฝแแแแแ แแผแ
แแถแแธแแแแถแแแ
แ แพแแ
แแพแแแธแแแ แขแแแธแแแแแแแแถแแแแแ
แถแแแถแ
แแแแแผแแแแแพแกแพแแแทแแแถแแแแธแแผแแแถแแแถแแแแแ แพแ แแผแ
แแแแแแแแถ แแแแแพแแแผแแแแแถแแแแแแถแแแแแแฝแแขแแแ แแทแแแถแแถแแถแแแผแแแถแแแแแแแแถแแแถแแแแแแแแ FIAS แ แแแแแแแแถแแแผแ
แแแแทแแถแแขแแแ
แนแ แแปแแแแแขแแแแผแ!
แแ แแธแแแแแแแปแแแแแผแแแแแทแแถแแแถแแแแปแแแถแแแแแถแแแแแแแแแแถแแแ แแนแแแถแแแแแแแแแแแแทแแธ, แแแแแถแแแแ แแแแปแแแถ DBA แแถแแถแแ แแแแแธแแถ, แแแแปแแแ แแทแ, แแถแแแแแปแแขแถแแแแแแแแแแแแแแถแแแแแแถแแแแแ แแแถแแปแแแแแถแแแแแแถแแถแแแทแ แแ แแแแ DBA, nest pa?
โแแโฆ แแพแแแนแแแแแพแแถแฅแกแผแแแแโ แแแแปแแแถแแแแแถแแแขแถแแแแถแแ แ แพแแแแแแถแแแแ
แแถแแแแแ แแแแแ FIAS แแแแแพแแแแขแถแแแแแแแแแปแแกแพแแ
"แขแแแธ! แแถแ แแถแ dbf!โ - แแแแปแแแทแแแถ แแแแแปแแแแแแแแแแแปแแแแแแถแแแธแแแถแ แแแแปแแแแแแแแถแแแแแถแแแแถแแแแแขแพแแ
แแแแแขแแแแแแถแแแแฏแแแถแ zip แแแแแแแถแ "de facto" แ แพแแแแแปแแแ
แแทแ แแแแแแถแแแแแ arj แแแแแถแแแแแถแแแแถแแแแธแแผแแแถแแแถแแแแแ แพแแแ
แแแแปแ Bose แ แพแแแถแแแปแแแแแแแแแถแแแแแแแทแแแแท แแพแแ
แแ แแ , 7zip [แแแปแแแแแแแแแ
แแแแทแแขแถแ
แแแแแฝแแแถแแแแแแแแพ powershell แแแแแธแ -Archive] แ แแถแแแแแแ แแปแแแ powershell'om แแถโแขแแแโแแนแโแแทแโแแถแโแแโแ แพแโแขแแแโแแนแโแแทแโแแแแถแโแแแแ
แแโแ แแพแโแแนแโแแแแผแโแแถแแโแแ
โแแพโแแแถแแแธแโแแแแแพโแแแแแโแแแแแแโแแโแแถแโแขแแแแปแแ แแแถแโแแถโแแโแแแแ
แแแแปแแแถแแแแแแแแแแ แแแงแแแแแแแแแแถแแแแถแแแแแปแแฏแแแถแ dbf แแแแแแแแถแแถแ แแแพแแแแแถแแแแ แพแ แแผแ แแแแแแถแแทแแแถแแแแแ แถแขแแแธแแแ
แแแแปแแแถแแแแแถแแแแแ แแ dbfs แแพแแแแแพแแแถแแแแแแแทแแธแแถแแแ แ แพแแแแแแแแแแแแทแแแแแแแแแแปแแแแแผแแแถแแแแแปแ แแแแปแแแถแแแผแแแผแแแแแแแธแแแแแแแแถแแแ แถแ "แแแแพแแแแแผแ แแแแถ" แแถแ แแแแแกแแแแ แแถแแฝแ แแแแแ แแถแแแแแถแแแแแแแแแแแแฝแแแแ
แแแแปแแแถแแแแแ แแแแทแแแแแแ แ แพแแแแแปแแ แแแแ แแถแแทแแถแแแแแแแแแแแแแแพแแแแธแขแแแแฝแ t.s. laurels แแแปแแแแแขแถแแแแแแถแแแถแแแแแปแแแ แแพแแแแแแแแแแแถแแแถแแ แผแ!
- แขแผแ WTF!!!???
แแปแแแแแแแปแแแถแแแแแแถ แ แพแแแปแแผแ
แแแถแแแแ แปแแ
แ แพแแแแแปแแแถแแแถแแแแแแ แแทแแแแแแ แแถแแแแถแแแแธแแฟแแแถแแแขแแแแแ แแแแแแแปแแแถแแแถแแแแแฝแแแแแปแแแแแแถแแแแแถแ แถแ แ แพแแแแฝแแแแแถแแแแแแถแแแแ แแทแแแถแแแทแ แแ แแแแถแแแแแแแแแแปแแ แแแแปแแแทแแแถแแทแแ แแแแแแแแแแแแถแแฝแ dbfs แแแแแผแ แแแแแแ
แแแแปแแแถแแแแแแถแแแแแแแแแแแแธแแแแแ แแ แผแแแแแแถแแแแแปแแขแแ แ แพแแขแถแแแแถแแแแแแถแแ แถแแแแแแแแแแแแแแ แแถแแฝแแแนแแแแแฝแแแถแแแแถแแแแแแถ โแแพแแพแแแแแปแแแแแพแขแแแธ?โแ
แ แพแแแแแแถแแแแแถแแขแแแธแแแแผแแแแแพแ แ แพแแแแแปแแแ
แแแแทแแ
แแแแแแแแแแแแถแแฝแ dbf แแแแปแแแถแแแแแแแ
แ
แทแแแแแแแปแ FIAS แแธ xml แแถแแทแแแ แแแแแถแแแผแ
แแแแแฝแแแแแทแแถแแแถ แแถแแถแแแแแแ แแถแแแแแแ แแปแแแแ แ แพแ "dbf แแบแแถแแแแแแแแแแแแแถแแแ โแ
แขแแแธแแฟแแแแ แแแแปแแแผแแแแแ
แแแแถแแแแแแแแแแแถแแแแแขแผแแแแแแถแ แ แพแแ
แปแแแ
แแแแแธแ
แแแแแแธแขแ
แแถแ แแถโแแโแขแถแ โแแ โแแฝแ โแแแแ ๐
แแผแ
แแแแแแถแแแแผแแแถแแแแแแแ
แ
แทแแแแแพแแแแธแแแแปแแแแแแแแพ
แแพแแแแธแแแแพแแถแขแแแแแแแผแแแถแ
แแแแแแถแแแถแแแแแแแแแปแแแแแธ FIAS "แแ แแถแแแแแแแแ" แแทแแแถแแแแแแผแแแถแแแถแแทแแแแแแ แแแแแถแแแ แฏแแแถแแแทแแแถแแขแแแธแแแแแทแแแแแแถ xml ... แแถแแถแแแทแ xml แแแปแแแแแแถแแแทแ แแฝแแแถแแถแแถแแถแแแถแแแแแพแแแแแถแแแทแแแแแแ แแแแปแแฏแแแถแแแธแแฝแแแแถแแแถแแถแแแฝแแ
แแ
แแพแแแ แแแแแ sql.ru I
แแแแแบแแถแแแแแแแแแถแแแแแแแแแแแแทแ แแแแแฝแ แแแแแแถแ
spXMLBulkLoad
USE [FIAS2]
GO
/****** Object: StoredProcedure [dbo].[spXMLBulkLoad] Script Date: 13.05.2019 18:05:58 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- ะะตะพะฑั
ะพะดะธะผะพ ัะฐะทัะตัะธัั Ole Automation Procedures:
-- EXEC sp_configure 'Ole Automation Procedures', 1; RECONFIGURE WITH OVERRIDE;
-- ะัะธะผะตั:
-- EXEC dbo.spXMLBulkLoad 'Z:PathData.xml','Z:PathSchema.xsd', 'FIAS', 'Z:Patherror.xml'
CREATE PROCEDURE [dbo].[spXMLBulkLoad] (
@File SysName
,@Schema SysName
,@DataBase SysName = '<DefaultDataBase>'
,@ErrorLog SysName
) AS
BEGIN
DECLARE @ErrCode Int
,@OLEXMLBulk Int
,@ErrMethod SysName
,@ErrDescript NVarChar(4000)
EXEC @ErrCode = sys.sp_OACreate 'SQLXMLBulkLoad.SQLXMLBulkload', @OLEXMLBulk OUT
IF (@ErrCode = 0)
BEGIN
SET @DataBase = 'Provider=SQLOLEDB;Data Source=.;DataBase=' + @DataBase + ';Integrated Security=SSPI'
EXEC @ErrCode = sys.sp_OASetProperty @OLEXMLBulk ,'ConnectionString', @DataBase
IF (@ErrCode <> 0)
BEGIN SET @ErrMethod = 'ConnectionString'
GOTO Error
END
EXEC @ErrCode = sys.sp_OASetProperty @OLEXMLBulk ,'ErrorLogFile', @ErrorLog
IF (@ErrCode <> 0)
BEGIN SET @ErrMethod = 'ErrorLogFile'
GOTO Error
END
EXEC @ErrCode = sys.sp_OASetProperty @OLEXMLBulk, 'CheckConstraints', 1
IF (@ErrCode <> 0)
BEGIN SET @ErrMethod = 'CheckConstraints'
GOTO Error
END
--EXEC @ErrCode = sys.sp_OASetProperty @OLEXMLBulk, 'ForceTableLock', 1
-- IF (@ErrCode <> 0)
-- BEGIN SET @ErrMethod = 'ForceTableLock'
-- GOTO Error
-- END
EXEC @ErrCode = sys.sp_OAMethod @OLEXMLBulk, 'Execute', NULL, @Schema, @File
IF (@ErrCode <> 0)
BEGIN
SET @ErrMethod = 'Execute'
DECLARE @Exist Int
,@Error XML
,@SQL NvarChar(max)
EXEC master.dbo.xp_FileExist @ErrorLog, @Exist OUT
IF (@Exist = 1)
BEGIN
-- ะะท @ErrorLog ัะฐะนะปะฐ
Set @SQL = N'SELECT @Error = E.Error + CASE WHEN Right(E.Error,1) <> ''>'' THEN ''lt>'' ELSE '''' END '
+ N'FROM OPENROWSET(BULK '''+ @ErrorLog +''', SINGLE_NCLOB) E(Error)'
exec sp_executesql @SQL, N'@Error xml OUTPUT', @Error=@Error OUTPUT
SELECT @ErrDescript = IsNull(@ErrDescript,'') + E.Error.value('Description[1]','SysName') + ' '
FROM @Error.nodes('/Result/Error')E(Error)
SELECT @ErrDescript = IsNull(@ErrDescript,'') + E.Error.value('Description[1]','SysName') + ' '
FROM @Error.nodes('/Error/Record')E(Error)
END
ELSE
GOTO Error
END
GOTO Destroy
Error:
EXEC @ErrCode = sys.sp_OAGetErrorInfo @OLEXMLBulk, @ErrorLog OUT, @ErrDescript OUT
Destroy:
EXEC @ErrCode = sys.sp_OADestroy @OLEXMLBulk
END
ELSE
SELECT
@ErrMethod = 'SQLXMLBulkLoad.SQLXMLBulkload'
,@ErrorLog = 'sp_OACreate'
,@ErrDescript = 'ะัะธะฑะบะฐ ัะพะทะดะฐะฝะธั OLE ะพะฑัะตะบัะฐ'
-- ะัะฒะพะด ะพัะธะฑะพะบ
IF (@ErrMethod IS NOT NULL)
BEGIN
RAISERROR('ะัะธะฑะบะฐ ะฟัะธ ะฒัะฟะพะปะฝะตะฝะธะธ ะผะตัะพะดะฐ "%s" ะฒ "%s": %s',18,1, @ErrMethod, @ErrorLog, @ErrDescript)
RETURN @@Error
END
END
GO
แแแแแแถแแแถแแแแแ แแพแแแแธแแแแปแ xml แ แแแพแแแแแแแแพแแแแแถแแแแแแ แแแแแแแถแแแ xsd แ แแแถแแแแแแแแแแแผแแแถแแแถแแแถแ แแแแแถแแแทแแแถแแแแผแแแถแแ แแแขแปแแแแแ แถแแแธแแแแ แแทแแแแแแแแแแแแแแผแแแแแปแแ
แแพแแกแพแแแถแแถแแแแแแแแถแแแแแแแแแ "แแแปแแแแแแถแแแแแแแแ แถแแแแแแปแแแแแ" - แแแแปแแแถแแแแแพแแแฝแ แ แพแแแ แแพแแแ แแแแแแแถแแแแทแแแแปแแแแแแแแปแแแแแทแแแพแแแแแแแแถแแแแแแแแแแฝแแฏแแแแ แ แพแแแนแแ
แแถแแแแแแแแแแแแแแถแแแแแแแแถแแแ
แแพแแแ แแแแแ FIAS แแแแแถแแแแถแแแถแแ
แผแแแทแแแแแแแแแแแแแบแแทแแแทแแถแแแแ
แแแปแแแแ ... แแแปแ - แแถแ 271 แแถแ! แแแโแแถโแ
แแแฝแโแแแปแแแแถแโแแแโแขแแแโแแแแผแโแขแแแแปแโแแทแโแแทแโแ
แแแถแแโ!
แแผแ แแแแแ แพแ แแแแปแแแถแแแแแแแ แ แทแแแแแแแแแแแแแแแแถแแแแแถแแแแแแแแแแแแแแแแแแแแแท แแแแปแแแแแแถแแฝแแแแแถแแแแแพแแแถแแถแแแแแแ แแแแปแแแผแแแแแถแแแทแแแแแแแ
SQLXMLBULKLOAD แขแถแ แแแแแพแแแถแแถแแแแแแแแแแแแแแแแแทแแแแแถแแแแทแแแแแแแแแแแถแแแแแปแแแธแแแแแแแถแแแแแแแแถแแแแแแแ แแแถแ แแแปแแแแแแแแปแแแ แแทแ แแแแแทแแแพแแแแปแแแแแแพแแแแแแแแถแแแแแแ แ แแแปแขแแแธแแถแแแถแแทแแแแแแพแแแถแแถแแแถแแแแแแแแแแแแฝแแฏแแแถแแแแแแแแปแแแแแผแแแถแ?
แแแแปแแแถแแแถแแแแแแแแแแถแแแ xsd แแธแแแ แแแแแ FIAS แ แพแแแทแแถแแแฝแแแถแแแแแพแแแพแแแปแแแแแถแแ
แแถแแแแถแแแแข แแฝแแแถแแปแแแแแแแถแแแแแแแแผแ แแแแถ แแผแ แแแแแขแแแแขแถแ แแแแแพแแแผแแแแแถแแแทแแแแแแแแแแแ แแทแแแแแแแแแแแแแแถแแแแแแแแแแฝแแฏแแแแแแถแแแแถแแแแแปแแแแแแแแถแแแแแแแแฝแแแทแแแแแปแแแแแถแแแฝแแ แแแฝแแแแปแแแแแแ
1. แแแแแพแแแผแแแแแถแแแทแแแแแแ FIAS2 แแแแ
แ แแแปแขแแแธแแถแแแถ "2"? แแถแแถแแแแแแพแแแถแแ, แแแแแถแแแ "1" แแบแแถแแผแแแแแถแแแธ dbf-ok แ แแแแ แแแแถแแพแแแนแแแทแแถแแขแแแธแแถแแ
แแแแแแแแแ
แแแแแแธแแแแแแพแ DB FIAS2
CREATE DATABASE [FIAS2]
CONTAINMENT = NONE
ON PRIMARY
( NAME = N'FIAS', FILENAME = N'E:DataFIAS1.mdf' , SIZE = 10485760KB , FILEGROWTH = 1048576KB )
LOG ON
( NAME = N'FIAS_log', FILENAME = N'E:DataFIAS1_log.ldf' , SIZE = 1048576KB , FILEGROWTH = 131072KB )
GO
ALTER DATABASE [FIAS2] SET COMPATIBILITY_LEVEL = 120
GO
ALTER DATABASE [FIAS2] SET ANSI_NULL_DEFAULT ON
GO
ALTER DATABASE [FIAS2] SET ANSI_NULLS ON
GO
ALTER DATABASE [FIAS2] SET ANSI_PADDING ON
GO
ALTER DATABASE [FIAS2] SET ANSI_WARNINGS ON
GO
ALTER DATABASE [FIAS2] SET ARITHABORT OFF
GO
ALTER DATABASE [FIAS2] SET AUTO_CLOSE OFF
GO
ALTER DATABASE [FIAS2] SET AUTO_SHRINK OFF
GO
ALTER DATABASE [FIAS2] SET AUTO_CREATE_STATISTICS ON(INCREMENTAL = OFF)
GO
ALTER DATABASE [FIAS2] SET AUTO_UPDATE_STATISTICS ON
GO
ALTER DATABASE [FIAS2] SET CURSOR_CLOSE_ON_COMMIT OFF
GO
ALTER DATABASE [FIAS2] SET CURSOR_DEFAULT GLOBAL
GO
ALTER DATABASE [FIAS2] SET CONCAT_NULL_YIELDS_NULL ON
GO
ALTER DATABASE [FIAS2] SET NUMERIC_ROUNDABORT OFF
GO
ALTER DATABASE [FIAS2] SET QUOTED_IDENTIFIER ON
GO
ALTER DATABASE [FIAS2] SET RECURSIVE_TRIGGERS OFF
GO
ALTER DATABASE [FIAS2] SET DISABLE_BROKER
GO
ALTER DATABASE [FIAS2] SET AUTO_UPDATE_STATISTICS_ASYNC OFF
GO
ALTER DATABASE [FIAS2] SET DATE_CORRELATION_OPTIMIZATION OFF
GO
ALTER DATABASE [FIAS2] SET PARAMETERIZATION SIMPLE
GO
ALTER DATABASE [FIAS2] SET READ_COMMITTED_SNAPSHOT ON
GO
ALTER DATABASE [FIAS2] SET READ_WRITE
GO
ALTER DATABASE [FIAS2] SET RECOVERY SIMPLE
GO
ALTER DATABASE [FIAS2] SET MULTI_USER
GO
ALTER DATABASE [FIAS2] SET PAGE_VERIFY CHECKSUM
GO
ALTER DATABASE [FIAS2] SET TARGET_RECOVERY_TIME = 0 SECONDS
GO
ALTER DATABASE [FIAS2] SET DELAYED_DURABILITY = DISABLED
GO
USE [FIAS2]
GO
IF NOT EXISTS (SELECT name FROM sys.filegroups WHERE is_default=1 AND name = N'PRIMARY') ALTER DATABASE [FIAS2] MODIFY FILEGROUP [PRIMARY] DEFAULT
GO
2. แ แผแแแพแแแแแแพแแ แถแแแธแแแธแแ แแแแปแแแผแแแแแถแแแทแแแแแแแแแแ
แ แถแแแธแแฝแแแนแแแถแแแแแแแแถแแแ xsd แ แพแแแธแแธแแแนแแแแแถแแแถแแแแแแแถแแแแแทแแแแแแแแแแแแฝแแแถแแแธแแแแแแแถแแแ xsd แแถแแแแแแ
แแถแแแทแแแแแแแแถแแแ xsd แแบแแถแฏแแแถแ xml แแแแแแถ แแผแ แแแแแขแแแแขแถแ แแแแพแแถแแแถแแฝแแแฝแแแถแแผแ แแนแแฏแแแถแ xml แแแแแแถแแแแ
USE [FIAS2]
go
if OBJECT_ID('dbo.[_FIAS]') is not null
drop table dbo.[_FIAS]
go
if OBJECT_ID('dbo._FIAS_SCHEMAS') is not null
drop table dbo.[_FIAS_SCHEMAS]
go
Create table dbo.[_FIAS_SCHEMAS] (x xml, [table โโ not found /]
sysname)
go
-- ะะตัะฒัะน ะทะฐะฟัะพั: ะะฐะณััะทะธะผ ัั
ะตะผั ะฒ ัะฐะฑะปะธัะบั ะฝะฐ ัะตัะฒะตัะต, ะดะปั ะดะฐะปัะฝะตะนัะธั
ะผะฐะฝะธะฟัะปััะธะน.
insert into dbo.[_FIAS_SCHEMAS] (x, [table โโ not found /]
)
SELECT x = CAST(BulkColumn AS XML).query('.'), '_ACTSTAT' [table โโ not found /]
FROM OPENROWSET(BULK 's01sq03c$filesFIASAS_ACTSTAT_2_250_08_04_01_01.xsd', SINGLE_BLOB) x
Union all
SELECT x = CAST(BulkColumn AS XML).query('.'), '_ADDROBJ' FROM OPENROWSET(BULK 's01sq03c$filesFIASAS_ADDROBJ_2_250_01_04_01_01.xsd', SINGLE_BLOB) x
Union all
SELECT x = CAST(BulkColumn AS XML).query('.'), '_CENTERST' FROM OPENROWSET(BULK 's01sq03c$filesFIASAS_CENTERST_2_250_10_04_01_01.xsd', SINGLE_BLOB) x
Union all
SELECT x = CAST(BulkColumn AS XML).query('.'), '_CURENTST' FROM OPENROWSET(BULK 's01sq03c$filesFIASAS_CURENTST_2_250_07_04_01_01.xsd', SINGLE_BLOB) x
Union all
SELECT x = CAST(BulkColumn AS XML).query('.'), '_DEL_ADDROBJ' FROM OPENROWSET(BULK 's01sq03c$filesFIASAS_DEL_ADDROBJ_2_250_15_04_01_01.xsd', SINGLE_BLOB) x
Union all
SELECT x = CAST(BulkColumn AS XML).query('.'), '_DEL_HOUSEINT' FROM OPENROWSET(BULK 's01sq03c$filesFIASAS_DEL_HOUSEINT_2_250_17_04_01_01.xsd', SINGLE_BLOB) x
Union all
SELECT x = CAST(BulkColumn AS XML).query('.'), '_DEL_HOUSE' FROM OPENROWSET(BULK 's01sq03c$filesFIASAS_DEL_HOUSE_2_250_16_04_01_01.xsd', SINGLE_BLOB) x
Union all
SELECT x = CAST(BulkColumn AS XML).query('.'), '_DEL_LANDMARK' FROM OPENROWSET(BULK 's01sq03c$filesFIASAS_DEL_LANDMARK_2_250_18_04_01_01.xsd', SINGLE_BLOB) x
Union all
SELECT x = CAST(BulkColumn AS XML).query('.'), '_DEL_NORMDOC' FROM OPENROWSET(BULK 's01sq03c$filesFIASAS_DEL_NORMDOC_2_250_19_04_01_01.xsd', SINGLE_BLOB) x
Union all
SELECT x = CAST(BulkColumn AS XML).query('.'), '_ESTSTAT' FROM OPENROWSET(BULK 's01sq03c$filesFIASAS_ESTSTAT_2_250_13_04_01_01.xsd', SINGLE_BLOB) x
Union all
SELECT x = CAST(BulkColumn AS XML).query('.'), '_FLATTYPE' FROM OPENROWSET(BULK 's01sq03c$filesFIASAS_FLATTYPE_2_250_23_04_01_01.xsd', SINGLE_BLOB) x
Union all
SELECT x = CAST(BulkColumn AS XML).query('.'), '_HOUSEINT' FROM OPENROWSET(BULK 's01sq03c$filesFIASAS_HOUSEINT_2_250_03_04_01_01.xsd', SINGLE_BLOB) x
Union all
SELECT x = CAST(BulkColumn AS XML).query('.'), '_HOUSE' FROM OPENROWSET(BULK 's01sq03c$filesFIASAS_HOUSE_2_250_02_04_01_01.xsd', SINGLE_BLOB) x
Union all
SELECT x = CAST(BulkColumn AS XML).query('.'), '_HSTSTAT' FROM OPENROWSET(BULK 's01sq03c$filesFIASAS_HSTSTAT_2_250_12_04_01_01.xsd', SINGLE_BLOB) x
Union all
SELECT x = CAST(BulkColumn AS XML).query('.'), '_INTVSTAT' FROM OPENROWSET(BULK 's01sq03c$filesFIASAS_INTVSTAT_2_250_11_04_01_01.xsd', SINGLE_BLOB) x
Union all
SELECT x = CAST(BulkColumn AS XML).query('.'), '_LANDMARK' FROM OPENROWSET(BULK 's01sq03c$filesFIASAS_LANDMARK_2_250_04_04_01_01.xsd', SINGLE_BLOB) x
Union all
SELECT x = CAST(BulkColumn AS XML).query('.'), '_NDOCTYPE' FROM OPENROWSET(BULK 's01sq03c$filesFIASAS_NDOCTYPE_2_250_20_04_01_01.xsd', SINGLE_BLOB) x
Union all
SELECT x = CAST(BulkColumn AS XML).query('.'), '_NORMDOC' FROM OPENROWSET(BULK 's01sq03c$filesFIASAS_NORMDOC_2_250_05_04_01_01.xsd', SINGLE_BLOB) x
Union all
SELECT x = CAST(BulkColumn AS XML).query('.'), '_OPERSTAT' FROM OPENROWSET(BULK 's01sq03c$filesFIASAS_OPERSTAT_2_250_09_04_01_01.xsd', SINGLE_BLOB) x
Union all
SELECT x = CAST(BulkColumn AS XML).query('.'), '_ROOMTYPE' FROM OPENROWSET(BULK 's01sq03c$filesFIASAS_ROOMTYPE_2_250_24_04_01_01.xsd', SINGLE_BLOB) x
Union all
SELECT x = CAST(BulkColumn AS XML).query('.'), '_ROOM' FROM OPENROWSET(BULK 's01sq03c$filesFIASAS_ROOM_2_250_21_04_01_01.xsd', SINGLE_BLOB) x
Union all
SELECT x = CAST(BulkColumn AS XML).query('.'), '_SOCRBASE' FROM OPENROWSET(BULK 's01sq03c$filesFIASAS_SOCRBASE_2_250_06_04_01_01.xsd', SINGLE_BLOB) x
Union all
SELECT x = CAST(BulkColumn AS XML).query('.'), '_STEAD' FROM OPENROWSET(BULK 's01sq03c$filesFIASAS_STEAD_2_250_22_04_01_01.xsd', SINGLE_BLOB) x
Union all
SELECT x = CAST(BulkColumn AS XML).query('.'), '_STRSTAT' FROM OPENROWSET(BULK 's01sq03c$filesFIASAS_STRSTAT_2_250_14_04_01_01.xsd', SINGLE_BLOB) x
-- ะัะพัะพะน ะทะฐะฟัะพั: ะ ะฐัะฟะพััะพัะธะผ ัั
ะตะผั, ะธ ัะพะทะดะฐะดะธะผ ัะฐะฑะพััั ัะฐะฑะปะธัั ั ะผะตัะฐะดะฐะฝะฝัะผะธ
;WITH XMLNAMESPACES ('http://www.w3.org/2001/XMLSchema' as xs)
Select a.[table โโ not found /]
,tbl.[root_name]
,tbl.[root_description]
,tbl.[name]
,ROW_NUMBER() over (partition by a.[table โโ not found /]
order by 1/0) N
,tbl.[column]
,tbl.[required]
,tbl.[description]
,tbl.[type]
,tbl.[len]
,Case tbl.[type]
when N'byte' then N'tinyint'
when N'date' then N'date'
when N'int' then N'int'
when N'string' then
Case when tbl.[len] = 36 and (tbl.[column] like N'%ID' or tbl.[column] = N'NORMDOC') then N'uniqueidentifier'
when tbl.[len] is Null then N'nvarchar(max)'
Else N'nvarchar(' + cast(tbl.[len] as nvarchar(4000)) + N')' END
when N'integer' then
Case when tbl.[len] > 9 then N'bigint'
when tbl.[len] <= 4 then N'smallint'
Else N'int'
end
else N'nvarchar(max)'
End [sqltype]
,t.n.query('.') [node]
into dbo.[_FIAS]
from dbo.[_FIAS_SCHEMAS] a
Cross apply a.x.nodes('//xs:attribute') t(n)
Cross apply
(values -- ะฝะตะบะพัะพััะต ะฟะพะปั ะธัะฟะพะปัะทััััั ะฝะตัะบะพะปัะบะพ ัะฐะท, ะฟะพััะพะผั ัะดะตะปะฐะตะผ ัะฐะบ :)
(
x.value('(xs:schema[1]/xs:element[1]/@name)', 'nvarchar(255)')
,x.value('(xs:schema[1]/xs:element[1]/xs:annotation/xs:documentation[1]/text())[1]', 'nvarchar(4000)')
,x.value('(xs:schema[1]/xs:element[1]/xs:complexType[1]/xs:sequence[1]/xs:element[1]/@name)', 'nvarchar(255)')
,t.n.value('(./@name)[1]', 'nvarchar(255)')
,t.n.value('(./@use)[1]', 'nvarchar(255)')
,Stuff(Coalesce(t.n.value('(./xs:simpleType/xs:restriction/@base)[1]', 'nvarchar(255)'), t.n.value('(./@type)[1]', 'nvarchar(255)')), 1, 3, '')
,Coalesce(t.n.value('(./xs:simpleType/xs:restriction/xs:length/@value)[1]', 'int')
,t.n.value('(./xs:simpleType/xs:restriction/xs:maxLength/@value)[1]', 'int')
,t.n.value('(./xs:simpleType/xs:restriction/xs:totalDigits/@value)[1]', 'int'))
,Replace(
Replace(
Replace(
Replace(
Replace(
Replace(
Replace(
Replace(
Replace(t.n.value('(./xs:annotation/xs:documentation)[1]', 'nvarchar(4000)'), ' ', ' ')
, ' ', ' ')
, ' ', ' ')
, ' ', ' ')
, ' ', ' ')
, ' ', ' ')
, ' ', ' ')
, ' ', ' ')
, ' ', ' ')
)
) tbl([root_name], [root_description], [name], [column], [required], [type], [len], [description])
-- ะะพัะผะพััะธะผ ะฝะฐ ัะตะทัะปััะฐั
Select * from dbo.[_FIAS]
แแแแแแแแพแแถแแแแแพแแปแแ
แแธแแฝแแแแแปแแแแแแแแถแแแ xsd แแ
แแแแปแแแถแแถแแแฝแแแ
แแพแแแถแแแธแแแ แแถแแแแแผแแแแแแแแแถแแแแแแแแแถแแแแแธแแฝแแแแ
แแแแปแแแถแ [แแถแแถแ "" แแแแทแแแพแ /]
- แแแแแแแถแแถแแแแแแแแปแแ
แแแแแแปแแแทแแแแแแแแธแแถแแถแแแแแแแแผแแแแแถแ
แแถแแถแแแทแแแถแแ แแถแแนแแขแถแ แแแแพแแถแแถแ แแผแ แแแแแแถแแแแแแแแแแแแแแแถแแแแแแแถแแแแแแผแ แแฝแแแถแขแถแ แแถแแแ แแถแแแแถแแ แแแแปแแแแฏแแแถแแแฝแแ แแแฝแ แ แพแแแแแแพแแแ แแถแแแแแแแแแแถแแถแแแแแแ แกแพแแแทแแแถแแแฝแแแถแแแแแ แพแแแแแแแแแแแแแแแแแแแแแแแแท แ แพแแแแแแแแ แแทแแแแแแแแแแแแแแถแแแแแแแแแแแแแแแแแแแทแ แแแปแแแแ t.To แ แแ แแถแแแแแแแแแแถแแแแแแผแแแแถแแแแแ แแถแแพแแ แปแแแแแแแแแแแถแแถแแแแแถแแแแแแผแ - แแฝแ แ แพแแแ แแแแถแ แกแฆ - แแถแแแแทแแแแแถแแแแถแแแแแแปแแแถแแแแแแพแแแแถแแแธแแแแแแแแแแแแแแทแแแแแแแ แแถแแถแแถแแแแแแพแแแแแปแแแถแแ แแแถแแแแ 16 แแทแแถแแธแแพ CTRL + C - CTRL + V แ
แแผแ แแแแ แแถแโแแแแปแโแแ โแแแแปแโแแถแแถแโแแแโแแถแโแแแแถแแแแถแโแแบโแแทแแถแโแแแแแโแแผแ แ แพแโแแแแผแโแแ โแแถแแโแฏแแแถแโแแแโแแถแโแแแแปแ แแแแโแแถแแโแแแแแโแแถแแถแโแแแแผแโแแถแโแแแแแโแแแโแแแ
แแแแฝแแแธแแธแแแถแแแแแแแถแแขแแแธแแ แแถแแแแแแแแแแถแแถแแแธแแแแแแแถแแแแ แแแแปแแแทแแแแแแแแถแแฝแ 3nf แแ แแแปแแแแแแถแแแแแพแแถแแถแแถแแถแแแแแฝแแ
แแแแแทแแธแแแ, แแแ แทแแแแแปแแแถแแแแพแแแแแแแแ (+)
แแถแแนแแแถแแ แขแแแแ แถแแแแแแพแแแแแผแแแฝแแแแแฝแแ แแพแแถแขแถแ แแ แแฝแ แแแแแแปแแแถแแแถแแแแแแแแแแแแแแแแปแแแแแถแแแฝแแ แแแฝแแแแแปแแแแแฝแ 1 แแ แ แพแแแแแแถแแแแแแแแพแแถแกแพแแแทแแแ แแแแแแแแถแ แแแพแแ แแถแโแขแแแโแขแถแ โแแแแพโแแถแแ แงแแถแ แแแแแผแ แแแแ
from dbo.[_FIAS_SCHEMAS] a
Cross apply a.x.nodes('//xs:attribute') t(n)
Cross apply
(values -- ะฝะตะบะพัะพััะต ะฟะพะปั ะธัะฟะพะปัะทััััั ะฝะตัะบะพะปัะบะพ ัะฐะท, ะฟะพััะพะผั ัะดะตะปะฐะตะผ ัะฐะบ :)
(
x.value('(xs:schema[1]/xs:element[1]/@name)', 'nvarchar(255)')
, ... ะทะดะตัั ะผะพะถะฝะพ ะฟะตัะตัะธัะปะธัั ะฒัะต ัะปะพะถะฝะพะฒััะธัะปัะตะผัะต ะฟะพะปั, ััะพะฑั ะฟะพัะพะผ ะธัะฟะพะปัะทะพะฒะฐัั ะธั
ะฒ ะปัะฑะพะน ัะฐััะธ ะทะฐะฟัะพัะฐ
)
) tbl([root_name], [root_description], [name], [column], [required], [type], [len], [description])
แแถแแถแแแทแแแถแแแแแแพแแถแแแถแแฝแแแแแแแแแแแฝแแ แแแฝแแ แแแปแแแแแแ แแแแแแแขแแแแ แถแแแแแแพแแแแแพแแถ แขแแแแแนแแแแแแถแแแแถแแแถแแแแ แแแแผแแขแแแธแแแแแฝแแแแแถแแ
3. แแแแแแแแพแแแแแแแธแแแแแแแแแพแแแถแแถแ FIAS แ แพแแแแแแถแแแแแแแแพแแแถแแแถ แ แพแแแแแแพแแแถแแถแแแแแแแแฝแแฏแแ
Declare @schema sysname = N'dbo'
Declare @sql nvarchar(max)
-- ะกะพะทะดะฐะดะธะผ ะบะพะด ะดะปั ัะพะทะดะฐะฝะธั ัะฐะฑะปะธั, ะธ ะทะฐะฟัััะธะผ ะตะณะพ
set @sql = (
Select Distinct
N';Create table '
+ Quotename(@schema)
+ N'.'
+ Quotename([table โโ not found /]
)
+ N'('
+ Stuff((Select
N','
+ QUOTENAME(b.[column])
+ N' '
+ b.[sqltype]
+ Case b.[required] when 'required' then N' NOT NULL'
when 'optional' then N' NULL'
End
From dbo.[_FIAS] b
where b.[table โโ not found /]
= a.[table โโ not found /]
Order by N ASC
For xml path(N''), type
).value(N'.', 'nvarchar(max)'), 1, 1, N'')
+ N')'
from dbo.[_FIAS] a
For xml path(N''), type).value(N'.', N'nvarchar(max)')
exec (@sql)
แแพแขแแแแแถแแแแแแแทแแแแแพแขแแแธแแแถแแแขแแแแแ - แแแแแแธแแแแแแถแแแแแแแพแแแถแแถแ แแทแแแแแแแแถแแแ FIAS แแแแแถแแแแแแแ แแแถแแแนแแแแแผแแแถแแแแแถแแแแ แ แปแแแแแ แแแแแขแแแแแแ
แแแแฝแแแพแแแแธแแแแแพแแแถแแถแแแแแแถแแแแแแแแแแแแฝแ
;
CREATE TABLE [dbo].[_ACTSTAT] (
[NAME] NVARCHAR(100) NOT NULL
,[ACTSTATID] BIGINT NOT NULL
);
CREATE TABLE [dbo].[_ADDROBJ] (
[AOGUID] UNIQUEIDENTIFIER NOT NULL
,[FORMALNAME] NVARCHAR(120) NOT NULL
,[REGIONCODE] NVARCHAR(2) NOT NULL
,[AUTOCODE] NVARCHAR(1) NOT NULL
,[AREACODE] NVARCHAR(3) NOT NULL
,[CITYCODE] NVARCHAR(3) NOT NULL
,[CTARCODE] NVARCHAR(3) NOT NULL
,[PLACECODE] NVARCHAR(3) NOT NULL
,[PLANCODE] NVARCHAR(4) NOT NULL
,[STREETCODE] NVARCHAR(4) NULL
,[EXTRCODE] NVARCHAR(4) NOT NULL
,[SEXTCODE] NVARCHAR(3) NOT NULL
,[OFFNAME] NVARCHAR(120) NULL
,[POSTALCODE] NVARCHAR(6) NULL
,[IFNSFL] NVARCHAR(4) NULL
,[TERRIFNSFL] NVARCHAR(4) NULL
,[IFNSUL] NVARCHAR(4) NULL
,[TERRIFNSUL] NVARCHAR(4) NULL
,[OKATO] NVARCHAR(11) NULL
,[UPDATEDATE] DATE NOT NULL
,[SHORTNAME] NVARCHAR(10) NOT NULL
,[AOLEVEL] BIGINT NOT NULL
,[PARENTGUID] UNIQUEIDENTIFIER NULL
,[AOID] UNIQUEIDENTIFIER NOT NULL
,[PREVID] UNIQUEIDENTIFIER NULL
,[NEXTID] UNIQUEIDENTIFIER NULL
,[CODE] NVARCHAR(17) NULL
,[PLAINCODE] NVARCHAR(15) NULL
,[ACTSTATUS] BIGINT NOT NULL
,[CENTSTATUS] BIGINT NOT NULL
,[OPERSTATUS] BIGINT NOT NULL
,[CURRSTATUS] BIGINT NOT NULL
,[STARTDATE] DATE NOT NULL
,[ENDDATE] DATE NOT NULL
,[NORMDOC] UNIQUEIDENTIFIER NULL
,[LIVESTATUS] TINYINT NOT NULL
,[DIVTYPE] INT NOT NULL
,[OKTMO] NVARCHAR(11) NULL
);
CREATE TABLE [dbo].[_CENTERST] (
[CENTERSTID] BIGINT NOT NULL
,[NAME] NVARCHAR(100) NOT NULL
);
CREATE TABLE [dbo].[_CURENTST] (
[CURENTSTID] BIGINT NOT NULL
,[NAME] NVARCHAR(100) NOT NULL
);
CREATE TABLE [dbo].[_DEL_ADDROBJ] (
[AOGUID] UNIQUEIDENTIFIER NOT NULL
,[FORMALNAME] NVARCHAR(120) NOT NULL
,[REGIONCODE] NVARCHAR(2) NOT NULL
,[AUTOCODE] NVARCHAR(1) NOT NULL
,[AREACODE] NVARCHAR(3) NOT NULL
,[CITYCODE] NVARCHAR(3) NOT NULL
,[CTARCODE] NVARCHAR(3) NOT NULL
,[PLACECODE] NVARCHAR(3) NOT NULL
,[STREETCODE] NVARCHAR(4) NULL
,[EXTRCODE] NVARCHAR(4) NOT NULL
,[PLANCODE] NVARCHAR(4) NOT NULL
,[SEXTCODE] NVARCHAR(3) NOT NULL
,[OFFNAME] NVARCHAR(120) NULL
,[POSTALCODE] NVARCHAR(6) NULL
,[SHORTNAME] NVARCHAR(10) NOT NULL
,[AOLEVEL] BIGINT NOT NULL
,[PARENTGUID] UNIQUEIDENTIFIER NULL
,[AOID] UNIQUEIDENTIFIER NOT NULL
,[PREVID] UNIQUEIDENTIFIER NULL
,[NEXTID] UNIQUEIDENTIFIER NULL
,[CODE] NVARCHAR(17) NULL
,[PLAINCODE] NVARCHAR(15) NULL
,[ACTSTATUS] BIGINT NOT NULL
,[CENTSTATUS] BIGINT NOT NULL
,[OPERSTATUS] BIGINT NOT NULL
,[CURRSTATUS] BIGINT NOT NULL
,[STARTDATE] DATE NOT NULL
,[ENDDATE] DATE NOT NULL
,[NORMDOC] UNIQUEIDENTIFIER NULL
,[LIVESTATUS] TINYINT NOT NULL
,[IFNSFL] NVARCHAR(4) NULL
,[TERRIFNSFL] NVARCHAR(4) NULL
,[IFNSUL] NVARCHAR(4) NULL
,[TERRIFNSUL] NVARCHAR(4) NULL
,[OKATO] NVARCHAR(11) NULL
,[OKTMO] NVARCHAR(11) NULL
,[UPDATEDATE] DATE NOT NULL
);
CREATE TABLE [dbo].[_DEL_HOUSE] (
[POSTALCODE] NVARCHAR(6) NULL
,[IFNSFL] NVARCHAR(4) NULL
,[TERRIFNSFL] NVARCHAR(4) NULL
,[IFNSUL] NVARCHAR(4) NULL
,[TERRIFNSUL] NVARCHAR(4) NULL
,[OKATO] NVARCHAR(11) NULL
,[OKTMO] NVARCHAR(11) NULL
,[UPDATEDATE] DATE NOT NULL
,[HOUSENUM] NVARCHAR(20) NULL
,[ESTSTATUS] SMALLINT NOT NULL
,[BUILDNUM] NVARCHAR(10) NULL
,[STRUCNUM] NVARCHAR(10) NULL
,[STRSTATUS] BIGINT NULL
,[HOUSEID] UNIQUEIDENTIFIER NOT NULL
,[HOUSEGUID] UNIQUEIDENTIFIER NOT NULL
,[AOGUID] UNIQUEIDENTIFIER NOT NULL
,[STARTDATE] DATE NOT NULL
,[ENDDATE] DATE NOT NULL
,[STATSTATUS] BIGINT NOT NULL
,[NORMDOC] UNIQUEIDENTIFIER NULL
,[COUNTER] BIGINT NOT NULL
,[CADNUM] NVARCHAR(100) NULL
,[DIVTYPE] INT NOT NULL
);
CREATE TABLE [dbo].[_DEL_HOUSEINT] (
[IFNSUL] NVARCHAR(4) NULL
,[TERRIFNSUL] NVARCHAR(4) NULL
,[OKATO] NVARCHAR(11) NULL
,[OKTMO] NVARCHAR(11) NULL
,[UPDATEDATE] DATE NOT NULL
,[INTSTART] BIGINT NOT NULL
,[INTEND] BIGINT NOT NULL
,[POSTALCODE] NVARCHAR(6) NULL
,[IFNSFL] NVARCHAR(4) NULL
,[TERRIFNSFL] NVARCHAR(4) NULL
,[HOUSEINTID] UNIQUEIDENTIFIER NOT NULL
,[INTGUID] UNIQUEIDENTIFIER NOT NULL
,[AOGUID] UNIQUEIDENTIFIER NOT NULL
,[STARTDATE] DATE NOT NULL
,[ENDDATE] DATE NOT NULL
,[INTSTATUS] BIGINT NOT NULL
,[NORMDOC] UNIQUEIDENTIFIER NULL
,[COUNTER] BIGINT NOT NULL
);
CREATE TABLE [dbo].[_DEL_LANDMARK] (
[LOCATION] NVARCHAR(500) NOT NULL
,[POSTALCODE] NVARCHAR(6) NULL
,[IFNSFL] NVARCHAR(4) NULL
,[TERRIFNSFL] NVARCHAR(4) NULL
,[IFNSUL] NVARCHAR(4) NULL
,[TERRIFNSUL] NVARCHAR(4) NULL
,[OKATO] NVARCHAR(11) NULL
,[OKTMO] NVARCHAR(11) NULL
,[UPDATEDATE] DATE NOT NULL
,[LANDID] UNIQUEIDENTIFIER NOT NULL
,[LANDGUID] UNIQUEIDENTIFIER NOT NULL
,[AOGUID] UNIQUEIDENTIFIER NOT NULL
,[STARTDATE] DATE NOT NULL
,[ENDDATE] DATE NOT NULL
,[NORMDOC] UNIQUEIDENTIFIER NULL
);
CREATE TABLE [dbo].[_DEL_NORMDOC] (
[NORMDOCID] UNIQUEIDENTIFIER NOT NULL
,[DOCNAME] NVARCHAR(max) NULL
,[DOCDATE] DATE NULL
,[DOCNUM] NVARCHAR(20) NULL
,[DOCTYPE] BIGINT NOT NULL
,[DOCIMGID] UNIQUEIDENTIFIER NULL
);
CREATE TABLE [dbo].[_ESTSTAT] (
[ESTSTATID] BIGINT NOT NULL
,[NAME] NVARCHAR(20) NOT NULL
,[SHORTNAME] NVARCHAR(20) NULL
);
CREATE TABLE [dbo].[_FLATTYPE] (
[SHORTNAME] NVARCHAR(20) NULL
,[FLTYPEID] BIGINT NOT NULL
,[NAME] NVARCHAR(20) NOT NULL
);
CREATE TABLE [dbo].[_HOUSE] (
[POSTALCODE] NVARCHAR(6) NULL
,[REGIONCODE] NVARCHAR(2) NULL
,[IFNSFL] NVARCHAR(4) NULL
,[TERRIFNSFL] NVARCHAR(4) NULL
,[IFNSUL] NVARCHAR(4) NULL
,[TERRIFNSUL] NVARCHAR(4) NULL
,[OKATO] NVARCHAR(11) NULL
,[OKTMO] NVARCHAR(11) NULL
,[UPDATEDATE] DATE NOT NULL
,[HOUSENUM] NVARCHAR(20) NULL
,[ESTSTATUS] SMALLINT NOT NULL
,[BUILDNUM] NVARCHAR(10) NULL
,[STRUCNUM] NVARCHAR(10) NULL
,[STRSTATUS] BIGINT NULL
,[HOUSEID] UNIQUEIDENTIFIER NOT NULL
,[HOUSEGUID] UNIQUEIDENTIFIER NOT NULL
,[AOGUID] UNIQUEIDENTIFIER NOT NULL
,[STARTDATE] DATE NOT NULL
,[ENDDATE] DATE NOT NULL
,[STATSTATUS] BIGINT NOT NULL
,[NORMDOC] UNIQUEIDENTIFIER NULL
,[COUNTER] BIGINT NOT NULL
,[CADNUM] NVARCHAR(100) NULL
,[DIVTYPE] INT NOT NULL
);
CREATE TABLE [dbo].[_HOUSEINT] (
[OKTMO] NVARCHAR(11) NULL
,[OKATO] NVARCHAR(11) NULL
,[IFNSUL] NVARCHAR(4) NULL
,[TERRIFNSUL] NVARCHAR(4) NULL
,[TERRIFNSFL] NVARCHAR(4) NULL
,[POSTALCODE] NVARCHAR(6) NULL
,[IFNSFL] NVARCHAR(4) NULL
,[ENDDATE] DATE NOT NULL
,[INTSTATUS] BIGINT NOT NULL
,[AOGUID] UNIQUEIDENTIFIER NOT NULL
,[STARTDATE] DATE NOT NULL
,[INTGUID] UNIQUEIDENTIFIER NOT NULL
,[HOUSEINTID] UNIQUEIDENTIFIER NOT NULL
,[INTSTART] BIGINT NOT NULL
,[INTEND] BIGINT NOT NULL
,[UPDATEDATE] DATE NOT NULL
,[NORMDOC] UNIQUEIDENTIFIER NULL
,[COUNTER] BIGINT NOT NULL
);
CREATE TABLE [dbo].[_HSTSTAT] (
[HOUSESTID] BIGINT NOT NULL
,[NAME] NVARCHAR(60) NOT NULL
);
CREATE TABLE [dbo].[_INTVSTAT] (
[INTVSTATID] BIGINT NOT NULL
,[NAME] NVARCHAR(60) NOT NULL
);
CREATE TABLE [dbo].[_LANDMARK] (
[NORMDOC] UNIQUEIDENTIFIER NULL
,[STARTDATE] DATE NOT NULL
,[ENDDATE] DATE NOT NULL
,[LANDGUID] UNIQUEIDENTIFIER NOT NULL
,[AOGUID] UNIQUEIDENTIFIER NOT NULL
,[LANDID] UNIQUEIDENTIFIER NOT NULL
,[LOCATION] NVARCHAR(500) NOT NULL
,[POSTALCODE] NVARCHAR(6) NULL
,[TERRIFNSFL] NVARCHAR(4) NULL
,[IFNSFL] NVARCHAR(4) NULL
,[UPDATEDATE] DATE NOT NULL
,[OKTMO] NVARCHAR(11) NULL
,[OKATO] NVARCHAR(11) NULL
,[IFNSUL] NVARCHAR(4) NULL
,[TERRIFNSUL] NVARCHAR(4) NULL
);
CREATE TABLE [dbo].[_NDOCTYPE] (
[NDTYPEID] BIGINT NOT NULL
,[NAME] NVARCHAR(250) NOT NULL
);
CREATE TABLE [dbo].[_NORMDOC] (
[NORMDOCID] UNIQUEIDENTIFIER NOT NULL
,[DOCNAME] NVARCHAR(max) NULL
,[DOCDATE] DATE NULL
,[DOCNUM] NVARCHAR(20) NULL
,[DOCTYPE] BIGINT NOT NULL
,[DOCIMGID] UNIQUEIDENTIFIER NULL
);
CREATE TABLE [dbo].[_OPERSTAT] (
[OPERSTATID] BIGINT NOT NULL
,[NAME] NVARCHAR(100) NOT NULL
);
CREATE TABLE [dbo].[_ROOM] (
[ROOMGUID] UNIQUEIDENTIFIER NOT NULL
,[FLATNUMBER] NVARCHAR(50) NOT NULL
,[FLATTYPE] INT NOT NULL
,[ROOMNUMBER] NVARCHAR(50) NULL
,[ROOMTYPE] INT NULL
,[REGIONCODE] NVARCHAR(2) NOT NULL
,[POSTALCODE] NVARCHAR(6) NULL
,[UPDATEDATE] DATE NOT NULL
,[HOUSEGUID] UNIQUEIDENTIFIER NOT NULL
,[ROOMID] UNIQUEIDENTIFIER NOT NULL
,[PREVID] UNIQUEIDENTIFIER NULL
,[NEXTID] UNIQUEIDENTIFIER NULL
,[STARTDATE] DATE NOT NULL
,[ENDDATE] DATE NOT NULL
,[LIVESTATUS] TINYINT NOT NULL
,[NORMDOC] UNIQUEIDENTIFIER NULL
,[OPERSTATUS] BIGINT NOT NULL
,[CADNUM] NVARCHAR(100) NULL
,[ROOMCADNUM] NVARCHAR(100) NULL
);
CREATE TABLE [dbo].[_ROOMTYPE] (
[SHORTNAME] NVARCHAR(20) NULL
,[NAME] NVARCHAR(20) NOT NULL
,[RMTYPEID] BIGINT NOT NULL
);
CREATE TABLE [dbo].[_SOCRBASE] (
[LEVEL] BIGINT NOT NULL
,[SCNAME] NVARCHAR(10) NULL
,[SOCRNAME] NVARCHAR(50) NOT NULL
,[KOD_T_ST] NVARCHAR(4) NOT NULL
);
CREATE TABLE [dbo].[_STEAD] (
[STEADGUID] UNIQUEIDENTIFIER NOT NULL
,[NUMBER] NVARCHAR(120) NULL
,[REGIONCODE] NVARCHAR(2) NOT NULL
,[POSTALCODE] NVARCHAR(6) NULL
,[IFNSFL] NVARCHAR(4) NULL
,[TERRIFNSFL] NVARCHAR(4) NULL
,[IFNSUL] NVARCHAR(4) NULL
,[TERRIFNSUL] NVARCHAR(4) NULL
,[OKATO] NVARCHAR(11) NULL
,[OKTMO] NVARCHAR(11) NULL
,[UPDATEDATE] DATE NOT NULL
,[PARENTGUID] UNIQUEIDENTIFIER NULL
,[STEADID] UNIQUEIDENTIFIER NOT NULL
,[PREVID] UNIQUEIDENTIFIER NULL
,[NEXTID] UNIQUEIDENTIFIER NULL
,[OPERSTATUS] BIGINT NOT NULL
,[STARTDATE] DATE NOT NULL
,[ENDDATE] DATE NOT NULL
,[NORMDOC] UNIQUEIDENTIFIER NULL
,[LIVESTATUS] TINYINT NOT NULL
,[CADNUM] NVARCHAR(100) NULL
,[DIVTYPE] INT NOT NULL
);
CREATE TABLE [dbo].[_STRSTAT] (
[NAME] NVARCHAR(20) NOT NULL
,[SHORTNAME] NVARCHAR(20) NULL
,[STRSTATID] BIGINT NOT NULL
)
4. แแแแแถแแแถแแแถแแแทแแแแแถแแแแแแถแแแแถแแถแ แแทแแแถแแแ แแแแปแ xsd แแพแแแนแแแแแพแแถ แ แพแแแแแแพแแแถแแแทแแแแแถแขแแแธแแ แแถแแแแแแแแแแ แแแแปแแแแแแแแแแแแแแแทแแแแแแแแแแถแแถแ แแทแแแถแแแแแแแฝแแแแ
-- ะกะพะทะดะฐะดะธะผ ะฐะฝะฝะพัะฐัะธั ะบ ัะฐะฑะปะธัะฐะผ ะธ ะฟะพะปัะผ
Set @sql = (
Select N'; exec sp_addextendedproperty @name=''description'', @value=N'''
+ a.[root_description]
+ N''', @level0type =N''Schema'', @level0name = N'''
+ @schema
+ N''', @level1type = N''Table'', @level1name = N'''
+ a.[table โโ not found /]
+ N''''
from (Select distinct [table โโ not found /]
, [root_description] from dbo.[_FIAS]) a
for xml path(N''), type
).value(N'.', N'nvarchar(max)')
exec (@sql)
Set @sql = (
Select N'; exec sp_addextendedproperty @name=''description'', @value=N'''
+ a.[description]
+ N''', @level0type =N''Schema'', @level0name = N'''
+ @schema
+ N''', @level1type = N''Table'', @level1name = N'''
+ a.[table โโ not found /]
+ N''', @level2type = N''Column'', @level2name = N'''
+ a.[column]
+ N''''
from dbo.[_FIAS] a
for xml path(N''), type
).value(N'.', N'nvarchar(max)')
exec (@sql)
แแแแแบแแถแแผแแแแแแถแแแแแแแแแถแ แแทแแแแแแทแแแแแทแแถแแแแแแแแแแถแแแถแ
;
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ะกะพััะฐะฒ ะธ ััััะบัััะฐ ัะฐะนะปะฐ ั ะธะฝัะพัะผะฐัะธะตะน ะฟะพ ััะฐัััั ะฐะบััะฐะปัะฝะพััะธ ะฒ ะะ ะคะะะก'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_ACTSTAT';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ะกะพััะฐะฒ ะธ ััััะบัััะฐ ัะฐะนะปะฐ ั ะธะฝัะพัะผะฐัะธะตะน ะบะปะฐััะธัะธะบะฐัะพัะฐ ะฐะดัะตัะพะพะฑัะฐะทัััะธั
ัะปะตะผะตะฝัะพะฒ ะะ ะคะะะก'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_ADDROBJ';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ะกะพััะฐะฒ ะธ ััััะบัััะฐ ัะฐะนะปะฐ ั ะธะฝัะพัะผะฐัะธะตะน ะฟะพ ััะฐัััั ัะตะฝััะฐ ะฒ ะะ ะคะะะก'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_CENTERST';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ะกะพััะฐะฒ ะธ ััััะบัััะฐ ัะฐะนะปะฐ ั ะธะฝัะพัะผะฐัะธะตะน ะฟะพ ััะฐัััั ะฐะบััะฐะปัะฝะพััะธ ะะะะะ 4.0 ะฒ ะะ ะคะะะก'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_CURENTST';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ะกะพััะฐะฒ ะธ ััััะบัััะฐ ัะฐะนะปะฐ ั ะธะฝัะพัะผะฐัะธะตะน ะบะปะฐััะธัะธะบะฐัะพัะฐ ะฐะดัะตัะพะพะฑัะฐะทัััะธั
ัะปะตะผะตะฝัะพะฒ ะะ ะคะะะก'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_DEL_ADDROBJ';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ะกะพััะฐะฒ ะธ ััััะบัััะฐ ัะฐะนะปะฐ ั ะธะฝัะพัะผะฐัะธะตะน ะฟะพ ะฝะพะผะตัะฐะผ ะดะพะผะพะฒ ัะปะธั ะณะพัะพะดะพะฒ ะธ ะฝะฐัะตะปะตะฝะฝัั
ะฟัะฝะบัะพะฒ, ะฝะพะผะตัะฐ ะทะตะผะตะปัะฝัั
ััะฐััะบะพะฒ ะธ ั.ะฟ ะฒ ะะ ะคะะะก'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_DEL_HOUSE';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ะกะพััะฐะฒ ะธ ััััะบัััะฐ ัะฐะนะปะฐ ั ะธะฝัะพัะผะฐัะธะตะน ะฟะพ ะธะฝัะตัะฒะฐะปะฐะผ ะดะพะผะพะฒ ะฒ ะะ ะคะะะก'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_DEL_HOUSEINT';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ะกะพััะฐะฒ ะธ ััััะบัััะฐ ัะฐะนะปะฐ ั ะธะฝัะพัะผะฐัะธะตะน ะฟะพ ะพะฟะธัะฐะฝะธั ะผะตัั ัะฐัะฟะพะปะพะถะตะฝะธั ะธะผััะตััะฒะตะฝะฝัั
ะพะฑัะตะบัะพะฒ ะฒ ะะ ะคะะะก'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_DEL_LANDMARK';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ะกะพััะฐะฒ ะธ ััััะบัััะฐ ัะฐะนะปะฐ ั ะธะฝัะพัะผะฐัะธะตะน ะฟะพ ัะฒะตะดะตะฝะธัะผ ะฟะพ ะฝะพัะผะฐัะธะฒะฝัะผ ะดะพะบัะผะตะฝัะฐะผ, ัะฒะปัััะธะผัั ะพัะฝะพะฒะฐะฝะธะตะผ ะฟัะธัะฒะพะตะฝะธั ะฐะดัะตัะฝะพะผั ัะปะตะผะตะฝัั ะฝะฐะธะผะตะฝะพะฒะฐะฝะธั ะฒ ะะ ะคะะะก'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_DEL_NORMDOC';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ะกะพััะฐะฒ ะธ ััััะบัััะฐ ัะฐะนะปะฐ ั ะธะฝัะพัะผะฐัะธะตะน ะฟะพ ะฟัะธะทะฝะฐะบะฐะผ ะฒะปะฐะดะตะฝะธั ะฒ ะะ ะคะะะก'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_ESTSTAT';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ะกะพััะฐะฒ ะธ ััััะบัััะฐ ัะฐะนะปะฐ ั ะธะฝัะพัะผะฐัะธะตะน ะฟะพ ัะธะฟะฐะผ ะฟะพะผะตัะตะฝะธะน ะฒ ะะ ะคะะะก'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_FLATTYPE';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ะกะพััะฐะฒ ะธ ััััะบัััะฐ ัะฐะนะปะฐ ั ะธะฝัะพัะผะฐัะธะตะน ะฟะพ ะฝะพะผะตัะฐะผ ะดะพะผะพะฒ ัะปะธั ะณะพัะพะดะพะฒ ะธ ะฝะฐัะตะปะตะฝะฝัั
ะฟัะฝะบัะพะฒ ะฒ ะะ ะคะะะก'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_HOUSE';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ะกะพััะฐะฒ ะธ ััััะบัััะฐ ัะฐะนะปะฐ ั ะธะฝัะพัะผะฐัะธะตะน ะฟะพ ะธะฝัะตัะฒะฐะปะฐะผ ะดะพะผะพะฒ ะฒ ะะ ะคะะะก'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_HOUSEINT';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ะกะพััะฐะฒ ะธ ััััะบัััะฐ ัะฐะนะปะฐ ั ะธะฝัะพัะผะฐัะธะตะน ะฟะพ ััะฐัััั ัะพััะพัะฝะธั ะดะพะผะพะฒ ะฒ ะะ ะคะะะก'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_HSTSTAT';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ะกะพััะฐะฒ ะธ ััััะบัััะฐ ัะฐะนะปะฐ ั ะธะฝัะพัะผะฐัะธะตะน ะฟะพ ััะฐัััั ะธะฝัะตัะฒะฐะปะพะฒ ะดะพะผะพะฒ ะฒ ะะ ะคะะะก'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_INTVSTAT';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ะกะพััะฐะฒ ะธ ััััะบัััะฐ ัะฐะนะปะฐ ั ะธะฝัะพัะผะฐัะธะตะน ะฟะพ ะพะฟะธัะฐะฝะธั ะผะตัั ัะฐัะฟะพะปะพะถะตะฝะธั ะธะผััะตััะฒะตะฝะฝัั
ะพะฑัะตะบัะพะฒ ะฒ ะะ ะคะะะก'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_LANDMARK';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ะกะพััะฐะฒ ะธ ััััะบัััะฐ ัะฐะนะปะฐ ั ะธะฝัะพัะผะฐัะธะตะน ะฟะพ ัะธะฟั ะฝะพัะผะฐัะธะฒะฝะพะณะพ ะดะพะบัะผะตะฝัะฐ ะฒ ะะ ะคะะะก'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_NDOCTYPE';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ะกะพััะฐะฒ ะธ ััััะบัััะฐ ัะฐะนะปะฐ ั ะธะฝัะพัะผะฐัะธะตะน ะฟะพ ัะฒะตะดะตะฝะธัะผ ะฟะพ ะฝะพัะผะฐัะธะฒะฝัะผ ะดะพะบัะผะตะฝัะฐะผ, ัะฒะปัััะธะผัั ะพัะฝะพะฒะฐะฝะธะตะผ ะฟัะธัะฒะพะตะฝะธั ะฐะดัะตัะฝะพะผั ัะปะตะผะตะฝัั ะฝะฐะธะผะตะฝะพะฒะฐะฝะธั ะฒ ะะ ะคะะะก'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_NORMDOC';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ะกะพััะฐะฒ ะธ ััััะบัััะฐ ัะฐะนะปะฐ ั ะธะฝัะพัะผะฐัะธะตะน ะฟะพ ััะฐัััั ะดะตะนััะฒะธั ะฒ ะะ ะคะะะก'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_OPERSTAT';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ะกะพััะฐะฒ ะธ ััััะบัััะฐ ัะฐะนะปะฐ ัะพ ัะฒะตะดะตะฝะธัะผะธ ะพ ะฟะพะผะตัะตะฝะธัั
'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_ROOM';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ะกะพััะฐะฒ ะธ ััััะบัััะฐ ัะฐะนะปะฐ ั ะธะฝัะพัะผะฐัะธะตะน ะฟะพ ัะธะฟะฐะผ ะบะพะผะฝะฐั ะฒ ะะ ะคะะะก'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_ROOMTYPE';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ะกะพััะฐะฒ ะธ ััััะบัััะฐ ัะฐะนะปะฐ ั ะธะฝัะพัะผะฐัะธะตะน ะฟะพ ัะธะฟะฐะผ ะฐะดัะตัะฝัั
ะพะฑัะตะบัะพะฒ ะฒ ะะ ะคะะะก'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_SOCRBASE';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ะกะพััะฐะฒ ะธ ััััะบัััะฐ ัะฐะนะปะฐ ัะพ ัะฒะตะดะตะฝะธัะผะธ ะพ ะทะตะผะตะปัะฝัั
ััะฐััะบะฐั
'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_STEAD';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ะกะพััะฐะฒ ะธ ััััะบัััะฐ ัะฐะนะปะฐ ั ะธะฝัะพัะผะฐัะธะตะน ะฟะพ ะฟัะธะทะฝะฐะบะฐะผ ัััะพะตะฝะธั ะฒ ะะ ะคะะะก'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_STRSTAT'
;
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ะะปะพะฑะฐะปัะฝัะน ัะฝะธะบะฐะปัะฝัะน ะธะดะตะฝัะธัะธะบะฐัะพั ะฐะดัะตัะฝะพะณะพ ะพะฑัะตะบัะฐ '
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_ADDROBJ'
,@level2type = N'Column'
,@level2name = N'AOGUID';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ะคะพัะผะฐะปะธะทะพะฒะฐะฝะฝะพะต ะฝะฐะธะผะตะฝะพะฒะฐะฝะธะต'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_ADDROBJ'
,@level2type = N'Column'
,@level2name = N'FORMALNAME';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ะะพะด ัะตะณะธะพะฝะฐ'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_ADDROBJ'
,@level2type = N'Column'
,@level2name = N'REGIONCODE';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ะะพะด ะฐะฒัะพะฝะพะผะธะธ'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_ADDROBJ'
,@level2type = N'Column'
,@level2name = N'AUTOCODE';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ะะพะด ัะฐะนะพะฝะฐ'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_ADDROBJ'
,@level2type = N'Column'
,@level2name = N'AREACODE';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ะะพะด ะณะพัะพะดะฐ'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_ADDROBJ'
,@level2type = N'Column'
,@level2name = N'CITYCODE';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ะะพะด ะฒะฝัััะธะณะพัะพะดัะบะพะณะพ ัะฐะนะพะฝะฐ'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_ADDROBJ'
,@level2type = N'Column'
,@level2name = N'CTARCODE';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ะะพะด ะฝะฐัะตะปะตะฝะฝะพะณะพ ะฟัะฝะบัะฐ'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_ADDROBJ'
,@level2type = N'Column'
,@level2name = N'PLACECODE';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ะะพะด ัะปะตะผะตะฝัะฐ ะฟะปะฐะฝะธัะพะฒะพัะฝะพะน ััััะบัััั'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_ADDROBJ'
,@level2type = N'Column'
,@level2name = N'PLANCODE';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ะะพะด ัะปะธัั'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_ADDROBJ'
,@level2type = N'Column'
,@level2name = N'STREETCODE';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ะะพะด ะดะพะฟะพะปะฝะธัะตะปัะฝะพะณะพ ะฐะดัะตัะพะพะฑัะฐะทัััะตะณะพ ัะปะตะผะตะฝัะฐ'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_ADDROBJ'
,@level2type = N'Column'
,@level2name = N'EXTRCODE';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ะะพะด ะฟะพะดัะธะฝะตะฝะฝะพะณะพ ะดะพะฟะพะปะฝะธัะตะปัะฝะพะณะพ ะฐะดัะตัะพะพะฑัะฐะทัััะตะณะพ ัะปะตะผะตะฝัะฐ'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_ADDROBJ'
,@level2type = N'Column'
,@level2name = N'SEXTCODE';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ะัะธัะธะฐะปัะฝะพะต ะฝะฐะธะผะตะฝะพะฒะฐะฝะธะต'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_ADDROBJ'
,@level2type = N'Column'
,@level2name = N'OFFNAME';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ะะพััะพะฒัะน ะธะฝะดะตะบั'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_ADDROBJ'
,@level2type = N'Column'
,@level2name = N'POSTALCODE';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ะะพะด ะะคะะก ะคะ'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_ADDROBJ'
,@level2type = N'Column'
,@level2name = N'IFNSFL';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ะะพะด ัะตััะธัะพัะธะฐะปัะฝะพะณะพ ััะฐััะบะฐ ะะคะะก ะคะ'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_ADDROBJ'
,@level2type = N'Column'
,@level2name = N'TERRIFNSFL';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ะะพะด ะะคะะก ะฎะ'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_ADDROBJ'
,@level2type = N'Column'
,@level2name = N'IFNSUL';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ะะพะด ัะตััะธัะพัะธะฐะปัะฝะพะณะพ ััะฐััะบะฐ ะะคะะก ะฎะ'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_ADDROBJ'
,@level2type = N'Column'
,@level2name = N'TERRIFNSUL';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'OKATO'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_ADDROBJ'
,@level2type = N'Column'
,@level2name = N'OKATO';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ะะฐัะฐ ะฒะฝะตัะตะฝะธั ะทะฐะฟะธัะธ'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_ADDROBJ'
,@level2type = N'Column'
,@level2name = N'UPDATEDATE';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ะัะฐัะบะพะต ะฝะฐะธะผะตะฝะพะฒะฐะฝะธะต ัะธะฟะฐ ะพะฑัะตะบัะฐ'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_ADDROBJ'
,@level2type = N'Column'
,@level2name = N'SHORTNAME';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ะฃัะพะฒะตะฝั ะฐะดัะตัะฝะพะณะพ ะพะฑัะตะบัะฐ '
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_ADDROBJ'
,@level2type = N'Column'
,@level2name = N'AOLEVEL';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ะะดะตะฝัะธัะธะบะฐัะพั ะพะฑัะตะบัะฐ ัะพะดะธัะตะปััะบะพะณะพ ะพะฑัะตะบัะฐ'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_ADDROBJ'
,@level2type = N'Column'
,@level2name = N'PARENTGUID';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ะฃะฝะธะบะฐะปัะฝัะน ะธะดะตะฝัะธัะธะบะฐัะพั ะทะฐะฟะธัะธ. ะะปััะตะฒะพะต ะฟะพะปะต.'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_ADDROBJ'
,@level2type = N'Column'
,@level2name = N'AOID';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ะะดะตะฝัะธัะธะบะฐัะพั ะทะฐะฟะธัะธ ัะฒัะทัะฒะฐะฝะธั ั ะฟัะตะดัะดััะตะน ะธััะพัะธัะตัะบะพะน ะทะฐะฟะธััั'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_ADDROBJ'
,@level2type = N'Column'
,@level2name = N'PREVID';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ะะดะตะฝัะธัะธะบะฐัะพั ะทะฐะฟะธัะธ ัะฒัะทัะฒะฐะฝะธั ั ะฟะพัะปะตะดัััะตะน ะธััะพัะธัะตัะบะพะน ะทะฐะฟะธััั'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_ADDROBJ'
,@level2type = N'Column'
,@level2name = N'NEXTID';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ะะพะด ะฐะดัะตัะฝะพะณะพ ะพะฑัะตะบัะฐ ะพะดะฝะพะน ัััะพะบะพะน ั ะฟัะธะทะฝะฐะบะพะผ ะฐะบััะฐะปัะฝะพััะธ ะธะท ะะะะะ 4.0. '
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_ADDROBJ'
,@level2type = N'Column'
,@level2name = N'CODE';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ะะพะด ะฐะดัะตัะฝะพะณะพ ะพะฑัะตะบัะฐ ะธะท ะะะะะ 4.0 ะพะดะฝะพะน ัััะพะบะพะน ะฑะตะท ะฟัะธะทะฝะฐะบะฐ ะฐะบััะฐะปัะฝะพััะธ (ะฟะพัะปะตะดะฝะธั
ะดะฒัั
ัะธัั)'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_ADDROBJ'
,@level2type = N'Column'
,@level2name = N'PLAINCODE';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ะกัะฐััั ะฐะบััะฐะปัะฝะพััะธ ะฐะดัะตัะฝะพะณะพ ะพะฑัะตะบัะฐ ะคะะะก. ะะบััะฐะปัะฝัะน ะฐะดัะตั ะฝะฐ ัะตะบัััั ะดะฐัั. ะะฑััะฝะพ ะฟะพัะปะตะดะฝัั ะทะฐะฟะธัั ะพะฑ ะฐะดัะตัะฝะพะผ ะพะฑัะตะบัะต.
0 โ ะะต ะฐะบััะฐะปัะฝัะน
1 - ะะบััะฐะปัะฝัะน
'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_ADDROBJ'
,@level2type = N'Column'
,@level2name = N'ACTSTATUS';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ะกัะฐััั ัะตะฝััะฐ'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_ADDROBJ'
,@level2type = N'Column'
,@level2name = N'CENTSTATUS';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ะกัะฐััั ะดะตะนััะฒะธั ะฝะฐะด ะทะฐะฟะธััั โ ะฟัะธัะธะฝะฐ ะฟะพัะฒะปะตะฝะธั ะทะฐะฟะธัะธ (ัะผ. ะพะฟะธัะฐะฝะธะต ัะฐะฑะปะธัั OperationStatus):
01 โ ะะฝะธัะธะฐัะธั;
10 โ ะะพะฑะฐะฒะปะตะฝะธะต;
20 โ ะะทะผะตะฝะตะฝะธะต;
21 โ ะััะฟะฟะพะฒะพะต ะธะทะผะตะฝะตะฝะธะต;
30 โ ะฃะดะฐะปะตะฝะธะต;
31 - ะฃะดะฐะปะตะฝะธะต ะฒัะปะตะดััะฒะธะต ัะดะฐะปะตะฝะธั ะฒััะตััะพััะตะณะพ ะพะฑัะตะบัะฐ;
40 โ ะัะธัะพะตะดะธะฝะตะฝะธะต ะฐะดัะตัะฝะพะณะพ ะพะฑัะตะบัะฐ (ัะปะธัะฝะธะต);
41 โ ะะตัะตะฟะพะดัะธะฝะตะฝะธะต ะฒัะปะตะดััะฒะธะต ัะปะธัะฝะธั ะฒััะตััะพััะตะณะพ ะพะฑัะตะบัะฐ;
42 - ะัะตะบัะฐัะตะฝะธะต ัััะตััะฒะพะฒะฐะฝะธั ะฒัะปะตะดััะฒะธะต ะฟัะธัะพะตะดะธะฝะตะฝะธั ะบ ะดััะณะพะผั ะฐะดัะตัะฝะพะผั ะพะฑัะตะบัั;
43 - ะกะพะทะดะฐะฝะธะต ะฝะพะฒะพะณะพ ะฐะดัะตัะฝะพะณะพ ะพะฑัะตะบัะฐ ะฒ ัะตะทัะปััะฐัะต ัะปะธัะฝะธั ะฐะดัะตัะฝัั
ะพะฑัะตะบัะพะฒ;
50 โ ะะตัะตะฟะพะดัะธะฝะตะฝะธะต;
51 โ ะะตัะตะฟะพะดัะธะฝะตะฝะธะต ะฒัะปะตะดััะฒะธะต ะฟะตัะตะฟะพะดัะธะฝะตะฝะธั ะฒััะตััะพััะตะณะพ ะพะฑัะตะบัะฐ;
60 โ ะัะตะบัะฐัะตะฝะธะต ัััะตััะฒะพะฒะฐะฝะธั ะฒัะปะตะดััะฒะธะต ะดัะพะฑะปะตะฝะธั;
61 โ ะกะพะทะดะฐะฝะธะต ะฝะพะฒะพะณะพ ะฐะดัะตัะฝะพะณะพ ะพะฑัะตะบัะฐ ะฒ ัะตะทัะปััะฐัะต ะดัะพะฑะปะตะฝะธั
'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_ADDROBJ'
,@level2type = N'Column'
,@level2name = N'OPERSTATUS';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ะกัะฐััั ะฐะบััะฐะปัะฝะพััะธ ะะะะะ 4 (ะฟะพัะปะตะดะฝะธะต ะดะฒะต ัะธััั ะฒ ะบะพะดะต)'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_ADDROBJ'
,@level2type = N'Column'
,@level2name = N'CURRSTATUS';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ะะฐัะฐะปะพ ะดะตะนััะฒะธั ะทะฐะฟะธัะธ'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_ADDROBJ'
,@level2type = N'Column'
,@level2name = N'STARTDATE';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ะะบะพะฝัะฐะฝะธะต ะดะตะนััะฒะธั ะทะฐะฟะธัะธ'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_ADDROBJ'
,@level2type = N'Column'
,@level2name = N'ENDDATE';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ะะฝะตัะฝะธะน ะบะปัั ะฝะฐ ะฝะพัะผะฐัะธะฒะฝัะน ะดะพะบัะผะตะฝั'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_ADDROBJ'
,@level2type = N'Column'
,@level2name = N'NORMDOC';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ะัะธะทะฝะฐะบ ะดะตะนััะฒัััะตะณะพ ะฐะดัะตัะฝะพะณะพ ะพะฑัะตะบัะฐ'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_ADDROBJ'
,@level2type = N'Column'
,@level2name = N'LIVESTATUS';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'
ะขะธะฟ ะฐะดัะตัะฐัะธะธ:
0 - ะฝะต ะพะฟัะตะดะตะปะตะฝะพ
1 - ะผัะฝะธัะธะฟะฐะปัะฝัะน;
2 - ะฐะดะผะธะฝะธัััะฐัะธะฒะฝะพ-ัะตััะธัะพัะธะฐะปัะฝัะน
'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_ADDROBJ'
,@level2type = N'Column'
,@level2name = N'DIVTYPE';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'OKTMO'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_ADDROBJ'
,@level2type = N'Column'
,@level2name = N'OKTMO';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ะะดะตะฝัะธัะธะบะฐัะพั ััะฐัััะฐ (ะบะปัั)'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_CURENTST'
,@level2type = N'Column'
,@level2name = N'CURENTSTID';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ะะฐะธะผะตะฝะพะฒะฐะฝะธะต (0 - ะฐะบััะฐะปัะฝัะน, 1-50, 2-98 โ ะธััะพัะธัะตัะบะธะน (ะบัะพะผะต 51), 51 - ะฟะตัะตะฟะพะดัะธะฝะตะฝะฝัะน, 99 - ะฝะตัััะตััะฒัััะธะน)'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_CURENTST'
,@level2type = N'Column'
,@level2name = N'NAME';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ะัะฐัะบะพะต ะฝะฐะธะผะตะฝะพะฒะฐะฝะธะต'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_FLATTYPE'
,@level2type = N'Column'
,@level2name = N'SHORTNAME';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ะขะธะฟ ะฟะพะผะตัะตะฝะธั'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_FLATTYPE'
,@level2type = N'Column'
,@level2name = N'FLTYPEID';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ะะฐะธะผะตะฝะพะฒะฐะฝะธะต'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_FLATTYPE'
,@level2type = N'Column'
,@level2name = N'NAME';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ะะดะตะฝัะธัะธะบะฐัะพั ััะฐัััะฐ'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_HSTSTAT'
,@level2type = N'Column'
,@level2name = N'HOUSESTID';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ะะฐะธะผะตะฝะพะฒะฐะฝะธะต'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_HSTSTAT'
,@level2type = N'Column'
,@level2name = N'NAME';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ะะดะตะฝัะธัะธะบะฐัะพั ะทะฐะฟะธัะธ (ะบะปัั)'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_NDOCTYPE'
,@level2type = N'Column'
,@level2name = N'NDTYPEID';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ะะฐะธะผะตะฝะพะฒะฐะฝะธะต ัะธะฟะฐ ะฝะพัะผะฐัะธะฒะฝะพะณะพ ะดะพะบัะผะตะฝัะฐ'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_NDOCTYPE'
,@level2type = N'Column'
,@level2name = N'NAME';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ะะดะตะฝัะธัะธะบะฐัะพั ััะฐัััะฐ (ะบะปัั)'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_OPERSTAT'
,@level2type = N'Column'
,@level2name = N'OPERSTATID';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ะะฐะธะผะตะฝะพะฒะฐะฝะธะต
01 โ ะะฝะธัะธะฐัะธั;
10 โ ะะพะฑะฐะฒะปะตะฝะธะต;
20 โ ะะทะผะตะฝะตะฝะธะต;
21 โ ะััะฟะฟะพะฒะพะต ะธะทะผะตะฝะตะฝะธะต;
30 โ ะฃะดะฐะปะตะฝะธะต;
31 - ะฃะดะฐะปะตะฝะธะต ะฒัะปะตะดััะฒะธะต ัะดะฐะปะตะฝะธั ะฒััะตััะพััะตะณะพ ะพะฑัะตะบัะฐ;
40 โ ะัะธัะพะตะดะธะฝะตะฝะธะต ะฐะดัะตัะฝะพะณะพ ะพะฑัะตะบัะฐ (ัะปะธัะฝะธะต);
41 โ ะะตัะตะฟะพะดัะธะฝะตะฝะธะต ะฒัะปะตะดััะฒะธะต ัะปะธัะฝะธั ะฒััะตััะพััะตะณะพ ะพะฑัะตะบัะฐ;
42 - ะัะตะบัะฐัะตะฝะธะต ัััะตััะฒะพะฒะฐะฝะธั ะฒัะปะตะดััะฒะธะต ะฟัะธัะพะตะดะธะฝะตะฝะธั ะบ ะดััะณะพะผั ะฐะดัะตัะฝะพะผั ะพะฑัะตะบัั;
43 - ะกะพะทะดะฐะฝะธะต ะฝะพะฒะพะณะพ ะฐะดัะตัะฝะพะณะพ ะพะฑัะตะบัะฐ ะฒ ัะตะทัะปััะฐัะต ัะปะธัะฝะธั ะฐะดัะตัะฝัั
ะพะฑัะตะบัะพะฒ;
50 โ ะะตัะตะฟะพะดัะธะฝะตะฝะธะต;
51 โ ะะตัะตะฟะพะดัะธะฝะตะฝะธะต ะฒัะปะตะดััะฒะธะต ะฟะตัะตะฟะพะดัะธะฝะตะฝะธั ะฒััะตััะพััะตะณะพ ะพะฑัะตะบัะฐ;
60 โ ะัะตะบัะฐัะตะฝะธะต ัััะตััะฒะพะฒะฐะฝะธั ะฒัะปะตะดััะฒะธะต ะดัะพะฑะปะตะฝะธั;
61 โ ะกะพะทะดะฐะฝะธะต ะฝะพะฒะพะณะพ ะฐะดัะตัะฝะพะณะพ ะพะฑัะตะบัะฐ ะฒ ัะตะทัะปััะฐัะต ะดัะพะฑะปะตะฝะธั;
70 โ ะะพัััะฐะฝะพะฒะปะตะฝะธะต ะพะฑัะตะบัะฐ ะฟัะตะบัะฐัะธะฒัะตะณะพ ัััะตััะฒะพะฒะฐะฝะธะต'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_OPERSTAT'
,@level2type = N'Column'
,@level2name = N'NAME';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ะะปะพะฑะฐะปัะฝัะน ัะฝะธะบะฐะปัะฝัะน ะธะดะตะฝัะธัะธะบะฐัะพั ะฐะดัะตัะฝะพะณะพ ะพะฑัะตะบัะฐ '
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_DEL_ADDROBJ'
,@level2type = N'Column'
,@level2name = N'AOGUID';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ะคะพัะผะฐะปะธะทะพะฒะฐะฝะฝะพะต ะฝะฐะธะผะตะฝะพะฒะฐะฝะธะต'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_DEL_ADDROBJ'
,@level2type = N'Column'
,@level2name = N'FORMALNAME';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ะะพะด ัะตะณะธะพะฝะฐ'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_DEL_ADDROBJ'
,@level2type = N'Column'
,@level2name = N'REGIONCODE';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ะะพะด ะฐะฒัะพะฝะพะผะธะธ'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_DEL_ADDROBJ'
,@level2type = N'Column'
,@level2name = N'AUTOCODE';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ะะพะด ัะฐะนะพะฝะฐ'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_DEL_ADDROBJ'
,@level2type = N'Column'
,@level2name = N'AREACODE';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ะะพะด ะณะพัะพะดะฐ'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_DEL_ADDROBJ'
,@level2type = N'Column'
,@level2name = N'CITYCODE';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ะะพะด ะฒะฝัััะธะณะพัะพะดัะบะพะณะพ ัะฐะนะพะฝะฐ'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_DEL_ADDROBJ'
,@level2type = N'Column'
,@level2name = N'CTARCODE';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ะะพะด ะฝะฐัะตะปะตะฝะฝะพะณะพ ะฟัะฝะบัะฐ'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_DEL_ADDROBJ'
,@level2type = N'Column'
,@level2name = N'PLACECODE';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ะะพะด ัะปะธัั'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_DEL_ADDROBJ'
,@level2type = N'Column'
,@level2name = N'STREETCODE';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ะะพะด ะดะพะฟะพะปะฝะธัะตะปัะฝะพะณะพ ะฐะดัะตัะพะพะฑัะฐะทัััะตะณะพ ัะปะตะผะตะฝัะฐ'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_DEL_ADDROBJ'
,@level2type = N'Column'
,@level2name = N'EXTRCODE';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ะะพะด ัะปะตะผะตะฝัะฐ ะฟะปะฐะฝะธัะพะฒะพัะฝะพะน ััััะบัััั'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_DEL_ADDROBJ'
,@level2type = N'Column'
,@level2name = N'PLANCODE';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ะะพะด ะฟะพะดัะธะฝะตะฝะฝะพะณะพ ะดะพะฟะพะปะฝะธัะตะปัะฝะพะณะพ ะฐะดัะตัะพะพะฑัะฐะทัััะตะณะพ ัะปะตะผะตะฝัะฐ'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_DEL_ADDROBJ'
,@level2type = N'Column'
,@level2name = N'SEXTCODE';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ะัะธัะธะฐะปัะฝะพะต ะฝะฐะธะผะตะฝะพะฒะฐะฝะธะต'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_DEL_ADDROBJ'
,@level2type = N'Column'
,@level2name = N'OFFNAME';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ะะพััะพะฒัะน ะธะฝะดะตะบั'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_DEL_ADDROBJ'
,@level2type = N'Column'
,@level2name = N'POSTALCODE';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ะัะฐัะบะพะต ะฝะฐะธะผะตะฝะพะฒะฐะฝะธะต ัะธะฟะฐ ะพะฑัะตะบัะฐ'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_DEL_ADDROBJ'
,@level2type = N'Column'
,@level2name = N'SHORTNAME';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ะฃัะพะฒะตะฝั ะฐะดัะตัะฝะพะณะพ ะพะฑัะตะบัะฐ '
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_DEL_ADDROBJ'
,@level2type = N'Column'
,@level2name = N'AOLEVEL';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ะะดะตะฝัะธัะธะบะฐัะพั ะพะฑัะตะบัะฐ ัะพะดะธัะตะปััะบะพะณะพ ะพะฑัะตะบัะฐ'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_DEL_ADDROBJ'
,@level2type = N'Column'
,@level2name = N'PARENTGUID';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ะฃะฝะธะบะฐะปัะฝัะน ะธะดะตะฝัะธัะธะบะฐัะพั ะทะฐะฟะธัะธ. ะะปััะตะฒะพะต ะฟะพะปะต.'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_DEL_ADDROBJ'
,@level2type = N'Column'
,@level2name = N'AOID';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ะะดะตะฝัะธัะธะบะฐัะพั ะทะฐะฟะธัะธ ัะฒัะทัะฒะฐะฝะธั ั ะฟัะตะดัะดััะตะน ะธััะพัะธัะตัะบะพะน ะทะฐะฟะธััั'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_DEL_ADDROBJ'
,@level2type = N'Column'
,@level2name = N'PREVID';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ะะดะตะฝัะธัะธะบะฐัะพั ะทะฐะฟะธัะธ ัะฒัะทัะฒะฐะฝะธั ั ะฟะพัะปะตะดัััะตะน ะธััะพัะธัะตัะบะพะน ะทะฐะฟะธััั'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_DEL_ADDROBJ'
,@level2type = N'Column'
,@level2name = N'NEXTID';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ะะพะด ะฐะดัะตัะฝะพะณะพ ะพะฑัะตะบัะฐ ะพะดะฝะพะน ัััะพะบะพะน ั ะฟัะธะทะฝะฐะบะพะผ ะฐะบััะฐะปัะฝะพััะธ ะธะท ะะะะะ 4.0. '
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_DEL_ADDROBJ'
,@level2type = N'Column'
,@level2name = N'CODE';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ะะพะด ะฐะดัะตัะฝะพะณะพ ะพะฑัะตะบัะฐ ะธะท ะะะะะ 4.0 ะพะดะฝะพะน ัััะพะบะพะน ะฑะตะท ะฟัะธะทะฝะฐะบะฐ ะฐะบััะฐะปัะฝะพััะธ (ะฟะพัะปะตะดะฝะธั
ะดะฒัั
ัะธัั)'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_DEL_ADDROBJ'
,@level2type = N'Column'
,@level2name = N'PLAINCODE';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ะกัะฐััั ะฐะบััะฐะปัะฝะพััะธ ะฐะดัะตัะฝะพะณะพ ะพะฑัะตะบัะฐ ะคะะะก. ะะบััะฐะปัะฝัะน ะฐะดัะตั ะฝะฐ ัะตะบัััั ะดะฐัั. ะะฑััะฝะพ ะฟะพัะปะตะดะฝัั ะทะฐะฟะธัั ะพะฑ ะฐะดัะตัะฝะพะผ ะพะฑัะตะบัะต.
0 โ ะะต ะฐะบััะฐะปัะฝัะน
1 - ะะบััะฐะปัะฝัะน
'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_DEL_ADDROBJ'
,@level2type = N'Column'
,@level2name = N'ACTSTATUS';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ะกัะฐััั ัะตะฝััะฐ'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_DEL_ADDROBJ'
,@level2type = N'Column'
,@level2name = N'CENTSTATUS';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ะกัะฐััั ะดะตะนััะฒะธั ะฝะฐะด ะทะฐะฟะธััั โ ะฟัะธัะธะฝะฐ ะฟะพัะฒะปะตะฝะธั ะทะฐะฟะธัะธ (ัะผ. ะพะฟะธัะฐะฝะธะต ัะฐะฑะปะธัั OperationStatus):
01 โ ะะฝะธัะธะฐัะธั;
10 โ ะะพะฑะฐะฒะปะตะฝะธะต;
20 โ ะะทะผะตะฝะตะฝะธะต;
21 โ ะััะฟะฟะพะฒะพะต ะธะทะผะตะฝะตะฝะธะต;
30 โ ะฃะดะฐะปะตะฝะธะต;
31 - ะฃะดะฐะปะตะฝะธะต ะฒัะปะตะดััะฒะธะต ัะดะฐะปะตะฝะธั ะฒััะตััะพััะตะณะพ ะพะฑัะตะบัะฐ;
40 โ ะัะธัะพะตะดะธะฝะตะฝะธะต ะฐะดัะตัะฝะพะณะพ ะพะฑัะตะบัะฐ (ัะปะธัะฝะธะต);
41 โ ะะตัะตะฟะพะดัะธะฝะตะฝะธะต ะฒัะปะตะดััะฒะธะต ัะปะธัะฝะธั ะฒััะตััะพััะตะณะพ ะพะฑัะตะบัะฐ;
42 - ะัะตะบัะฐัะตะฝะธะต ัััะตััะฒะพะฒะฐะฝะธั ะฒัะปะตะดััะฒะธะต ะฟัะธัะพะตะดะธะฝะตะฝะธั ะบ ะดััะณะพะผั ะฐะดัะตัะฝะพะผั ะพะฑัะตะบัั;
43 - ะกะพะทะดะฐะฝะธะต ะฝะพะฒะพะณะพ ะฐะดัะตัะฝะพะณะพ ะพะฑัะตะบัะฐ ะฒ ัะตะทัะปััะฐัะต ัะปะธัะฝะธั ะฐะดัะตัะฝัั
ะพะฑัะตะบัะพะฒ;
50 โ ะะตัะตะฟะพะดัะธะฝะตะฝะธะต;
51 โ ะะตัะตะฟะพะดัะธะฝะตะฝะธะต ะฒัะปะตะดััะฒะธะต ะฟะตัะตะฟะพะดัะธะฝะตะฝะธั ะฒััะตััะพััะตะณะพ ะพะฑัะตะบัะฐ;
60 โ ะัะตะบัะฐัะตะฝะธะต ัััะตััะฒะพะฒะฐะฝะธั ะฒัะปะตะดััะฒะธะต ะดัะพะฑะปะตะฝะธั;
61 โ ะกะพะทะดะฐะฝะธะต ะฝะพะฒะพะณะพ ะฐะดัะตัะฝะพะณะพ ะพะฑัะตะบัะฐ ะฒ ัะตะทัะปััะฐัะต ะดัะพะฑะปะตะฝะธั
'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_DEL_ADDROBJ'
,@level2type = N'Column'
,@level2name = N'OPERSTATUS';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ะกัะฐััั ะฐะบััะฐะปัะฝะพััะธ ะะะะะ 4 (ะฟะพัะปะตะดะฝะธะต ะดะฒะต ัะธััั ะฒ ะบะพะดะต)'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_DEL_ADDROBJ'
,@level2type = N'Column'
,@level2name = N'CURRSTATUS';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ะะฐัะฐะปะพ ะดะตะนััะฒะธั ะทะฐะฟะธัะธ'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_DEL_ADDROBJ'
,@level2type = N'Column'
,@level2name = N'STARTDATE';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ะะบะพะฝัะฐะฝะธะต ะดะตะนััะฒะธั ะทะฐะฟะธัะธ'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_DEL_ADDROBJ'
,@level2type = N'Column'
,@level2name = N'ENDDATE';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ะะฝะตัะฝะธะน ะบะปัั ะฝะฐ ะฝะพัะผะฐัะธะฒะฝัะน ะดะพะบัะผะตะฝั'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_DEL_ADDROBJ'
,@level2type = N'Column'
,@level2name = N'NORMDOC';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ะัะธะทะฝะฐะบ ะดะตะนััะฒัััะตะณะพ ะฐะดัะตัะฝะพะณะพ ะพะฑัะตะบัะฐ'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_DEL_ADDROBJ'
,@level2type = N'Column'
,@level2name = N'LIVESTATUS';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ะะพะด ะะคะะก ะคะ'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_DEL_ADDROBJ'
,@level2type = N'Column'
,@level2name = N'IFNSFL';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ะะพะด ัะตััะธัะพัะธะฐะปัะฝะพะณะพ ััะฐััะบะฐ ะะคะะก ะคะ'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_DEL_ADDROBJ'
,@level2type = N'Column'
,@level2name = N'TERRIFNSFL';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ะะพะด ะะคะะก ะฎะ'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_DEL_ADDROBJ'
,@level2type = N'Column'
,@level2name = N'IFNSUL';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ะะพะด ัะตััะธัะพัะธะฐะปัะฝะพะณะพ ััะฐััะบะฐ ะะคะะก ะฎะ'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_DEL_ADDROBJ'
,@level2type = N'Column'
,@level2name = N'TERRIFNSUL';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'OKATO'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_DEL_ADDROBJ'
,@level2type = N'Column'
,@level2name = N'OKATO';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'OKTMO'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_DEL_ADDROBJ'
,@level2type = N'Column'
,@level2name = N'OKTMO';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ะะฐัะฐ ะฒะฝะตัะตะฝะธั ะทะฐะฟะธัะธ'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_DEL_ADDROBJ'
,@level2type = N'Column'
,@level2name = N'UPDATEDATE';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ะะพะด ะะคะะก ะฎะ'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_DEL_HOUSEINT'
,@level2type = N'Column'
,@level2name = N'IFNSUL';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ะะพะด ัะตััะธัะพัะธะฐะปัะฝะพะณะพ ััะฐััะบะฐ ะะคะะก ะฎะ'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_DEL_HOUSEINT'
,@level2type = N'Column'
,@level2name = N'TERRIFNSUL';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'OKATO'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_DEL_HOUSEINT'
,@level2type = N'Column'
,@level2name = N'OKATO';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'OKTMO'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_DEL_HOUSEINT'
,@level2type = N'Column'
,@level2name = N'OKTMO';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ะะฐัะฐ ะฒะฝะตัะตะฝะธั ะทะฐะฟะธัะธ'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_DEL_HOUSEINT'
,@level2type = N'Column'
,@level2name = N'UPDATEDATE';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ะะฝะฐัะตะฝะธะต ะฝะฐัะฐะปะฐ ะธะฝัะตัะฒะฐะปะฐ'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_DEL_HOUSEINT'
,@level2type = N'Column'
,@level2name = N'INTSTART';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ะะฝะฐัะตะฝะธะต ะพะบะพะฝัะฐะฝะธั ะธะฝัะตัะฒะฐะปะฐ'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_DEL_HOUSEINT'
,@level2type = N'Column'
,@level2name = N'INTEND';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ะะพััะพะฒัะน ะธะฝะดะตะบั'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_DEL_HOUSEINT'
,@level2type = N'Column'
,@level2name = N'POSTALCODE';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ะะพะด ะะคะะก ะคะ'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_DEL_HOUSEINT'
,@level2type = N'Column'
,@level2name = N'IFNSFL';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ะะพะด ัะตััะธัะพัะธะฐะปัะฝะพะณะพ ััะฐััะบะฐ ะะคะะก ะคะ'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_DEL_HOUSEINT'
,@level2type = N'Column'
,@level2name = N'TERRIFNSFL';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ะะดะตะฝัะธัะธะบะฐัะพั ะทะฐะฟะธัะธ ะธะฝัะตัะฒะฐะปะฐ ะดะพะผะพะฒ'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_DEL_HOUSEINT'
,@level2type = N'Column'
,@level2name = N'HOUSEINTID';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ะะปะพะฑะฐะปัะฝัะน ัะฝะธะบะฐะปัะฝัะน ะธะดะตะฝัะธัะธะบะฐัะพั ะธะฝัะตัะฒะฐะปะฐ ะดะพะผะพะฒ'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_DEL_HOUSEINT'
,@level2type = N'Column'
,@level2name = N'INTGUID';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ะะดะตะฝัะธัะธะบะฐัะพั ะพะฑัะตะบัะฐ ัะพะดะธัะตะปััะบะพะณะพ ะพะฑัะตะบัะฐ (ัะปะธัั, ะณะพัะพะดะฐ, ะฝะฐัะตะปะตะฝะฝะพะณะพ ะฟัะฝะบัะฐ ะธ ั.ะฟ.)'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_DEL_HOUSEINT'
,@level2type = N'Column'
,@level2name = N'AOGUID';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ะะฐัะฐะปะพ ะดะตะนััะฒะธั ะทะฐะฟะธัะธ'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_DEL_HOUSEINT'
,@level2type = N'Column'
,@level2name = N'STARTDATE';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ะะบะพะฝัะฐะฝะธะต ะดะตะนััะฒะธั ะทะฐะฟะธัะธ'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_DEL_HOUSEINT'
,@level2type = N'Column'
,@level2name = N'ENDDATE';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ะกัะฐััั ะธะฝัะตัะฒะฐะปะฐ (ะพะฑััะฝัะน, ัะตัะฝัะน, ะฝะตัะตัะฝัะน)'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_DEL_HOUSEINT'
,@level2type = N'Column'
,@level2name = N'INTSTATUS';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ะะฝะตัะฝะธะน ะบะปัั ะฝะฐ ะฝะพัะผะฐัะธะฒะฝัะน ะดะพะบัะผะตะฝั'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_DEL_HOUSEINT'
,@level2type = N'Column'
,@level2name = N'NORMDOC';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ะกัะตััะธะบ ะทะฐะฟะธัะตะน ะดะพะผะพะฒ ะดะปั ะะะะะ 4'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_DEL_HOUSEINT'
,@level2type = N'Column'
,@level2name = N'COUNTER';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ะะดะตะฝัะธัะธะบะฐัะพั ะฝะพัะผะฐัะธะฒะฝะพะณะพ ะดะพะบัะผะตะฝัะฐ'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_DEL_NORMDOC'
,@level2type = N'Column'
,@level2name = N'NORMDOCID';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ะะฐะธะผะตะฝะพะฒะฐะฝะธะต ะดะพะบัะผะตะฝัะฐ'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_DEL_NORMDOC'
,@level2type = N'Column'
,@level2name = N'DOCNAME';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ะะฐัะฐ ะดะพะบัะผะตะฝัะฐ'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_DEL_NORMDOC'
,@level2type = N'Column'
,@level2name = N'DOCDATE';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ะะพะผะตั ะดะพะบัะผะตะฝัะฐ'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_DEL_NORMDOC'
,@level2type = N'Column'
,@level2name = N'DOCNUM';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ะขะธะฟ ะดะพะบัะผะตะฝัะฐ'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_DEL_NORMDOC'
,@level2type = N'Column'
,@level2name = N'DOCTYPE';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ะะดะตะฝัะธัะธะบะฐัะพั ะพะฑัะฐะทะฐ (ะฒะฝะตัะฝะธะน ะบะปัั)'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_DEL_NORMDOC'
,@level2type = N'Column'
,@level2name = N'DOCIMGID';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'OKTMO'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_HOUSEINT'
,@level2type = N'Column'
,@level2name = N'OKTMO';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'OKATO'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_HOUSEINT'
,@level2type = N'Column'
,@level2name = N'OKATO';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ะะพะด ะะคะะก ะฎะ'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_HOUSEINT'
,@level2type = N'Column'
,@level2name = N'IFNSUL';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ะะพะด ัะตััะธัะพัะธะฐะปัะฝะพะณะพ ััะฐััะบะฐ ะะคะะก ะฎะ'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_HOUSEINT'
,@level2type = N'Column'
,@level2name = N'TERRIFNSUL';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ะะพะด ัะตััะธัะพัะธะฐะปัะฝะพะณะพ ััะฐััะบะฐ ะะคะะก ะคะ'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_HOUSEINT'
,@level2type = N'Column'
,@level2name = N'TERRIFNSFL';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ะะพััะพะฒัะน ะธะฝะดะตะบั'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_HOUSEINT'
,@level2type = N'Column'
,@level2name = N'POSTALCODE';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ะะพะด ะะคะะก ะคะ'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_HOUSEINT'
,@level2type = N'Column'
,@level2name = N'IFNSFL';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ะะบะพะฝัะฐะฝะธะต ะดะตะนััะฒะธั ะทะฐะฟะธัะธ'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_HOUSEINT'
,@level2type = N'Column'
,@level2name = N'ENDDATE';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ะกัะฐััั ะธะฝัะตัะฒะฐะปะฐ (ะพะฑััะฝัะน, ัะตัะฝัะน, ะฝะตัะตัะฝัะน)'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_HOUSEINT'
,@level2type = N'Column'
,@level2name = N'INTSTATUS';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ะะดะตะฝัะธัะธะบะฐัะพั ะพะฑัะตะบัะฐ ัะพะดะธัะตะปััะบะพะณะพ ะพะฑัะตะบัะฐ (ัะปะธัั, ะณะพัะพะดะฐ, ะฝะฐัะตะปะตะฝะฝะพะณะพ ะฟัะฝะบัะฐ ะธ ั.ะฟ.)'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_HOUSEINT'
,@level2type = N'Column'
,@level2name = N'AOGUID';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ะะฐัะฐะปะพ ะดะตะนััะฒะธั ะทะฐะฟะธัะธ'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_HOUSEINT'
,@level2type = N'Column'
,@level2name = N'STARTDATE';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ะะปะพะฑะฐะปัะฝัะน ัะฝะธะบะฐะปัะฝัะน ะธะดะตะฝัะธัะธะบะฐัะพั ะธะฝัะตัะฒะฐะปะฐ ะดะพะผะพะฒ'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_HOUSEINT'
,@level2type = N'Column'
,@level2name = N'INTGUID';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ะะดะตะฝัะธัะธะบะฐัะพั ะทะฐะฟะธัะธ ะธะฝัะตัะฒะฐะปะฐ ะดะพะผะพะฒ'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_HOUSEINT'
,@level2type = N'Column'
,@level2name = N'HOUSEINTID';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ะะฝะฐัะตะฝะธะต ะฝะฐัะฐะปะฐ ะธะฝัะตัะฒะฐะปะฐ'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_HOUSEINT'
,@level2type = N'Column'
,@level2name = N'INTSTART';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ะะฝะฐัะตะฝะธะต ะพะบะพะฝัะฐะฝะธั ะธะฝัะตัะฒะฐะปะฐ'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_HOUSEINT'
,@level2type = N'Column'
,@level2name = N'INTEND';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ะะฐัะฐ ะฒะฝะตัะตะฝะธั ะทะฐะฟะธัะธ'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_HOUSEINT'
,@level2type = N'Column'
,@level2name = N'UPDATEDATE';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ะะฝะตัะฝะธะน ะบะปัั ะฝะฐ ะฝะพัะผะฐัะธะฒะฝัะน ะดะพะบัะผะตะฝั'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_HOUSEINT'
,@level2type = N'Column'
,@level2name = N'NORMDOC';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ะกัะตััะธะบ ะทะฐะฟะธัะตะน ะดะพะผะพะฒ ะดะปั ะะะะะ 4'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_HOUSEINT'
,@level2type = N'Column'
,@level2name = N'COUNTER';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ะะดะตะฝัะธัะธะบะฐัะพั ััะฐัััะฐ (ะพะฑััะฝัะน, ัะตัะฝัะน, ะฝะตัะตัะฝัะน)'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_INTVSTAT'
,@level2type = N'Column'
,@level2name = N'INTVSTATID';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ะะฐะธะผะตะฝะพะฒะฐะฝะธะต'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_INTVSTAT'
,@level2type = N'Column'
,@level2name = N'NAME';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ะะฝะตัะฝะธะน ะบะปัั ะฝะฐ ะฝะพัะผะฐัะธะฒะฝัะน ะดะพะบัะผะตะฝั'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_LANDMARK'
,@level2type = N'Column'
,@level2name = N'NORMDOC';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ะะฐัะฐะปะพ ะดะตะนััะฒะธั ะทะฐะฟะธัะธ'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_LANDMARK'
,@level2type = N'Column'
,@level2name = N'STARTDATE';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ะะบะพะฝัะฐะฝะธะต ะดะตะนััะฒะธั ะทะฐะฟะธัะธ'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_LANDMARK'
,@level2type = N'Column'
,@level2name = N'ENDDATE';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ะะปะพะฑะฐะปัะฝัะน ัะฝะธะบะฐะปัะฝัะน ะธะดะตะฝัะธัะธะบะฐัะพั ะพัะธะตะฝัะธัะฐ'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_LANDMARK'
,@level2type = N'Column'
,@level2name = N'LANDGUID';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ะฃะฝะธะบะฐะปัะฝัะน ะธะดะตะฝัะธัะธะบะฐัะพั ัะพะดะธัะตะปััะบะพะณะพ ะพะฑัะตะบัะฐ (ัะปะธัั, ะณะพัะพะดะฐ, ะฝะฐัะตะปะตะฝะฝะพะณะพ ะฟัะฝะบัะฐ ะธ ั.ะฟ.)'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_LANDMARK'
,@level2type = N'Column'
,@level2name = N'AOGUID';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ะฃะฝะธะบะฐะปัะฝัะน ะธะดะตะฝัะธัะธะบะฐัะพั ะทะฐะฟะธัะธ ะพัะธะตะฝัะธัะฐ'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_LANDMARK'
,@level2type = N'Column'
,@level2name = N'LANDID';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ะะตััะพัะฐัะฟะพะปะพะถะตะฝะธะต ะพัะธะตะฝัะธัะฐ'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_LANDMARK'
,@level2type = N'Column'
,@level2name = N'LOCATION';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ะะพััะพะฒัะน ะธะฝะดะตะบั'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_LANDMARK'
,@level2type = N'Column'
,@level2name = N'POSTALCODE';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ะะพะด ัะตััะธัะพัะธะฐะปัะฝะพะณะพ ััะฐััะบะฐ ะะคะะก ะคะ'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_LANDMARK'
,@level2type = N'Column'
,@level2name = N'TERRIFNSFL';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ะะพะด ะะคะะก ะคะ'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_LANDMARK'
,@level2type = N'Column'
,@level2name = N'IFNSFL';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ะะฐัะฐ ะฒะฝะตัะตะฝะธั ะทะฐะฟะธัะธ'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_LANDMARK'
,@level2type = N'Column'
,@level2name = N'UPDATEDATE';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'OKTMO'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_LANDMARK'
,@level2type = N'Column'
,@level2name = N'OKTMO';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'OKATO'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_LANDMARK'
,@level2type = N'Column'
,@level2name = N'OKATO';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ะะพะด ะะคะะก ะฎะ'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_LANDMARK'
,@level2type = N'Column'
,@level2name = N'IFNSUL';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ะะพะด ัะตััะธัะพัะธะฐะปัะฝะพะณะพ ััะฐััะบะฐ ะะคะะก ะฎะ'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_LANDMARK'
,@level2type = N'Column'
,@level2name = N'TERRIFNSUL';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ะะดะตะฝัะธัะธะบะฐัะพั ะฝะพัะผะฐัะธะฒะฝะพะณะพ ะดะพะบัะผะตะฝัะฐ'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_NORMDOC'
,@level2type = N'Column'
,@level2name = N'NORMDOCID';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ะะฐะธะผะตะฝะพะฒะฐะฝะธะต ะดะพะบัะผะตะฝัะฐ'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_NORMDOC'
,@level2type = N'Column'
,@level2name = N'DOCNAME';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ะะฐัะฐ ะดะพะบัะผะตะฝัะฐ'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_NORMDOC'
,@level2type = N'Column'
,@level2name = N'DOCDATE';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ะะพะผะตั ะดะพะบัะผะตะฝัะฐ'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_NORMDOC'
,@level2type = N'Column'
,@level2name = N'DOCNUM';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ะขะธะฟ ะดะพะบัะผะตะฝัะฐ'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_NORMDOC'
,@level2type = N'Column'
,@level2name = N'DOCTYPE';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ะะดะตะฝัะธัะธะบะฐัะพั ะพะฑัะฐะทะฐ (ะฒะฝะตัะฝะธะน ะบะปัั)'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_NORMDOC'
,@level2type = N'Column'
,@level2name = N'DOCIMGID';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ะัะฐัะบะพะต ะฝะฐะธะผะตะฝะพะฒะฐะฝะธะต'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_ROOMTYPE'
,@level2type = N'Column'
,@level2name = N'SHORTNAME';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ะะฐะธะผะตะฝะพะฒะฐะฝะธะต'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_ROOMTYPE'
,@level2type = N'Column'
,@level2name = N'NAME';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ะขะธะฟ ะบะพะผะฝะฐัั'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_ROOMTYPE'
,@level2type = N'Column'
,@level2name = N'RMTYPEID';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ะฃัะพะฒะตะฝั ะฐะดัะตัะฝะพะณะพ ะพะฑัะตะบัะฐ'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_SOCRBASE'
,@level2type = N'Column'
,@level2name = N'LEVEL';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ะัะฐัะบะพะต ะฝะฐะธะผะตะฝะพะฒะฐะฝะธะต ัะธะฟะฐ ะพะฑัะตะบัะฐ'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_SOCRBASE'
,@level2type = N'Column'
,@level2name = N'SCNAME';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ะะพะปะฝะพะต ะฝะฐะธะผะตะฝะพะฒะฐะฝะธะต ัะธะฟะฐ ะพะฑัะตะบัะฐ'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_SOCRBASE'
,@level2type = N'Column'
,@level2name = N'SOCRNAME';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ะะปััะตะฒะพะต ะฟะพะปะต'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_SOCRBASE'
,@level2type = N'Column'
,@level2name = N'KOD_T_ST';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ะะฐะธะผะตะฝะพะฒะฐะฝะธะต
0 โ ะะต ะฐะบััะฐะปัะฝัะน
1 โ ะะบััะฐะปัะฝัะน (ะฟะพัะปะตะดะฝัั ะทะฐะฟะธัั ะฟะพ ะฐะดัะตัะฝะพะผั ะพะฑัะตะบัั)
'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_ACTSTAT'
,@level2type = N'Column'
,@level2name = N'NAME';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ะะดะตะฝัะธัะธะบะฐัะพั ััะฐัััะฐ (ะบะปัั)'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_ACTSTAT'
,@level2type = N'Column'
,@level2name = N'ACTSTATID';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ะะดะตะฝัะธัะธะบะฐัะพั ััะฐัััะฐ'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_CENTERST'
,@level2type = N'Column'
,@level2name = N'CENTERSTID';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ะะฐะธะผะตะฝะพะฒะฐะฝะธะต'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_CENTERST'
,@level2type = N'Column'
,@level2name = N'NAME';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ะะพััะพะฒัะน ะธะฝะดะตะบั'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_DEL_HOUSE'
,@level2type = N'Column'
,@level2name = N'POSTALCODE';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ะะพะด ะะคะะก ะคะ'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_DEL_HOUSE'
,@level2type = N'Column'
,@level2name = N'IFNSFL';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ะะพะด ัะตััะธัะพัะธะฐะปัะฝะพะณะพ ััะฐััะบะฐ ะะคะะก ะคะ'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_DEL_HOUSE'
,@level2type = N'Column'
,@level2name = N'TERRIFNSFL';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ะะพะด ะะคะะก ะฎะ'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_DEL_HOUSE'
,@level2type = N'Column'
,@level2name = N'IFNSUL';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ะะพะด ัะตััะธัะพัะธะฐะปัะฝะพะณะพ ััะฐััะบะฐ ะะคะะก ะฎะ'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_DEL_HOUSE'
,@level2type = N'Column'
,@level2name = N'TERRIFNSUL';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'OKATO'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_DEL_HOUSE'
,@level2type = N'Column'
,@level2name = N'OKATO';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'OKTMO'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_DEL_HOUSE'
,@level2type = N'Column'
,@level2name = N'OKTMO';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ะะฐัะฐ ะฒัะตะผั ะฒะฝะตัะตะฝะธั ะทะฐะฟะธัะธ'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_DEL_HOUSE'
,@level2type = N'Column'
,@level2name = N'UPDATEDATE';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ะะพะผะตั ะดะพะผะฐ'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_DEL_HOUSE'
,@level2type = N'Column'
,@level2name = N'HOUSENUM';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ะัะธะทะฝะฐะบ ะฒะปะฐะดะตะฝะธั'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_DEL_HOUSE'
,@level2type = N'Column'
,@level2name = N'ESTSTATUS';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ะะพะผะตั ะบะพัะฟััะฐ'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_DEL_HOUSE'
,@level2type = N'Column'
,@level2name = N'BUILDNUM';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ะะพะผะตั ัััะพะตะฝะธั'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_DEL_HOUSE'
,@level2type = N'Column'
,@level2name = N'STRUCNUM';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ะัะธะทะฝะฐะบ ัััะพะตะฝะธั'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_DEL_HOUSE'
,@level2type = N'Column'
,@level2name = N'STRSTATUS';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ะฃะฝะธะบะฐะปัะฝัะน ะธะดะตะฝัะธัะธะบะฐัะพั ะทะฐะฟะธัะธ ะดะพะผะฐ'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_DEL_HOUSE'
,@level2type = N'Column'
,@level2name = N'HOUSEID';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ะะปะพะฑะฐะปัะฝัะน ัะฝะธะบะฐะปัะฝัะน ะธะดะตะฝัะธัะธะบะฐัะพั ะดะพะผะฐ'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_DEL_HOUSE'
,@level2type = N'Column'
,@level2name = N'HOUSEGUID';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'Guid ะทะฐะฟะธัะธ ัะพะดะธัะตะปััะบะพะณะพ ะพะฑัะตะบัะฐ (ัะปะธัั, ะณะพัะพะดะฐ, ะฝะฐัะตะปะตะฝะฝะพะณะพ ะฟัะฝะบัะฐ ะธ ั.ะฟ.)'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_DEL_HOUSE'
,@level2type = N'Column'
,@level2name = N'AOGUID';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ะะฐัะฐะปะพ ะดะตะนััะฒะธั ะทะฐะฟะธัะธ'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_DEL_HOUSE'
,@level2type = N'Column'
,@level2name = N'STARTDATE';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ะะบะพะฝัะฐะฝะธะต ะดะตะนััะฒะธั ะทะฐะฟะธัะธ'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_DEL_HOUSE'
,@level2type = N'Column'
,@level2name = N'ENDDATE';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ะกะพััะพัะฝะธะต ะดะพะผะฐ'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_DEL_HOUSE'
,@level2type = N'Column'
,@level2name = N'STATSTATUS';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ะะฝะตัะฝะธะน ะบะปัั ะฝะฐ ะฝะพัะผะฐัะธะฒะฝัะน ะดะพะบัะผะตะฝั'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_DEL_HOUSE'
,@level2type = N'Column'
,@level2name = N'NORMDOC';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ะกัะตััะธะบ ะทะฐะฟะธัะตะน ะดะพะผะพะฒ ะดะปั ะะะะะ 4'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_DEL_HOUSE'
,@level2type = N'Column'
,@level2name = N'COUNTER';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ะะฐะดะฐัััะพะฒัะน ะฝะพะผะตั'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_DEL_HOUSE'
,@level2type = N'Column'
,@level2name = N'CADNUM';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ะขะธะฟ ะฐะดัะตัะฐัะธะธ:
0 - ะฝะต ะพะฟัะตะดะตะปะตะฝะพ
1 - ะผัะฝะธัะธะฟะฐะปัะฝัะน;
2 - ะฐะดะผะธะฝะธัััะฐัะธะฒะฝะพ-ัะตััะธัะพัะธะฐะปัะฝัะน'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_DEL_HOUSE'
,@level2type = N'Column'
,@level2name = N'DIVTYPE';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ะัะธะทะฝะฐะบ ะฒะปะฐะดะตะฝะธั'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_ESTSTAT'
,@level2type = N'Column'
,@level2name = N'ESTSTATID';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ะะฐะธะผะตะฝะพะฒะฐะฝะธะต'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_ESTSTAT'
,@level2type = N'Column'
,@level2name = N'NAME';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ะัะฐัะบะพะต ะฝะฐะธะผะตะฝะพะฒะฐะฝะธะต'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_ESTSTAT'
,@level2type = N'Column'
,@level2name = N'SHORTNAME';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ะะปะพะฑะฐะปัะฝัะน ัะฝะธะบะฐะปัะฝัะน ะธะดะตะฝัะธัะธะบะฐัะพั ะฐะดัะตัะฝะพะณะพ ะพะฑัะตะบัะฐ (ะทะตะผะตะปัะฝะพะณะพ ััะฐััะบะฐ)'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_STEAD'
,@level2type = N'Column'
,@level2name = N'STEADGUID';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ะะพะผะตั ะทะตะผะตะปัะฝะพะณะพ ััะฐััะบะฐ'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_STEAD'
,@level2type = N'Column'
,@level2name = N'NUMBER';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ะะพะด ัะตะณะธะพะฝะฐ'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_STEAD'
,@level2type = N'Column'
,@level2name = N'REGIONCODE';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ะะพััะพะฒัะน ะธะฝะดะตะบั'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_STEAD'
,@level2type = N'Column'
,@level2name = N'POSTALCODE';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ะะพะด ะะคะะก ะคะ'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_STEAD'
,@level2type = N'Column'
,@level2name = N'IFNSFL';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ะะพะด ัะตััะธัะพัะธะฐะปัะฝะพะณะพ ััะฐััะบะฐ ะะคะะก ะคะ'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_STEAD'
,@level2type = N'Column'
,@level2name = N'TERRIFNSFL';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ะะพะด ะะคะะก ะฎะ'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_STEAD'
,@level2type = N'Column'
,@level2name = N'IFNSUL';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ะะพะด ัะตััะธัะพัะธะฐะปัะฝะพะณะพ ััะฐััะบะฐ ะะคะะก ะฎะ'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_STEAD'
,@level2type = N'Column'
,@level2name = N'TERRIFNSUL';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'OKATO'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_STEAD'
,@level2type = N'Column'
,@level2name = N'OKATO';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'OKTMO'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_STEAD'
,@level2type = N'Column'
,@level2name = N'OKTMO';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ะะฐัะฐ ะฒะฝะตัะตะฝะธั ะทะฐะฟะธัะธ'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_STEAD'
,@level2type = N'Column'
,@level2name = N'UPDATEDATE';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ะะดะตะฝัะธัะธะบะฐัะพั ะพะฑัะตะบัะฐ ัะพะดะธัะตะปััะบะพะณะพ ะพะฑัะตะบัะฐ'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_STEAD'
,@level2type = N'Column'
,@level2name = N'PARENTGUID';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ะฃะฝะธะบะฐะปัะฝัะน ะธะดะตะฝัะธัะธะบะฐัะพั ะทะฐะฟะธัะธ. ะะปััะตะฒะพะต ะฟะพะปะต.'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_STEAD'
,@level2type = N'Column'
,@level2name = N'STEADID';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ะะดะตะฝัะธัะธะบะฐัะพั ะทะฐะฟะธัะธ ัะฒัะทัะฒะฐะฝะธั ั ะฟัะตะดัะดััะตะน ะธััะพัะธัะตัะบะพะน ะทะฐะฟะธััั'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_STEAD'
,@level2type = N'Column'
,@level2name = N'PREVID';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ะะดะตะฝัะธัะธะบะฐัะพั ะทะฐะฟะธัะธ ัะฒัะทัะฒะฐะฝะธั ั ะฟะพัะปะตะดัััะตะน ะธััะพัะธัะตัะบะพะน ะทะฐะฟะธััั'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_STEAD'
,@level2type = N'Column'
,@level2name = N'NEXTID';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ะกัะฐััั ะดะตะนััะฒะธั ะฝะฐะด ะทะฐะฟะธััั โ ะฟัะธัะธะฝะฐ ะฟะพัะฒะปะตะฝะธั ะทะฐะฟะธัะธ (ัะผ. ะพะฟะธัะฐะฝะธะต ัะฐะฑะปะธัั OperationStatus):
01 โ ะะฝะธัะธะฐัะธั;
10 โ ะะพะฑะฐะฒะปะตะฝะธะต;
20 โ ะะทะผะตะฝะตะฝะธะต;
21 โ ะััะฟะฟะพะฒะพะต ะธะทะผะตะฝะตะฝะธะต;
30 โ ะฃะดะฐะปะตะฝะธะต;
31 - ะฃะดะฐะปะตะฝะธะต ะฒัะปะตะดััะฒะธะต ัะดะฐะปะตะฝะธั ะฒััะตััะพััะตะณะพ ะพะฑัะตะบัะฐ;
40 โ ะัะธัะพะตะดะธะฝะตะฝะธะต ะฐะดัะตัะฝะพะณะพ ะพะฑัะตะบัะฐ (ัะปะธัะฝะธะต);
41 โ ะะตัะตะฟะพะดัะธะฝะตะฝะธะต ะฒัะปะตะดััะฒะธะต ัะปะธัะฝะธั ะฒััะตััะพััะตะณะพ ะพะฑัะตะบัะฐ;
42 - ะัะตะบัะฐัะตะฝะธะต ัััะตััะฒะพะฒะฐะฝะธั ะฒัะปะตะดััะฒะธะต ะฟัะธัะพะตะดะธะฝะตะฝะธั ะบ ะดััะณะพะผั ะฐะดัะตัะฝะพะผั ะพะฑัะตะบัั;
43 - ะกะพะทะดะฐะฝะธะต ะฝะพะฒะพะณะพ ะฐะดัะตัะฝะพะณะพ ะพะฑัะตะบัะฐ ะฒ ัะตะทัะปััะฐัะต ัะปะธัะฝะธั ะฐะดัะตัะฝัั
ะพะฑัะตะบัะพะฒ;
50 โ ะะตัะตะฟะพะดัะธะฝะตะฝะธะต;
51 โ ะะตัะตะฟะพะดัะธะฝะตะฝะธะต ะฒัะปะตะดััะฒะธะต ะฟะตัะตะฟะพะดัะธะฝะตะฝะธั ะฒััะตััะพััะตะณะพ ะพะฑัะตะบัะฐ;
60 โ ะัะตะบัะฐัะตะฝะธะต ัััะตััะฒะพะฒะฐะฝะธั ะฒัะปะตะดััะฒะธะต ะดัะพะฑะปะตะฝะธั;
61 โ ะกะพะทะดะฐะฝะธะต ะฝะพะฒะพะณะพ ะฐะดัะตัะฝะพะณะพ ะพะฑัะตะบัะฐ ะฒ ัะตะทัะปััะฐัะต ะดัะพะฑะปะตะฝะธั
'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_STEAD'
,@level2type = N'Column'
,@level2name = N'OPERSTATUS';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ะะฐัะฐะปะพ ะดะตะนััะฒะธั ะทะฐะฟะธัะธ'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_STEAD'
,@level2type = N'Column'
,@level2name = N'STARTDATE';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ะะบะพะฝัะฐะฝะธะต ะดะตะนััะฒะธั ะทะฐะฟะธัะธ'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_STEAD'
,@level2type = N'Column'
,@level2name = N'ENDDATE';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ะะฝะตัะฝะธะน ะบะปัั ะฝะฐ ะฝะพัะผะฐัะธะฒะฝัะน ะดะพะบัะผะตะฝั'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_STEAD'
,@level2type = N'Column'
,@level2name = N'NORMDOC';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ะัะธะทะฝะฐะบ ะดะตะนััะฒัััะตะณะพ ะฐะดัะตัะฝะพะณะพ ะพะฑัะตะบัะฐ'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_STEAD'
,@level2type = N'Column'
,@level2name = N'LIVESTATUS';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ะะฐะดะฐัััะพะฒัะน ะฝะพะผะตั'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_STEAD'
,@level2type = N'Column'
,@level2name = N'CADNUM';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ะขะธะฟ ะฐะดัะตัะฐัะธะธ:
0 - ะฝะต ะพะฟัะตะดะตะปะตะฝะพ
1 - ะผัะฝะธัะธะฟะฐะปัะฝัะน;
2 - ะฐะดะผะธะฝะธัััะฐัะธะฒะฝะพ-ัะตััะธัะพัะธะฐะปัะฝัะน'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_STEAD'
,@level2type = N'Column'
,@level2name = N'DIVTYPE';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ะะตััะพัะฐัะฟะพะปะพะถะตะฝะธะต ะพัะธะตะฝัะธัะฐ'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_DEL_LANDMARK'
,@level2type = N'Column'
,@level2name = N'LOCATION';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ะะพััะพะฒัะน ะธะฝะดะตะบั'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_DEL_LANDMARK'
,@level2type = N'Column'
,@level2name = N'POSTALCODE';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ะะพะด ะะคะะก ะคะ'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_DEL_LANDMARK'
,@level2type = N'Column'
,@level2name = N'IFNSFL';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ะะพะด ัะตััะธัะพัะธะฐะปัะฝะพะณะพ ััะฐััะบะฐ ะะคะะก ะคะ'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_DEL_LANDMARK'
,@level2type = N'Column'
,@level2name = N'TERRIFNSFL';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ะะพะด ะะคะะก ะฎะ'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_DEL_LANDMARK'
,@level2type = N'Column'
,@level2name = N'IFNSUL';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ะะพะด ัะตััะธัะพัะธะฐะปัะฝะพะณะพ ััะฐััะบะฐ ะะคะะก ะฎะ'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_DEL_LANDMARK'
,@level2type = N'Column'
,@level2name = N'TERRIFNSUL';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'OKATO'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_DEL_LANDMARK'
,@level2type = N'Column'
,@level2name = N'OKATO';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'OKTMO'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_DEL_LANDMARK'
,@level2type = N'Column'
,@level2name = N'OKTMO';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ะะฐัะฐ ะฒะฝะตัะตะฝะธั ะทะฐะฟะธัะธ'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_DEL_LANDMARK'
,@level2type = N'Column'
,@level2name = N'UPDATEDATE';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ะฃะฝะธะบะฐะปัะฝัะน ะธะดะตะฝัะธัะธะบะฐัะพั ะทะฐะฟะธัะธ ะพัะธะตะฝัะธัะฐ'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_DEL_LANDMARK'
,@level2type = N'Column'
,@level2name = N'LANDID';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ะะปะพะฑะฐะปัะฝัะน ัะฝะธะบะฐะปัะฝัะน ะธะดะตะฝัะธัะธะบะฐัะพั ะพัะธะตะฝัะธัะฐ'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_DEL_LANDMARK'
,@level2type = N'Column'
,@level2name = N'LANDGUID';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ะฃะฝะธะบะฐะปัะฝัะน ะธะดะตะฝัะธัะธะบะฐัะพั ัะพะดะธัะตะปััะบะพะณะพ ะพะฑัะตะบัะฐ (ัะปะธัั, ะณะพัะพะดะฐ, ะฝะฐัะตะปะตะฝะฝะพะณะพ ะฟัะฝะบัะฐ ะธ ั.ะฟ.)'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_DEL_LANDMARK'
,@level2type = N'Column'
,@level2name = N'AOGUID';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ะะฐัะฐะปะพ ะดะตะนััะฒะธั ะทะฐะฟะธัะธ'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_DEL_LANDMARK'
,@level2type = N'Column'
,@level2name = N'STARTDATE';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ะะบะพะฝัะฐะฝะธะต ะดะตะนััะฒะธั ะทะฐะฟะธัะธ'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_DEL_LANDMARK'
,@level2type = N'Column'
,@level2name = N'ENDDATE';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ะะฝะตัะฝะธะน ะบะปัั ะฝะฐ ะฝะพัะผะฐัะธะฒะฝัะน ะดะพะบัะผะตะฝั'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_DEL_LANDMARK'
,@level2type = N'Column'
,@level2name = N'NORMDOC';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ะะพััะพะฒัะน ะธะฝะดะตะบั'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_HOUSE'
,@level2type = N'Column'
,@level2name = N'POSTALCODE';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ะะพะด ัะตะณะธะพะฝะฐ'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_HOUSE'
,@level2type = N'Column'
,@level2name = N'REGIONCODE';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ะะพะด ะะคะะก ะคะ'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_HOUSE'
,@level2type = N'Column'
,@level2name = N'IFNSFL';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ะะพะด ัะตััะธัะพัะธะฐะปัะฝะพะณะพ ััะฐััะบะฐ ะะคะะก ะคะ'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_HOUSE'
,@level2type = N'Column'
,@level2name = N'TERRIFNSFL';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ะะพะด ะะคะะก ะฎะ'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_HOUSE'
,@level2type = N'Column'
,@level2name = N'IFNSUL';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ะะพะด ัะตััะธัะพัะธะฐะปัะฝะพะณะพ ััะฐััะบะฐ ะะคะะก ะฎะ'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_HOUSE'
,@level2type = N'Column'
,@level2name = N'TERRIFNSUL';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'OKATO'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_HOUSE'
,@level2type = N'Column'
,@level2name = N'OKATO';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'OKTMO'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_HOUSE'
,@level2type = N'Column'
,@level2name = N'OKTMO';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ะะฐัะฐ ะฒัะตะผั ะฒะฝะตัะตะฝะธั ะทะฐะฟะธัะธ'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_HOUSE'
,@level2type = N'Column'
,@level2name = N'UPDATEDATE';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ะะพะผะตั ะดะพะผะฐ'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_HOUSE'
,@level2type = N'Column'
,@level2name = N'HOUSENUM';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ะัะธะทะฝะฐะบ ะฒะปะฐะดะตะฝะธั'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_HOUSE'
,@level2type = N'Column'
,@level2name = N'ESTSTATUS';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ะะพะผะตั ะบะพัะฟััะฐ'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_HOUSE'
,@level2type = N'Column'
,@level2name = N'BUILDNUM';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ะะพะผะตั ัััะพะตะฝะธั'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_HOUSE'
,@level2type = N'Column'
,@level2name = N'STRUCNUM';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ะัะธะทะฝะฐะบ ัััะพะตะฝะธั'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_HOUSE'
,@level2type = N'Column'
,@level2name = N'STRSTATUS';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ะฃะฝะธะบะฐะปัะฝัะน ะธะดะตะฝัะธัะธะบะฐัะพั ะทะฐะฟะธัะธ ะดะพะผะฐ'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_HOUSE'
,@level2type = N'Column'
,@level2name = N'HOUSEID';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ะะปะพะฑะฐะปัะฝัะน ัะฝะธะบะฐะปัะฝัะน ะธะดะตะฝัะธัะธะบะฐัะพั ะดะพะผะฐ'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_HOUSE'
,@level2type = N'Column'
,@level2name = N'HOUSEGUID';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'Guid ะทะฐะฟะธัะธ ัะพะดะธัะตะปััะบะพะณะพ ะพะฑัะตะบัะฐ (ัะปะธัั, ะณะพัะพะดะฐ, ะฝะฐัะตะปะตะฝะฝะพะณะพ ะฟัะฝะบัะฐ ะธ ั.ะฟ.)'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_HOUSE'
,@level2type = N'Column'
,@level2name = N'AOGUID';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ะะฐัะฐะปะพ ะดะตะนััะฒะธั ะทะฐะฟะธัะธ'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_HOUSE'
,@level2type = N'Column'
,@level2name = N'STARTDATE';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ะะบะพะฝัะฐะฝะธะต ะดะตะนััะฒะธั ะทะฐะฟะธัะธ'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_HOUSE'
,@level2type = N'Column'
,@level2name = N'ENDDATE';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ะกะพััะพัะฝะธะต ะดะพะผะฐ'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_HOUSE'
,@level2type = N'Column'
,@level2name = N'STATSTATUS';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ะะฝะตัะฝะธะน ะบะปัั ะฝะฐ ะฝะพัะผะฐัะธะฒะฝัะน ะดะพะบัะผะตะฝั'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_HOUSE'
,@level2type = N'Column'
,@level2name = N'NORMDOC';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ะกัะตััะธะบ ะทะฐะฟะธัะตะน ะดะพะผะพะฒ ะดะปั ะะะะะ 4'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_HOUSE'
,@level2type = N'Column'
,@level2name = N'COUNTER';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ะะฐะดะฐัััะพะฒัะน ะฝะพะผะตั'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_HOUSE'
,@level2type = N'Column'
,@level2name = N'CADNUM';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ะขะธะฟ ะฐะดัะตัะฐัะธะธ:
0 - ะฝะต ะพะฟัะตะดะตะปะตะฝะพ
1 - ะผัะฝะธัะธะฟะฐะปัะฝัะน;
2 - ะฐะดะผะธะฝะธัััะฐัะธะฒะฝะพ-ัะตััะธัะพัะธะฐะปัะฝัะน'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_HOUSE'
,@level2type = N'Column'
,@level2name = N'DIVTYPE';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ะะปะพะฑะฐะปัะฝัะน ัะฝะธะบะฐะปัะฝัะน ะธะดะตะฝัะธัะธะบะฐัะพั ะฐะดัะตัะฝะพะณะพ ะพะฑัะตะบัะฐ (ะฟะพะผะตัะตะฝะธั)'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_ROOM'
,@level2type = N'Column'
,@level2name = N'ROOMGUID';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ะะพะผะตั ะฟะพะผะตัะตะฝะธั ะธะปะธ ะพัะธัะฐ'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_ROOM'
,@level2type = N'Column'
,@level2name = N'FLATNUMBER';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ะขะธะฟ ะฟะพะผะตัะตะฝะธั'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_ROOM'
,@level2type = N'Column'
,@level2name = N'FLATTYPE';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ะะพะผะตั ะบะพะผะฝะฐัั'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_ROOM'
,@level2type = N'Column'
,@level2name = N'ROOMNUMBER';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ะขะธะฟ ะบะพะผะฝะฐัั'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_ROOM'
,@level2type = N'Column'
,@level2name = N'ROOMTYPE';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ะะพะด ัะตะณะธะพะฝะฐ'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_ROOM'
,@level2type = N'Column'
,@level2name = N'REGIONCODE';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ะะพััะพะฒัะน ะธะฝะดะตะบั'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_ROOM'
,@level2type = N'Column'
,@level2name = N'POSTALCODE';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ะะฐัะฐ ะฒะฝะตัะตะฝะธั ะทะฐะฟะธัะธ'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_ROOM'
,@level2type = N'Column'
,@level2name = N'UPDATEDATE';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ะะดะตะฝัะธัะธะบะฐัะพั ัะพะดะธัะตะปััะบะพะณะพ ะพะฑัะตะบัะฐ (ะดะพะผะฐ)'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_ROOM'
,@level2type = N'Column'
,@level2name = N'HOUSEGUID';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ะฃะฝะธะบะฐะปัะฝัะน ะธะดะตะฝัะธัะธะบะฐัะพั ะทะฐะฟะธัะธ. ะะปััะตะฒะพะต ะฟะพะปะต.'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_ROOM'
,@level2type = N'Column'
,@level2name = N'ROOMID';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ะะดะตะฝัะธัะธะบะฐัะพั ะทะฐะฟะธัะธ ัะฒัะทัะฒะฐะฝะธั ั ะฟัะตะดัะดััะตะน ะธััะพัะธัะตัะบะพะน ะทะฐะฟะธััั'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_ROOM'
,@level2type = N'Column'
,@level2name = N'PREVID';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ะะดะตะฝัะธัะธะบะฐัะพั ะทะฐะฟะธัะธ ัะฒัะทัะฒะฐะฝะธั ั ะฟะพัะปะตะดัััะตะน ะธััะพัะธัะตัะบะพะน ะทะฐะฟะธััั'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_ROOM'
,@level2type = N'Column'
,@level2name = N'NEXTID';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ะะฐัะฐะปะพ ะดะตะนััะฒะธั ะทะฐะฟะธัะธ'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_ROOM'
,@level2type = N'Column'
,@level2name = N'STARTDATE';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ะะบะพะฝัะฐะฝะธะต ะดะตะนััะฒะธั ะทะฐะฟะธัะธ'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_ROOM'
,@level2type = N'Column'
,@level2name = N'ENDDATE';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ะัะธะทะฝะฐะบ ะดะตะนััะฒัััะตะณะพ ะฐะดัะตัะฝะพะณะพ ะพะฑัะตะบัะฐ'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_ROOM'
,@level2type = N'Column'
,@level2name = N'LIVESTATUS';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ะะฝะตัะฝะธะน ะบะปัั ะฝะฐ ะฝะพัะผะฐัะธะฒะฝัะน ะดะพะบัะผะตะฝั'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_ROOM'
,@level2type = N'Column'
,@level2name = N'NORMDOC';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ะกัะฐััั ะดะตะนััะฒะธั ะฝะฐะด ะทะฐะฟะธััั โ ะฟัะธัะธะฝะฐ ะฟะพัะฒะปะตะฝะธั ะทะฐะฟะธัะธ (ัะผ. ะพะฟะธัะฐะฝะธะต ัะฐะฑะปะธัั OperationStatus):
01 โ ะะฝะธัะธะฐัะธั;
10 โ ะะพะฑะฐะฒะปะตะฝะธะต;
20 โ ะะทะผะตะฝะตะฝะธะต;
21 โ ะััะฟะฟะพะฒะพะต ะธะทะผะตะฝะตะฝะธะต;
30 โ ะฃะดะฐะปะตะฝะธะต;
31 - ะฃะดะฐะปะตะฝะธะต ะฒัะปะตะดััะฒะธะต ัะดะฐะปะตะฝะธั ะฒััะตััะพััะตะณะพ ะพะฑัะตะบัะฐ;
40 โ ะัะธัะพะตะดะธะฝะตะฝะธะต ะฐะดัะตัะฝะพะณะพ ะพะฑัะตะบัะฐ (ัะปะธัะฝะธะต);
41 โ ะะตัะตะฟะพะดัะธะฝะตะฝะธะต ะฒัะปะตะดััะฒะธะต ัะปะธัะฝะธั ะฒััะตััะพััะตะณะพ ะพะฑัะตะบัะฐ;
42 - ะัะตะบัะฐัะตะฝะธะต ัััะตััะฒะพะฒะฐะฝะธั ะฒัะปะตะดััะฒะธะต ะฟัะธัะพะตะดะธะฝะตะฝะธั ะบ ะดััะณะพะผั ะฐะดัะตัะฝะพะผั ะพะฑัะตะบัั;
43 - ะกะพะทะดะฐะฝะธะต ะฝะพะฒะพะณะพ ะฐะดัะตัะฝะพะณะพ ะพะฑัะตะบัะฐ ะฒ ัะตะทัะปััะฐัะต ัะปะธัะฝะธั ะฐะดัะตัะฝัั
ะพะฑัะตะบัะพะฒ;
50 โ ะะตัะตะฟะพะดัะธะฝะตะฝะธะต;
51 โ ะะตัะตะฟะพะดัะธะฝะตะฝะธะต ะฒัะปะตะดััะฒะธะต ะฟะตัะตะฟะพะดัะธะฝะตะฝะธั ะฒััะตััะพััะตะณะพ ะพะฑัะตะบัะฐ;
60 โ ะัะตะบัะฐัะตะฝะธะต ัััะตััะฒะพะฒะฐะฝะธั ะฒัะปะตะดััะฒะธะต ะดัะพะฑะปะตะฝะธั;
61 โ ะกะพะทะดะฐะฝะธะต ะฝะพะฒะพะณะพ ะฐะดัะตัะฝะพะณะพ ะพะฑัะตะบัะฐ ะฒ ัะตะทัะปััะฐัะต ะดัะพะฑะปะตะฝะธั
'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_ROOM'
,@level2type = N'Column'
,@level2name = N'OPERSTATUS';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ะะฐะดะฐัััะพะฒัะน ะฝะพะผะตั ะฟะพะผะตัะตะฝะธั'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_ROOM'
,@level2type = N'Column'
,@level2name = N'CADNUM';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ะะฐะดะฐัััะพะฒัะน ะฝะพะผะตั ะบะพะผะฝะฐัั ะฒ ะฟะพะผะตัะตะฝะธะธ'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_ROOM'
,@level2type = N'Column'
,@level2name = N'ROOMCADNUM';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ะะฐะธะผะตะฝะพะฒะฐะฝะธะต'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_STRSTAT'
,@level2type = N'Column'
,@level2name = N'NAME';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ะัะฐัะบะพะต ะฝะฐะธะผะตะฝะพะฒะฐะฝะธะต'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_STRSTAT'
,@level2type = N'Column'
,@level2name = N'SHORTNAME';
EXEC sp_addextendedproperty @name = 'description'
,@value = N'ะัะธะทะฝะฐะบ ัััะพะตะฝะธั'
,@level0type = N'Schema'
,@level0name = N'dbo'
,@level1type = N'Table'
,@level1name = N'_STRSTAT'
,@level2type = N'Column'
,@level2name = N'STRSTATID'
5. แแพแแแแแแแแแแแแแแถแแแแแแแแแแฝแแฏแแ
-- ะะฟัะตะดะตะปะตะฝะธะต ัััะปะบะธ ะฝะฐ ะธะผะฟะพััะธััะตะผัั ัั
ะตะผั
update a
Set x.modify ('declare namespace xs="http://www.w3.org/2001/XMLSchema";
insert <xs:import namespace="http://schemas.microsoft.com/sqlserver/2004/sqltypes" schemaLocation="./sqltypes.xsd" /> as first
into (xs:schema)[1]')
from dbo.[_FIAS_SCHEMAS] a
-- ะะฟัะตะดะตะปะตะฝะธะต ะบะพัะฝะตะฒะพะณะพ ะฐัััะธะฑััะฐ
update a
Set x.modify('declare namespace ss="urn:schemas-microsoft-com:mapping-schema";
insert (
attribute ss:is-constant {"1"}
)
into (/xs:schema[1]/xs:element[1])')
from dbo.[_FIAS_SCHEMAS] a
-- ะะฟัะตะดะตะปะตะฝะธะต ะฝะพะดั, ัะฒะปัััะตะนัั ัััะพะบะพะน ัะฐะฑะปะธัั ะธ ัะฒัะทะฐะฝะฝะพะน ั ะฝะตะน ัะฐะฑะปะธัั
update a
Set x.modify('declare namespace ss="urn:schemas-microsoft-com:mapping-schema";
insert (
attribute ss:relation {sql:column("a.table")}
)
into (xs:schema[1]/xs:element[1]/xs:complexType[1]/xs:sequence[1]/xs:element[1])')
from dbo.[_FIAS_SCHEMAS] a
-- ะะฝะฝะพัะฐัะธั ะฟะพะปะตะน ะฒ ัั
ะตะผะต
-- ะข.ะบ. ะทะฐ 1 ัะฐะท ะผะพะถะฝะพ ะผะพะดะธัะธัะธัะพะฒะฐัั ัะพะปัะบะพ ะพะดะฝั ะฝะพะดั - ะฟัะธะดะตััั ะธัะฟะพะปัะทะพะฒะฐัั ะบัััะพั
Declare @table nvarchar(4000)
Declare @column nvarchar(4000)
Declare cur CURSOR LOCAL FORWARD_ONLY
for
Select [table โโ not found /]
, [column]
from dbo.[_FIAS]
Open cur
FETCH NEXT FROM cur into @table, @column
WHILE @@FETCH_STATUS = 0
BEGIN
update a
Set x.modify('declare namespace ss="urn:schemas-microsoft-com:mapping-schema";
insert (
attribute ss:field {sql:column("t.column")}
,attribute ss:datatype {sql:column("b.sqltype")}
)
into (//xs:attribute[@name = sql:column("b.column")])[1]')
from dbo.[_FIAS_SCHEMAS] a
inner join dbo.[_FIAS] b on a.[table โโ not found /]
= b.[table โโ not found /]
cross apply (Values(QUOTENAME(b.[column]))) t([column])
Where b.[table โโ not found /]
= @table and b.[column] = @column
FETCH NEXT FROM cur into @table, @column
END
CLOSE cur;
DEALLOCATE cur;
6. แ แพแแ แปแแแแแแ แแแแ แแแแแแแแแถแแแ xsd แแ แแแแปแแแถแแแแแแถแแแแถแแแแแพแแแแถแแแแแแแแแแแแ
-- ะัะณััะทะบะฐ ัั
ะตะผ
-- ะะฑัะฐัะธัะต ะฒะฝะธะผะฐะฝะธะต, ะฟััั ะบ ะฒัะณััะถะฐะตะผัะผ ัั
ะตะผะฐะผ - ะทะฐั
ะฐัะดะบะพะถะตะฝ!
Set @sql = (
Select N'; exec xp_cmdshell ''bcp "Select [x] from [FIAS2].[dbo].[_FIAS_SCHEMAS] where [table โโ not found /]
= ''''' + a.[table โโ not found /]
+ '''''" queryout "c:filesFIAS' + a.[table โโ not found /]
+ '.xsd" -S . -T -w'''
from dbo.[_FIAS_SCHEMAS] a
for xml path(N''), type
).value(N'.', N'nvarchar(max)')
exec (@sql)
แแถแแแขแแ! :-)))
แแแแแบแแถแแแแฝแแแถแแแแผแแแแแแแแแพแแแถแแถแ แแถแแแทแแแแแถแแแแแแฝแแแ แแแแแแแแแแแแแถแแแ แแทแแแแแ แแแแฝแแแถแแ แแแแปแแแถแแ
USE [FIAS2]
go
if OBJECT_ID('dbo.[_FIAS]') is not null
drop table dbo.[_FIAS]
go
if OBJECT_ID('dbo._FIAS_SCHEMAS') is not null
drop table dbo.[_FIAS_SCHEMAS]
go
Declare @schema sysname = N'dbo'
Declare @sql nvarchar(max)
Create table dbo.[_FIAS_SCHEMAS] (x xml, [table โโ not found /]
sysname)
insert into dbo.[_FIAS_SCHEMAS] (x, [table โโ not found /]
)
SELECT x = CAST(BulkColumn AS XML).query('.'), '_ACTSTAT' [table โโ not found /]
FROM OPENROWSET(BULK 's01sq03c$filesFIASAS_ACTSTAT_2_250_08_04_01_01.xsd', SINGLE_BLOB) x Union all
SELECT x = CAST(BulkColumn AS XML).query('.'), '_ADDROBJ' FROM OPENROWSET(BULK 's01sq03c$filesFIASAS_ADDROBJ_2_250_01_04_01_01.xsd', SINGLE_BLOB) x Union all
SELECT x = CAST(BulkColumn AS XML).query('.'), '_CENTERST' FROM OPENROWSET(BULK 's01sq03c$filesFIASAS_CENTERST_2_250_10_04_01_01.xsd', SINGLE_BLOB) x Union all
SELECT x = CAST(BulkColumn AS XML).query('.'), '_CURENTST' FROM OPENROWSET(BULK 's01sq03c$filesFIASAS_CURENTST_2_250_07_04_01_01.xsd', SINGLE_BLOB) x Union all
SELECT x = CAST(BulkColumn AS XML).query('.'), '_DEL_ADDROBJ' FROM OPENROWSET(BULK 's01sq03c$filesFIASAS_DEL_ADDROBJ_2_250_15_04_01_01.xsd', SINGLE_BLOB) x Union all
SELECT x = CAST(BulkColumn AS XML).query('.'), '_DEL_HOUSEINT' FROM OPENROWSET(BULK 's01sq03c$filesFIASAS_DEL_HOUSEINT_2_250_17_04_01_01.xsd', SINGLE_BLOB) x Union all
SELECT x = CAST(BulkColumn AS XML).query('.'), '_DEL_HOUSE' FROM OPENROWSET(BULK 's01sq03c$filesFIASAS_DEL_HOUSE_2_250_16_04_01_01.xsd', SINGLE_BLOB) x Union all
SELECT x = CAST(BulkColumn AS XML).query('.'), '_DEL_LANDMARK' FROM OPENROWSET(BULK 's01sq03c$filesFIASAS_DEL_LANDMARK_2_250_18_04_01_01.xsd', SINGLE_BLOB) x Union all
SELECT x = CAST(BulkColumn AS XML).query('.'), '_DEL_NORMDOC' FROM OPENROWSET(BULK 's01sq03c$filesFIASAS_DEL_NORMDOC_2_250_19_04_01_01.xsd', SINGLE_BLOB) x Union all
SELECT x = CAST(BulkColumn AS XML).query('.'), '_ESTSTAT' FROM OPENROWSET(BULK 's01sq03c$filesFIASAS_ESTSTAT_2_250_13_04_01_01.xsd', SINGLE_BLOB) x Union all
SELECT x = CAST(BulkColumn AS XML).query('.'), '_FLATTYPE' FROM OPENROWSET(BULK 's01sq03c$filesFIASAS_FLATTYPE_2_250_23_04_01_01.xsd', SINGLE_BLOB) x Union all
SELECT x = CAST(BulkColumn AS XML).query('.'), '_HOUSEINT' FROM OPENROWSET(BULK 's01sq03c$filesFIASAS_HOUSEINT_2_250_03_04_01_01.xsd', SINGLE_BLOB) x Union all
SELECT x = CAST(BulkColumn AS XML).query('.'), '_HOUSE' FROM OPENROWSET(BULK 's01sq03c$filesFIASAS_HOUSE_2_250_02_04_01_01.xsd', SINGLE_BLOB) x Union all
SELECT x = CAST(BulkColumn AS XML).query('.'), '_HSTSTAT' FROM OPENROWSET(BULK 's01sq03c$filesFIASAS_HSTSTAT_2_250_12_04_01_01.xsd', SINGLE_BLOB) x Union all
SELECT x = CAST(BulkColumn AS XML).query('.'), '_INTVSTAT' FROM OPENROWSET(BULK 's01sq03c$filesFIASAS_INTVSTAT_2_250_11_04_01_01.xsd', SINGLE_BLOB) x Union all
SELECT x = CAST(BulkColumn AS XML).query('.'), '_LANDMARK' FROM OPENROWSET(BULK 's01sq03c$filesFIASAS_LANDMARK_2_250_04_04_01_01.xsd', SINGLE_BLOB) x Union all
SELECT x = CAST(BulkColumn AS XML).query('.'), '_NDOCTYPE' FROM OPENROWSET(BULK 's01sq03c$filesFIASAS_NDOCTYPE_2_250_20_04_01_01.xsd', SINGLE_BLOB) x Union all
SELECT x = CAST(BulkColumn AS XML).query('.'), '_NORMDOC' FROM OPENROWSET(BULK 's01sq03c$filesFIASAS_NORMDOC_2_250_05_04_01_01.xsd', SINGLE_BLOB) x Union all
SELECT x = CAST(BulkColumn AS XML).query('.'), '_OPERSTAT' FROM OPENROWSET(BULK 's01sq03c$filesFIASAS_OPERSTAT_2_250_09_04_01_01.xsd', SINGLE_BLOB) x Union all
SELECT x = CAST(BulkColumn AS XML).query('.'), '_ROOMTYPE' FROM OPENROWSET(BULK 's01sq03c$filesFIASAS_ROOMTYPE_2_250_24_04_01_01.xsd', SINGLE_BLOB) x Union all
SELECT x = CAST(BulkColumn AS XML).query('.'), '_ROOM' FROM OPENROWSET(BULK 's01sq03c$filesFIASAS_ROOM_2_250_21_04_01_01.xsd', SINGLE_BLOB) x Union all
SELECT x = CAST(BulkColumn AS XML).query('.'), '_SOCRBASE' FROM OPENROWSET(BULK 's01sq03c$filesFIASAS_SOCRBASE_2_250_06_04_01_01.xsd', SINGLE_BLOB) x Union all
SELECT x = CAST(BulkColumn AS XML).query('.'), '_STEAD' FROM OPENROWSET(BULK 's01sq03c$filesFIASAS_STEAD_2_250_22_04_01_01.xsd', SINGLE_BLOB) x Union all
SELECT x = CAST(BulkColumn AS XML).query('.'), '_STRSTAT' FROM OPENROWSET(BULK 's01sq03c$filesFIASAS_STRSTAT_2_250_14_04_01_01.xsd', SINGLE_BLOB) x
;WITH XMLNAMESPACES ('http://www.w3.org/2001/XMLSchema' as xs)
Select a.[table โโ not found /]
,tbl.[root_name]
,tbl.[root_description]
,tbl.[name]
,ROW_NUMBER() over (partition by a.[table โโ not found /]
order by 1/0) N
,tbl.[column]
,tbl.[required]
,tbl.[description]
,tbl.[type]
,tbl.[len]
,Case tbl.[type]
when N'byte' then N'tinyint'
when N'date' then N'date'
when N'int' then N'int'
when N'string' then
Case when tbl.[len] = 36 and (tbl.[column] like N'%ID' or tbl.[column] = N'NORMDOC') then N'uniqueidentifier'
when tbl.[len] is Null then N'nvarchar(max)'
Else N'nvarchar(' + cast(tbl.[len] as nvarchar(4000)) + N')' END
when N'integer' then
Case when tbl.[len] > 9 then N'bigint'
when tbl.[len] <= 4 then N'smallint'
Else N'int'
end
else N'nvarchar(max)'
End [sqltype]
,t.n.query('.') [node]
into dbo.[_FIAS]
from dbo.[_FIAS_SCHEMAS] a
Cross apply a.x.nodes('//xs:attribute') t(n)
Cross apply
(values -- ะฝะตะบะพัะพััะต ะฟะพะปั ะธัะฟะพะปัะทััััั ะฝะตัะบะพะปัะบะพ ัะฐะท, ะฟะพััะพะผั ัะดะตะปะฐะตะผ ัะฐะบ :)
(
x.value('(xs:schema[1]/xs:element[1]/@name)', 'nvarchar(255)')
,x.value('(xs:schema[1]/xs:element[1]/xs:annotation/xs:documentation[1]/text())[1]', 'nvarchar(4000)')
,x.value('(xs:schema[1]/xs:element[1]/xs:complexType[1]/xs:sequence[1]/xs:element[1]/@name)', 'nvarchar(255)')
,t.n.value('(./@name)[1]', 'nvarchar(255)')
,t.n.value('(./@use)[1]', 'nvarchar(255)')
,Stuff(Coalesce(t.n.value('(./xs:simpleType/xs:restriction/@base)[1]', 'nvarchar(255)'), t.n.value('(./@type)[1]', 'nvarchar(255)')), 1, 3, '')
,Coalesce(t.n.value('(./xs:simpleType/xs:restriction/xs:length/@value)[1]', 'int')
,t.n.value('(./xs:simpleType/xs:restriction/xs:maxLength/@value)[1]', 'int')
,t.n.value('(./xs:simpleType/xs:restriction/xs:totalDigits/@value)[1]', 'int'))
,Replace(
Replace(
Replace(
Replace(
Replace(
Replace(
Replace(
Replace(
Replace(t.n.value('(./xs:annotation/xs:documentation)[1]', 'nvarchar(4000)'), ' ', ' ')
, ' ', ' ')
, ' ', ' ')
, ' ', ' ')
, ' ', ' ')
, ' ', ' ')
, ' ', ' ')
, ' ', ' ')
, ' ', ' ')
)
) tbl([root_name], [root_description], [name], [column], [required], [type], [len], [description])
-- ะะพัะผะพััะธะผ ะฝะฐ ัะตะทัะปััะฐั
Select * from dbo.[_FIAS]
-- ะกะพะทะดะฐะดะธะผ ะบะพะด ะดะปั ัะพะทะดะฐะฝะธั ัะฐะฑะปะธั, ะธ ะทะฐะฟัััะธะผ ะตะณะพ
set @sql = (
Select Distinct
N';Create table '
+ Quotename(@schema)
+ N'.'
+ Quotename([table โโ not found /]
)
+ N'('
+ Stuff((Select
N','
+ QUOTENAME(b.[column])
+ N' '
+ b.[sqltype]
+ Case b.[required] when 'required' then N' NOT NULL'
when 'optional' then N' NULL'
End
From dbo.[_FIAS] b
where b.[table โโ not found /]
= a.[table โโ not found /]
Order by N ASC
For xml path(N''), type
).value(N'.', 'nvarchar(max)'), 1, 1, N'')
+ N')'
from dbo.[_FIAS] a
For xml path(N''), type).value(N'.', N'nvarchar(max)')
exec (@sql)
-- ะกะพะทะดะฐะดะธะผ ะฐะฝะฝะพัะฐัะธั ะบ ัะฐะฑะปะธัะฐะผ ะธ ะฟะพะปัะผ
Set @sql = (
Select N'; exec sp_addextendedproperty @name=''description'', @value=N'''
+ a.[root_description]
+ N''', @level0type =N''Schema'', @level0name = N'''
+ @schema
+ N''', @level1type = N''Table'', @level1name = N'''
+ a.[table โโ not found /]
+ N''''
from (Select distinct [table โโ not found /]
, [root_description] from dbo.[_FIAS]) a
for xml path(N''), type
).value(N'.', N'nvarchar(max)')
exec (@sql)
Set @sql = (
Select N'; exec sp_addextendedproperty @name=''description'', @value=N'''
+ a.[description]
+ N''', @level0type =N''Schema'', @level0name = N'''
+ @schema
+ N''', @level1type = N''Table'', @level1name = N'''
+ a.[table โโ not found /]
+ N''', @level2type = N''Column'', @level2name = N'''
+ a.[column]
+ N''''
from dbo.[_FIAS] a
for xml path(N''), type
).value(N'.', N'nvarchar(max)')
exec (@sql)
-- ะะฟัะตะดะตะปะตะฝะธะต ัััะปะบะธ ะฝะฐ ะธะผะฟะพััะธััะตะผัั ัั
ะตะผั
update a
Set x.modify ('declare namespace xs="http://www.w3.org/2001/XMLSchema";
insert <xs:import namespace="http://schemas.microsoft.com/sqlserver/2004/sqltypes" schemaLocation="./sqltypes.xsd" /> as first
into (xs:schema)[1]')
from dbo.[_FIAS_SCHEMAS] a
-- ะะฟัะตะดะตะปะตะฝะธะต ะบะพัะฝะตะฒะพะณะพ ะฐัััะธะฑััะฐ
update a
Set x.modify('declare namespace ss="urn:schemas-microsoft-com:mapping-schema";
insert (
attribute ss:is-constant {"1"}
)
into (/xs:schema[1]/xs:element[1])')
from dbo.[_FIAS_SCHEMAS] a
-- ะะฟัะตะดะตะปะตะฝะธะต ะฝะพะดั, ัะฒะปัััะตะนัั ัััะพะบะพะน ัะฐะฑะปะธัั ะธ ัะฒัะทะฐะฝะฝะพะน ั ะฝะตะน ัะฐะฑะปะธัั
update a
Set x.modify('declare namespace ss="urn:schemas-microsoft-com:mapping-schema";
insert (
attribute ss:relation {sql:column("a.table")}
)
into (xs:schema[1]/xs:element[1]/xs:complexType[1]/xs:sequence[1]/xs:element[1])')
from dbo.[_FIAS_SCHEMAS] a
-- ะะฝะฝะพัะฐัะธั ะฟะพะปะตะน ะฒ ัั
ะตะผะต
-- ะข.ะบ. ะทะฐ 1 ัะฐะท ะผะพะถะฝะพ ะผะพะดะธัะธัะธัะพะฒะฐัั ัะพะปัะบะพ ะพะดะฝั ะฝะพะดั - ะฟัะธะดะตััั ะธัะฟะพะปัะทะพะฒะฐัั ะบัััะพั
Declare @table nvarchar(4000)
Declare @column nvarchar(4000)
Declare cur CURSOR LOCAL FORWARD_ONLY
for
Select [table โโ not found /]
, [column]
from dbo.[_FIAS]
Open cur
FETCH NEXT FROM cur into @table, @column
WHILE @@FETCH_STATUS = 0
BEGIN
update a
Set x.modify('declare namespace ss="urn:schemas-microsoft-com:mapping-schema";
insert (
attribute ss:field {sql:column("t.column")}
,attribute ss:datatype {sql:column("b.sqltype")}
)
into (//xs:attribute[@name = sql:column("b.column")])[1]')
from dbo.[_FIAS_SCHEMAS] a
inner join dbo.[_FIAS] b on a.[table โโ not found /]
= b.[table โโ not found /]
cross apply (Values(QUOTENAME(b.[column]))) t([column])
Where b.[table โโ not found /]
= @table and b.[column] = @column
FETCH NEXT FROM cur into @table, @column
END
CLOSE cur;
DEALLOCATE cur;
-- ะัะณััะทะบะฐ ัั
ะตะผ
-- ะะฑัะฐัะธัะต ะฒะฝะธะผะฐะฝะธะต, ะฟััั ะบ ะฒัะณััะถะฐะตะผัะผ ัั
ะตะผะฐะผ - ะทะฐั
ะฐัะดะบะพะถะตะฝ!
Set @sql = (
Select N'; exec xp_cmdshell ''bcp "Select [x] from [FIAS2].[dbo].[_FIAS_SCHEMAS] where [table โโ not found /]
= ''''' + a.[table โโ not found /]
+ '''''" queryout "c:filesFIAS' + a.[table โโ not found /]
+ '.xsd" -S . -T -w'''
from dbo.[_FIAS_SCHEMAS] a
for xml path(N''), type
).value(N'.', N'nvarchar(max)')
exec (@sql)
แฅแกแผแแแแแแถแแ แแแแแแแพแแแแธแ แ แแแแพแแแถแแแแแปแแแแแแถแแแฏแแแถแ xml แแธแแฝแแแแถแแฝแแแนแแแแแแแแถแแแแแแแแแแผแแแแแถแ (แฏแแแถแแแแแแทแแแถแแแแ แแแแแแแแแฝแแฏแแแแแผแแแถแแแแแแถแแปแแแแแปแแแ e:tmp แ แพแแแพแแแถแแแแแ แแแแแแแแแถแแแแแ c:filesFIAS)แ
USE FIAS2
GO
Declare @sql nvarchar(max)
if OBJECT_ID('tempdb..#t') is not null
drop table #t
Create table #t ([output] sysname NULL)
insert into #t
exec xp_cmdshell 'dir e:tmp /B'
;With load_data as
(
Select
'_' + t.x.value('(a[2])', 'nvarchar(255)') [table โโ not found /]
,t.x.value('(a[3])', 'date') [fias_date]
,t.x.value('(a[4])', 'uniqueidentifier') [fias_guid]
,a.[output] [file_name]
from #t a
cross apply (VALUES(Cast('<a>' + Replace(Replace(Replace(Replace(a.[output],'DEL_', 'DEL$'), '_', '</a><a>'), '.', '</a><a>'), '$', '_') + '</a>' as xml))) t(x)
Where [output] like 'AS[_]%.xml'
)
Select @sql =
(Select
N';exec [dbo].[spXMLBulkLoad] ''e:tmp' + a.[file_name] + ''', ''c:filesFIAS' + b.[table โโ not found /]
+ '.xsd'', ''FIAS2'', ''e:tmperr.xml'''
from load_data a
inner join [dbo].[_FIAS_SCHEMAS] b on a.[table โโ not found /]
= b.[table โโ not found /]
For xml path(''), type).value(N'.', N'nvarchar(max)')
Exec (@sql)
แขแแ แแ...
แฅแกแผแโแแแโแแถโแ แแโแแแแแแแแแโแ แพแแ
แแแแแแถแแแถแแแแแ แแแแแถแขแแแธแแแแแแแปแแ
แแแแแแถแแแขแแแ แแ แแถแแธแแถแแธแแแแกแถแแ!
แแถแแแขแแแแแแแแแพแแแถแแแแถแแแถแแแแ แแแแแแแแปแแ แแแถแโแแบแ!
แแถแแถแแแทแแแแแปแแแทแแแทแแถแแขแแแธแแถแแแแแแพแแแถแแถแ แแทแแแแแแแแถแแแแแแ แ แพแแขแแแธแแถแแแถแแแแ
แแ แแแแปแแแแทแแถแแถแแแถแแแแแ แแถแแแถแแแแแถแแแแแแแปแแแแแพแแแแแถแแแขแแแ 5 แแแแ (แกแผแ!!!) แ แพแแแแแแบแแแแแแแถแแแถแแแแแพแแทแแทแแแแแแถแแถแแ
แแแแปแแแแแแถแแฝแแแแแถแแแแแถแแแแแปแแแแแแแแแ I / O แแบแแ แแแแแทแ 3 Mb / s แ แพแแแถแแแแแแแผแแแธแแแธแแแปแแแแแแแแแแแแผแแแถแแ แผแแแฝแแ
แแแแแปแขแถแแแแแแถแแแแแผแแแถแแแแแปแแแแแปแแแแแฟแแแทแแแพแแแธ 3 แแถแแแแแแแแแแแถแแแแปแแแฝแแแทแแถแแธแแแแแแแแผแแแถแแแแแปแแแแแปแแแแแฟแแแทแแแพแแแธ 8 แแถแแแแแแปแแแฝแแแทแแถแแธแ แ แพแแแแแปแแแฝแแแถแแธแแถแ 60 แแถแแ
แแพแแถแแแแถแแแแถแแฝแแขแแแธ - แแแแปแแแทแแขแถแ
แแทแแถแแแถแแแ แแแแปแแแนแแแ
แแแแแแผแแแแแแแแแแฑแแแแถแแแแแแแธแแแแแ
แแถแแฝแแแนแแแผแ แแทแแแถแแแแแแแแแถแแฝแแแนแแแถแแแแแแ VM แ
แแผแแ แแแถแแแถแแถแแแแแปแแแแแผแแแถแแแแแพแกแพแแแถแแแแแปแแ แ แพแแแถแแแแแแแแถแแแแแแถแแแแผแแแถแแแแแแแแแถแแพแแแแธแแแแแพแแแแแแแแแแแ แแแแแแแ แแพ AOIDs แแถแแฝแแแแแแแฝแแแแ
แแแแแถแแแ แแฝแแแถแแถ GUIDs แแถแแถแแถแแแแแแพแแแแแปแแแถแแแแแพแแถแแแแแแแแแแทแแแพแขแแแแแแแแพแแแทแแทแแแแแ แแแแแแแปแแแแแแแแปแ แแแแแแแแนแแแถแแถแแถแแแแแแแแ แแแแแแ แแ 50 แแถแแแแแทแแแทแ แแแ แแถแแถแแแแแแพแแแถแแ แแถแแแแแขแแแแแแแแแปแแแถแแแแแแพแแแทแแทแแแแแแแแแถแแแแธแแถแแแแแปแ แแแแแแแถแแแแแ แผแแแ แแแแปแแแทแแทแแแแแแแแพแฑแแแแถแแแแแปแแแถแแแแแแบแแ
แแแแ แพแแแถแแผแแ แแแปแแแแแแแแแแถแแถแแแแแแแแแปแแ แถแแแแแแพแแแแแแแแแถแ แปแ ( _ ) แ แแแแผแแแแแปแแแแแผแแแแแปแแแทแแแแแแแแ แแแแปแแแฝแแแถ แแแแแถแแแแแแแแแพแแแทแแทแแแแแแแแถแแถแแแแแแ แกแพแแแทแ แ แพแแแแแแถแแแแแแแแพแแถแแแแแถแแแแแแผแแแถแแถแ Alter แแแแแแแแแแแแถแแแ
แแแ
แทแแแแแปแแแถแแแแแแแแ
แแแแแแแแแแแแทแแแแแแแแแแแทแแแผแแแแขแแแแแถแแแแถแแแแแถแแถแ FIAS แ
แงแแถแ แแแ แแถแแแแแพแแแแถแแ int แแแ tinyint แแบแแแแแแแแแถแแ แฌ nvarchar แแ
แแแแปแแแถแแแแแแถแแแแแแแแแแแแแแปแแแแแแแแแแแแผแแแถแแแแแแแแแถแแแแผแแแถแแแแแแถแแปแ แแผแ
แแถแแแแแผแแแแแแ แฌ OKATO แ
แแผแ
แแแแแแ
แแแแปแแแแแถแแแแถแ :-(.
แแแแแแถแแแถแแแแแ แแแแถแแขแแแธแแถแแถแแแขแแแแแ แแแแแถแแแแธแแแแแพแแแถแแถแแแทแแแแแแแแแแถ [dbo]แ[_FIAS] แแธแแถแแแธแแ แผแแแ แแแแปแแแถแแแแแแแแแแขแแแ แแทแแแแแแแแผแแแถ แ แพแแแถแแแแแแแแแแแ แแธแแถแแแแแแพแแแแแแแแถแแแแ แถแแแแแแพแแแแแธแแแแแแขแแแแพแแทแแแแแแแแแแถแแแแแถแแแแ
แแถแแถแแแแแแพแแแถแแ แแแแแทแแแพแขแแแแแ แแแแทแแขแถแ แแแแ แถแแแแถแแแแแปแแแบแแแแแแแแแ แแถแแแแแแแ แขแแแแแนแแแแแผแแแแแแแแแ แแแแแพแแแถแแฝแแแนแแแถแแแแแปแแแธ dbf แ แพแแแธแแแแปแ แแแแพแแแพแแแแ แปแแแถ dbfs แแผแ แ แ แพแแแแแแแขแแแแแแแฝแแแแแ
dbf แแแแปแ 8 threads แแถแแแแแแถแแแแผแแแถแแแแแปแแแแแปแแแแแแแ 1 แแแแแแถแแฝแแแนแแแถแแแแฝแ แ แพแแแถแ แแแถแแแแแแแแ แแแแฝแแแแแแแพแแแแธแแแแ แผแแแถแแถแแแธแแฝแแแแ แแแแปแแแถแแถแแแแแแ แแทแแแแแแพแแแทแแทแแแแแแพแแฝแแแถแ
... แแแแ แพแ แฌแ แปแแแแแแ แแถแแแแแแแแขแแแแ แแแแธ zhzhzh ... er ... aphedron แ แพแแแธแแแแปแแแแแแพแแแแแแแทแแธแแแแแทแแแทแแแแแแแแแแแแถ แ แพแแแแแปแแแทแแแแแแแแผแ แแแปแแแแแแแแแถแแถแแแขแแแแถแแแแ SSIS แ
แแแปแแแแแแแแแถแแฟแแแปแแแแแถแแถแแแแแแปแแ
โ
แแแแแแแแถแแแแแ
โ
แแผแแแถแแแถแแฝแแแแแแแทแแแแแแถแแแแแแแแปแแแ๐
แแแแแ: www.habr.com