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
What is snapshot parameter in ssrs?
Explain go command in sql server?
How does the report manager work in SSRS?
How do I install sql server?
How to send a ssrs report from ssis?
What is a trigger what are the advantages of trigger?
What are the basic features of a trigger in ms sql server?
How do I create a stored procedure in sql server?
Explain throw statement in sql server 2008?
Can we insert data into a view?
What is database architecture? : SQL Server Architecture
How to search for a string in all stored procedure in sql server?
What are various limitations of the views?
What are the system database in sql server 2008?
what is the system function to get current user's user id? : Sql server database administration