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
- 4917 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 two tables share the same primary key?
How to create a view using data from another view?
How to name query output columns in ms sql server?
what exactly sql injuction.how to overcome.....
What is lock escalation? : sql server database administration
Define right outer join?
What is partition in sql server?
How to count rows with the count(*) function in ms sql server?
What is multi-statement table-value user-defined function?
How to generate random numbers with the rand() function in ms sql server?
Explain few examples of RDBMS?
What is raid? : SQL Server Architecture
what are isolation levels? : Sql server database administration
What is a fill factor?
What is sparse columns of sql server 2008?
