- 博客(4)
- 收藏
- 关注
原创 Bulk Insert 实例
以下例子在Windows XP + MS SQL Server 2000 Personal Edition 上运行通过。--建表use tempdbgoif exists (select * from dbo.sysobjects where id = object_id(N[dbo].[book]) and OBJECTPROPERTY(id, NIsUserTable) =
2006-09-16 18:09:00 1651
转载 Importing text files with Bulk Insert on MS SQL Server 2000
Importing text files Author Nigel Rivett This process will import text files that arrive in a directory into a table. It will process every file in the directory with the correct filemask and move the
2006-09-16 17:57:00 854
原创 Importing and Exporting Data
Importing and Exporting DataImporting data is the process of retrieving data from sources external to Microsoft SQL Server, for example, an ASCII text file, and inserting the data into SQL Server ta
2006-09-16 17:49:00 2854
原创 Bulk Insert from Flat File Using Transact-SQL
Bulk Insert from Flat File Using Transact-SQL AuthorM M Harinath In a typical IT environment, it is often necessary to import flat files to SQL Server tables.Sometimes it is necessary to forma
2006-09-16 17:35:00 1091
空空如也
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人