This topic has been archived. It cannot be replied.
-
工作学习 / 专业技术讨论 / SQL Server Problem,DECLARE @sql1 VARCHAR(8000), @sql2 VARCHAR(8000) , @sql3 VARCHAR(8000) ,...
SET @sql1 = 'SELECT columns,.... '
SET @sql2 = 'FROM table'
SET @sql3 = 'where ...'
select @sql1+@sql2 +...
-----------------------------------------------
Problem: concatenate them in the exec statement.
Any Solution:???
Thx
-xxu999(杰姆);
2006-3-8
{329}
(#2827251@0)
-
exec (@sql1+@sql2+@sql3)If my understanding of your question is correct
-super_eleman(Super Eleman);
2006-3-8
{47}
(#2827312@0)
-
Thanks for response, Super Eleman.
But Problem: concatenate them in the exec statement.
I got my solution but I hope to find more and better solutions.
-xxu999(杰姆);
2006-3-8
(#2827456@0)
-
不知所问。
-bdbs(不顶不算);
2006-3-8
(#2828202@0)