问题描述
我有一张桌子,其中有一些特定的场地,我需要在临时变量中显示Id值。
我的表:
prodId totalQuantity ProdDesc
387 5 adjfhdjhfj
422 4 adkfdkjfl
1218 3 djkfjldkjfkasj
1975 2 lksdjfkldjflk
2600 4 dksjfkldjlsfk
8082 8 sljdflsdj
13386 5 ddkjf; sd
20964 9 dkljflksji
29826 4 dl; kf; as
40812 1 ieruioeuioakjd
Req O / P as,我想显示临时变量中的每个数据。喜欢..
@vPid = 387,@ vtotalQuant = 5,@ vProdDesc = adjfhdjhfj
@ vPid2 = 422, @vtotalQuant = 4,@ vProdDesc = adkfdkjfl
@ vPid3 = 1218,@ vtotalQuant = 3,@ vProdDesc = djkfjldkjfkasj
@ vPid4 = 1975 ....... .........
对于prodid,totalquantity proddesc中的所有数据都是明智的。
请帮助。
先谢谢。 :)
编辑 - 从OP自己的解决方案错误地发布为答案。
实际上我有一个设计页面,其中我有1到8个标志来显示数据..
如ex:flag 1:prodid,desc和quantity。
flag 2:prodid2,desc和qty。所以......还有标志8.
所以我需要将这些详细信息的页面发送给每个用户。
但条件是,相同的数据不得出现在下一个循环时,我将详细信息发送给用户。
这样我还需要维护一个日志表。
我希望我能解释一下需求和要求。我想写一个关于这个要求的函数。
请帮助。
先谢谢。
Hie,
I have a table which has certain feilds in which i need to show the Id values in a temporary variable.
My Table:
prodIdtotalQuantity ProdDesc
387 5 adjfhdjhfj
422 4 adkfdkjfl
1218 3 djkfjldkjfkasj
1975 2 lksdjfkldjflk
2600 4 dksjfkldjlsfk
8082 8 sljdflsdj
13386 5 ddkjf ;sd
20964 9 dkljflksji
29826 4 dl;kf;as
40812 1 ieruioeuioakjd
Req O/P as, i want show every data in temp variable. like ..
@vPid = 387,@vtotalQuant = 5,@vProdDesc = adjfhdjhfj
@vPid2 = 422,@vtotalQuant = 4,@vProdDesc = adkfdkjfl
@vPid3 = 1218,@vtotalQuant = 3,@vProdDesc = djkfjldkjfkasj
@vPid4 = 1975................
like wise for all the data in prodid , totalquantity proddesc.
Please Help.
Thanks in Advance. :)
Edit - from OP's own solution mistakenly posted as answer.
Hi,
Actually i have a design page in which i have 1 to 8 flags to display the data..
like ex: flag 1 : prodid,desc and quantity.
flag 2: prodid2,desc and qty. so on..till flag 8.
And so i need to send these detail's page to every users.
but the condition is , the same data must not appear in next loop, when i send the details to the users.
this way i need to also maintain a log table.
I hope i could explain the need and requirement. I would like to write down a funtion on this requirement.
Please Help.
Thanks in Advance.
推荐答案
这篇关于如何在临时变量中设置列值。的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!