Answer / 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.

Answer / 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.

Do you know what are acid properties of transaction?

0 Answers  

---

Explain what are the restrictions that views have to follow? : SQL Server Architecture

0 Answers  

---

What are the new security features added in sql server 2012? : sql server security

0 Answers  

---

Define magic tables in sql server?

0 Answers  

---

Can we make the the chages By Using the Sql if u know any function or process please inform me Actuall result: BRK1 Break 1 Part 1 00:01:00:00 60 BRK1 Break 1 Part 2 00:01:00:00 60 BRK2 Break 2 Part 1 00:01:00:00 60 BRK2 Break 2 Part 2 00:01:00:00 60 BRK2 Break 2 Part 3 00:01:00:00 60 BRK3 Break 3 Part 1 00:01:00:00 60 BRK3 Break 3 Part 2 00:01:00:00 60 Desired O/P: BRK1 Break 1 Part 1 00:01:00:00 60 Part 2 00:01:00:00 60 BRK2 Break 2 Part 1 00:01:00:00 60 Part 2 00:01:00:00 60 Part 3 00:01:00:00 60

0 Answers   Satyam,

---

---

what are default? Is there a column to which a default cant be bound?

1 Answers  

---

Explain basic SQL queries with SELECT from where Order By, Group By-Having?

3 Answers   TetraSoft, Wipro,

---

What is index fragmentation in ms sql server?

0 Answers  

---

What is the usage of sign function?

0 Answers  

---

Why do we use sql limitations? Which constraints can we use while making a database in sql?

0 Answers  

---

Explain rdbms?

0 Answers  

---

Can you explain what are various ways to enhance the ssrs report?

0 Answers  

---