Answer / venkat

Index is commonly used for faster data retrieval.We can
have only one Clustered Index and many non-clustered index
in a single table.It is known that there is some
limitations in using indexes.If a column is defined as
primary key,by default column is set to be clustered
index.All other indexes created manually in the same table
were non-clustered index.

Is a null value equal to anything? Can a space in a column be considered a null value? Why or why not?

0 Answers  

---

Suppose you want to implement the one-to-one relationships while designing tables. How would you do it?

0 Answers  

---

i have table students with fields classname,studname select * from students classname studname 1 xxxxx 1 yyyy 1 zzzz 2 qqqq 2 tttt 3 dsds 3 www i want the output should be No of students in class 1 : 3 No of students in class 2 : 2 No of students in class 3 : 2

5 Answers   HCL, ZX,

---

How to check table values in sql server?

0 Answers  

---

What are the 2 types of classifications of constraints in the sql server?

0 Answers  

---

How to add an address record into adventureworkslt?

0 Answers  

---

How to create dbo table in sql server?

0 Answers  

---

Do you know what is sql service broker?

0 Answers  

---

What is advantage data architect?

0 Answers  

---

What the different types of Replication and why are they used?

0 Answers  

---

What is inner join in sql server joins?

0 Answers  

---

What are the differences between stored procedure and view in sql server?

0 Answers  

---