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
- 5052 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 verify a user name with sqlcmd tool?
Define Joins?
What are indexers?
How to provide default values to function parameters?
you want to be sure that queries in a database always execute at the maximum possible speed. To achieve this goal you have created various indexes on tables which other statement will keep the database in good condition? : Sql server administration
How to create a stored procedure with a statement block in ms sql server?
Why are views required in the sql server or in any other database?
what is raid and what are different types of raid configurations? : Sql server database administration
How many databases Microsoft SQL server provides?
What do you understand by a view? What does the with check option clause for a view do?
What is set nocount on?
Which Model uses the SET concept
Do you know what is fill factor and pad index?
How to verify a login name with sqlcmd tool?
What are click through reports?
