Interested to Buy Any Domain ? << Click Here >> for more details...
what is the basic diffrence betn a col declared in char(1)
and in varchar(1)
- 2 Answers
- 4957 Views
- I also Faced
- E-Mail Answers
Answer Posted / penchal das
Char is static in size where as Varchar is dynamic in size.
if we use char(15) and we have used only 10 charectes then remaining memory space will be wasted.
In case of Varchar(15) if use 10 chars remaining memory space will be freed.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
Can you explain what is indexed view? How to create it?
How many full-text indexes can a table have?
What does sql server mean?
What is Transparent Data Encryption?
How many types of triggers in sql server?
How can I track the changes or identify the latest insert-update-delete from a table?
How to rebuild all indexes on a single table?
Types of Authentications in Sql Server? How user gets authenticated through windows authentication?
What are truncate options available in sql server? : sql server database administration
What is the osql utility?
John exports information periodically from a microsoft sql server database to an oracle database what is the best way to do this?
Do you know what is normalization of database? What are its benefits?
Explain hostprotectionattribute in sql server 2005?
What are the differences in Clustering in SQL Server 2005 and 2008 or 2008 R2?
Name some of the open source software that you can use in alternative to SSR?
