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.

Please give me the SP for the below scenario. I have two tables named Table1 and Table2...I need to fetch record by record from Table1 and insert the record in to table2 where the value in the sno column of the table1 is even number.

4 Answers   Value Labs,

---

What is database replication? What are the different types of replication you can set up in sql server?

0 Answers  

---

Define the one-to-one relationship while designing tables.

0 Answers  

---

Give a example to search fr a string in all stored procedure in sql server.

0 Answers  

---

What does asynchronous call backs means?

0 Answers   Alcatel-Lucent,

---

What is the function of inner join?

0 Answers  

---

Which operator do you use to return all of the rows from one query except rows are returned in a second query?

0 Answers  

---

Which is best Subquery (or) joins in sql server? explain why

2 Answers  

---

How to use transact-sql statements to access the database engine?

0 Answers  

---

what is an extended stored procedure? Can you instantiate a com object by using t-sql? : Sql server database administration

0 Answers  

---

how will u create "n" possible tables in sql...

1 Answers   Oracle,

---

How to copy the tables, schema and views from one sql server to another?

0 Answers  

---