I accept, there is no performance difference.

Also, the 2 bytes VARCHAR is using to store length of string is consuming disk space but not affecting the performance.

But still one...

Chris,

I have attached sample data for both the tables.

Thanks for the reply Chris,

I have already posted some sample data in my earlier post. Due to some legal restrictions, I can't post more data.

I have executed the code and...

Thanks for reply.

I agree with your explanation and I do follow as you said. Can you tell me if there is any performance gain, if I maintain the length of...

Yes, that is the point. 200 characters should be stored in VARCHAR (200), not in VARCHAR (2000). But why? I can use VARCHAR (2000) to store 200 characters. what makes...

Nice Read...

I agree with Grant

It is very easy to connect any type of vb6 / vb.net app with web server. only connection string should be updated. any questions may be forwarded at support@thesuntech.com.