如何在Sql Server中循环Sql查询结果集的每一行？ [英] How Do I Loop Over Every Row Of A Sql Query Result Set In Sql Server?

问题描述

大家好，



基本上我有一个存储过程，sql查询结果集如下所示： -

Hi all,

Basically i have a Stored Proc, the sql query result-set look like this:-

TID	CategoryFieldID	FieldName           FieldType ISDutyOnChange
17007	A	345022	Facebook Link	           L	1
17007	A	367736	main shared                T	1
17008	C	345024	Twitter                    L	1
17008	C	345025	Facebook Link	           L	1
17008	C	367737	main shared                T	1
17006	O	345019	Facebook Link	           L	1
17006	O	362042	High School req	           Z	1
17006	O	367738	main shared                T	1
16996	R	365285	High School req	           Z	1
16996	R	365725	First - Name	           T	1
16996	R	367739	main shared                T	1
16996	R	368540	Twitter User	           L	1
16996	R	368541	Facebook Link	           L	1
16996	R	368870	dutyonchange	           T	1

现在对于上面结果集的每一行，我必须首先检查类别列值并在我必须在不同的表格中插入数据的基础如下： -

如果行中的类别为A，则在表A中输入行等等......

请帮忙！

Now for each row of the above result-set, i have to first check "Category" column value and on the basis of which i have to insert data into different tables like :-
If its Category 'A' in the row ,then enter the row into table A and so-on...
Please help!

推荐答案

你可以使用游标 - https://msdn.microsoft.com/en-IN/library/ms180169.aspx [ ^ ]。

You can use a cursor - https://msdn.microsoft.com/en-IN/library/ms180169.aspx[^].

Transact SQL知道：同时 [ ^ ]循环和 CTE [ ^ ] 。



现在，您需要构建并执行动态查询。

在存储过程中构建动态SQL [ ^ ]

在SQL Server中执行动态SQL命令 [ ^ ]

Transact SQL knows: While[^] loop and CTE[^] also.

Now, you need to build and execute dynamic queries.
Building Dynamic SQL In a Stored Procedure[^]
Execute Dynamic SQL commands in SQL Server[^]

这篇关于如何在Sql Server中循环Sql查询结果集的每一行？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！