what is the basic diffrence betn a col declared in char(1)
and in varchar(1)
- 2 Answers
- 3978 Views
- I also Faced
- E-Mail Answers
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
Describe in brief system database.
What are the differences between lost updates and uncommitted dependencies?
What are the two authentication modes in sql server?
What it means to be triggered?
Is it possible to create trigger on views?
How to copy data from one table to another table?
How will you add a dimension to cube? : sql server analysis services, ssas
Explain optimistic and pessimistic concurrency?
What is unpivot?
Describe different Processing Modes offered by SSRS?
Write a program using SQL queries to find a unique entry in a table.
What are the different normalization forms?
How to create a view and a stored procedure in ms sql server using "create view/procedure" statements?
What is advantage data architect?
Where are stored procedures in sql server?
