可以先把A读出来放在一个数据中,再把B的读出来放在一个数组中,再放入二维数组中
IF OBJECT_ID('paper') IS NOT NULL
DROP TABLE paper
GO
CREATE TABLE paper ( id1 int,name varchar(10),class varchar(10) )
go
insert paper SELECT
1,'qifd','1,2,3'
GO
IF OBJECT_ID('classa') IS NOT NULL
DROP TABLE classa
GO
CREATE TABLE classa ( classid int,name varchar(10) )
go
insert classa SELECT
1 , '001班' UNION ALL SELECT
2 , '002班' UNION ALL SELECT
3 , '003班'
GO
--SELECT * FROM PAPER--SELECT * FROM classaDECLARE @STR VARCHAR(8000)SELECT @STR=ISNULL(@STR+',','')+B.NAME
FROM PAPER A ,classa B
WHERE CHARINDEX(','+LTRIM(B.classid)+',',','+A.class+',')>0SELECT A.*,@STR FROM paper Aid1 name class
----------- ---------- ---------- ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
1 qifd 1,2,3 001班,002班,003班(所影响的行数为 1 行)
给你一个SQL示例,再用SPLIT(',')拆分
IF OBJECT_ID('paper') IS NOT NULL
DROP TABLE paper
GO
CREATE TABLE paper ( id1 int,name varchar(10),class varchar(10) )
go
insert paper SELECT
1,'qifd','1,2,3'
GO
IF OBJECT_ID('classa') IS NOT NULL
DROP TABLE classa
GO
CREATE TABLE classa ( classid int,name varchar(10) )
go
insert classa SELECT
1 , '001班' UNION ALL SELECT
2 , '002班' UNION ALL SELECT
3 , '003班'
GO
--SELECT * FROM PAPER--SELECT * FROM classaDECLARE @STR VARCHAR(8000)SELECT @STR=ISNULL(@STR+',','')+B.NAME
FROM PAPER A ,classa B
WHERE CHARINDEX(','+LTRIM(B.classid)+',',','+A.class+',')>0SELECT A.*,@STR FROM paper Aid1 name class
----------- ---------- ---------- ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
1 qifd 1,2,3 001班,002班,003班(所影响的行数为 1 行)
给你一个SQL示例,再用SPLIT(',')拆分
如果你想用sqldatareader也不难啊
不过你得先确定二维数组大小
dim i as integer
while sqldatdataread.read
a(i,0)=sqldataread("fielda")
a(i,1)=sqldataread("fieldb")
i+=1
end while