sql server 基本操作

一、bulk insert

1、简单举例

bulk insert demo2
from 'D:/test.txt'
with(fieldterminator=' ',rowterminator='\n')

2、详细介绍

http://blog.csdn.net/jackmacro/article/details/5959321/

二、游标的简单使用

1、scroll表示可随意移动游标指针（否则只能向前 ）

下例创建一个 SCROLL 游标，使其通过 LAST、PRIOR、RELATIVE 和 ABSOLUTE 选项支持所有滚动能力。

declare @id int,@name nvarchar(25);
declare m_cursor scroll cursor
for
	select * from demo2
open m_cursor;
	
	
	FETCH ABSOLUTE 5 from m_cursor into @ID,@NAME
	if @@FETCH_STATUS=0
		print '我是绝对定位：' + cast(@id as varchar)+'+'+ cast(@name as varchar);
		
	FETCH RELATIVE -3 from m_cursor into @id,@name
	if @@FETCH_STATUS=0
		print '我是相对定位：' + cast(@id as varchar)+'+'+ cast(@name as varchar);

	fetch first from m_cursor into @id,@name;
	if @@FETCH_STATUS=0
		print '我是最后一条记录：' + cast(@id as varchar)+'+'+ cast(@name as varchar);

	fetch last from m_cursor into @id,@name;
	if @@FETCH_STATUS=0
		print '我是最后一条记录：' + cast(@id as varchar)+'+'+ cast(@name as varchar);
		
	fetch prior from m_cursor into @id,@name;
	if @@FETCH_STATUS=0
		print '我是上一条记录：' + cast(@id as varchar)+'+'+ cast(@name as varchar);

	fetch next from m_cursor into @id,@name;
	if @@FETCH_STATUS=0
		print '我是下一条记录：' + cast(@id as varchar)+'+'+ cast(@name as varchar);

close m_cursor;
deallocate m_cursor;	

2、详细解释：http://www.cnblogs.com/Microblue/archive/2011/05/30/2406660.html