what is the basic diffrence betn a col declared in char(1)
and in varchar(1)
Answer Posted / nilam gandhi
char(1) is a fixed length character data,size character long.
Maximum size 2000 bytes.
Default size is 1 byte.
Varchar(1) is a variable length character string.
And the maximum size of the varchar(1) data type is 4000 bytes.
| Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
What are synonyms?
Describe the left outer join & right outer join. : sql server database administration
Can we run Reporting Services with SQL Server express edition, which is a free version of SQL Server?
What are difference between Cluster index and Non-Cluster index?
How efficient you are in oracle and SQL server?
Explain the categories of stored procedure?
What is the use of floor function in sql server?
What is conditional split?
which backup strategy you are following at ur company
Mention the uses of stored procedures.
How will you decide the active and passive nodes?
what are different types of raid configurations? : Sql server database administration
Is it true, that there is no difference between a rule and a check constraint?
Please explain go command in sql server?
Mention the command used to rename the database.