Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2006-08-23 : 09:39:16
|
| Vikas writes "How to store a very long (around 10,000 – 100,000 character long) dynamic sql query?I am using MS SQL Server 2000.I have three tables and with the help of these tables I create dynamic sql query bcoz these are metadata tables. So length of query depends upon no. of records in tables. Now the problem is that how can I store this long string?RegardsVikas Jindal" |
|
|
Seventhnight
Master Smack Fu Yak Hacker
2878 Posts |
Posted - 2006-08-23 : 09:45:48
|
1) why do you need to store it if it is in tables?2) are you trying to store it in SQL or in another language?3) if you are trying to exec(@var)... then I will point out that you canexec (@var1 + @var2 + @var3 + @var4...)Corey Co-worker on children "...when I have children, I'm going to beat them. Not because their bad, but becuase I think it would be fun ..."  |
 |
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2006-08-23 : 09:46:46
|
100.000 chars long query? does that even compile??Go with the flow & have fun! Else fight the flow  blog thingie: http://weblogs.sqlteam.com/mladenp |
|
|
|
chiragkhabaria
Master Smack Fu Yak Hacker
1907 Posts |
Posted - 2006-08-23 : 09:53:04
|
quote:
Originally posted by spirit1
100.000 chars long query? does that even compile??Go with the flow & have fun! Else fight the flow blog thingie: http://weblogs.sqlteam.com/mladenp
He must be trying to create stored procedure dynamicallyChirag |
|
|
|
|
|
|
How to store a very long dynamic sql query?