what is the basic diffrence betn a col declared in char(1)
and in varchar(1)
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
how to overcome kernel isssues
List out what other servers you can use with ssrs?
How can I get data from a database on another server?
Is truncate a dml command?
SQL Server Architecture ?
How to create percentile function?
What is dbcc?
What is resource governor?
How to Check if table exists in sql server?
What is query optimizer in sql server?
What is the difference between dropping a database and taking a database offline?
What are the restrictions that views have to follow? : SQL Server Architecture
Which tcp/ip port does sql server run on? How can it be changed?
Detail about query optimizer?
What are the database objects? : SQL Server Architecture