SQL的三個問題,答對我送他一份工人力住房管理的后台程序(SQL 2002)(75分)

/*
SQL的三個問題
/*前台選擇v1,v2,v3,v4,后台處理得到
----------------------
v1 v2 v3 v4<------欄位
---------------------
12 134 43 4 <---數
34 54 65 7 <---据
~~~~~~~~~~~~
/*前台選擇v6,v3,v5,后台處理得到
/*v6,v3,v5
------------------
v3 v5 v6
-------------------
12 23 34
2 3 4
-------------------
要實現上面,后台如何寫
-------------------------------------------------------------------
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
將這個字符串根据逗號分開,放到表里
declare @tempstr varchar(100)
select @tmepstr=' what,is,who,am,that,he '
=>>> a1
-----(table5)
what
is
who
am
that
ht
---------------------------------------------------------------------------------------------
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~`
將table1,table2,table3合成table4
a1 a2 a3 a1 a2 a3
---(table1) ----(table2) ----(table3) =>>> -----------------(table4)
1 2 3 1 2 3

-------------------------------------------------------------------------------------------------
*/

用动态语句

to szqsxq :用动态语句
可以詳細些嗎?

3.select a.a1,b.a2,c.a3
from a,b,c

2.用patindex（‘，’， @tmepstr）＝1 ＝2 ＝3

3.select a.a1,b.a2,c.a3
from a,b,c
假如表里 'a' 沒有會有錯的
thanks
go on

isnull(a,'')