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.

All Forums  SQL Server 2000 Forums  SQL Server Development (2000)  data not appear full when viewed in query analyzer

Author  Topic  vikas Starting Member 2 Posts Posted - 2001-07-31 : 06:43:02 I have declared column qdata as varchar with length=2000 in sql server 7.0. I have inserted the data with less than 2000 characters into the field. Now when i view the data by passing the select query in query analyzer ,the data does not appear fully?????? For your convinience I show my data.Please enter in sql server 7.0 database and test it in query analyzer. ************************************ Consider the following code: 1. public void method(String s){ 2. String a,b; 3. a = new String("Hello"); 4. b = new String("Goodbye"); 5. System.out.println(a + b); 6. a = null; 7. a = b; 8. System.out.println(a + b); 9. } Where is it possible that the garbage collector will run the first time? ************************************ Please help me out with this problem.