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
- 4811 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
How to call stored procedure using http soap?
How do I get Report Builder to generate a parameter that can be set by users viewing the report?
What are the source of constraints?
What is the use of “join” in sql server?
What is implicit mode in sql server?
What are page splits?
What is the difference between Triggers and Stored Procedure?
What is unpivot?
What is use of except clause? How does it differ from not in clause?
How do I install sql server?
How can we improve performance by using SQL Server profiler?
What is always encrypted?
Why union all is faster than union?
Beginning with sql server version 7 0, a new enhanced data type nchar was added what type of data is supported with this data type?
What security features are available for stored procedure?
