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 |
|
victory_vishnu
Starting Member
8 Posts |
 Posted - 2008-05-08 : 05:07:32
|
| HI ALL, Here i am trying to build a SQL String that i can execute.For eg (@SSQL) , the final sql string will contain around 4000 chars. but when i try to build the @SSQL string and execute it gives me an error saying Connot convert to string.Then i tried to see the length of the string built , then i noticed that it is accepting upto 256 chars not beyod that ...but i have declared the @ SSQL as varchar(8000).Please helpthanks in advance. |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-05-08 : 05:14:20
|
| Nope. I dont think its problem with variable but its because of default settings in query analyser/SSMS that you're seeing only 256 characters. Goto Tools->Options. Expand Query Results->SQL Server -> Results to text and check value set for Maximum no: of characters displayed property. Its 256 by default. Make it 8000 and see.Now to solve your error, we need some idea about your code. Can you please post code where you assign SQL String and execute it? |
 |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
|
|
|
|
|
Dynamic SQL not working