sql游标使用之导入数据动态赋值

最新推荐文章于 2023-01-17 09:37:39 发布

weixin_30772261

最新推荐文章于 2023-01-17 09:37:39 发布

阅读量225

点赞数

原文链接：http://www.cnblogs.com/lijl/p/11368749.html

版权

DECLARE @ID uniqueidentifier
DECLARE @Name nvarchar(20)
DECLARE @Age int
DECLARE @Sex nvarchar(2)
DECLARE @Remarks nvarchar(100)

DECLARE table_cursor CURSOR FOR
	 (SELECT * FROM OpenDataSource
		('Microsoft.ACE.OLEDB.12.0','Excel 8.0;hdr=yes;Database=E:\csmodel\user.xlsx')...[Sheet1$])
		
OPEN table_cursor

FETCH NEXT FROM table_cursor into @ID,@Name,@Age,@Sex,@Remarks

WHILE @@FETCH_STATUS=0
BEGIN 
	insert into	EM_User values(newid(),@Name,@Age,@Sex,@Remarks)//动态给数据库表字段赋值
FETCH NEXT FROM table_cursor into @ID,@Name,@Age,@Sex,@Remarks
END

CLOSE table_cursor
DEALLOCATE table_cursor

转载于:https://www.cnblogs.com/lijl/p/11368749.html