这个代码是哪个SQL平台？

I'm not familiar with SQL.. i need to open one dataset, but i need to figure out which sql platform should i use.. There is a README file to view this dataset correctly, and there is one of the steps;

我不熟悉SQL ..我需要打开一个数据集,但我需要弄清楚我应该使用哪个sql平台。有一个README文件可以正确查看这个数据集,并且有一个步骤;

Example SQL code:

示例SQL代码:

/* LOAD ATTRIBUTE FILE */

/ * LOAD ATTRIBUTE FILE * /

BULK INSERT [<DATABASE>].[<OWNER>].[<TABLE NAME>]
FROM 'PATH\TO\LPS_ATTRIBUTES_<FIPS>.txt'
WITH (
     FORMATFILE = 'PATH\TO\LPS_CUSTOM_ATTRIBUTES_v1.fmt'
     )

I've tried Access and PostgreSQL, BULK INSERT command doesn't work for them..

我已经尝试过Access和PostgreSQL,BULK INSERT命令对他们不起作用..

1 个解决方案

#1

Well, it really seems to be MS SQL Server: Use a Format File to Bulk Import Data (SQL Server)

好吧,它似乎真的是MS SQL Server:使用格式文件批量导入数据(SQL Server)

Example says:

USE TestDatabase;  
GO

TRUNCATE TABLE myFirstImport; -- (for testing)
BULK INSERT dbo.myFirstImport   
   FROM 'D:\BCP\myFirstImport.bcp'   
   WITH (FORMATFILE = 'D:\BCP\myFirstImport.xml');  
GO

which is really close to what you have.

这真的很接近你所拥有的。

#1