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
- 4970 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
What are the advantages of having an index on the sql server?
Describe in brief databases and sql server databases architecture.
How to create prepared statements using odbc_prepare()?
What is a cache in ssrs?
Can we use where and having clause together?
Can two tables share a primary key?
in the physical file layout, where should the transaction log be stored in relation to the data file? : Sql server administration
What are a scheduled jobs or what is a scheduled tasks?
Explain what is lock escalation?
How do you check sql server is up and running?
What is the minimum recommended amount of ram for sql server 2012 enterprise?
Difference between report and query parameter. Why do we need different type of parameter?
Can you explain what are the restrictions applicable while creating views? : SQL Server Architecture
What is role playing dimension with two examples? : sql server analysis services, ssas
Is there any difference between the primary key and unique key?
