自定义博客皮肤VIP专享

*博客头图:

格式为PNG、JPG,宽度*高度大于1920*100像素,不超过2MB,主视觉建议放在右侧,请参照线上博客头图

请上传大于1920*100像素的图片!

博客底图:

图片格式为PNG、JPG,不超过1MB,可上下左右平铺至整个背景

栏目图:

图片格式为PNG、JPG,图片宽度*高度为300*38像素,不超过0.5MB

主标题颜色:

RGB颜色,例如:#AFAFAF

Hover:

RGB颜色,例如:#AFAFAF

副标题颜色:

RGB颜色,例如:#AFAFAF

自定义博客皮肤

-+
  • 博客(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 1621

转载 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 843

原创 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 2739

原创 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 1075

空空如也

空空如也

TA创建的收藏夹 TA关注的收藏夹

TA关注的人

提示
确定要删除当前文章?
取消 删除