Answer / brijesh kumar

Index is used for fast retrival data from a table. There are
two types of index
1.clustered Index
2.Non-clustered Index
1. clustered index is created on primary key and it can be
only on per table
2.Non-clustered Index can be created any column and it can
be more than one in a table

Composite key:- Composite is the combination of more than
one attribute composite key is created when it is not
possible to identify any column in a table that has unique
value in such
a situation combination of more than column is chosen by
which
record can be identify easly clear it is just like primary
key.

How to call a function from a stored procedure in SQL Server ?

0 Answers   HCL,

---

You want to implement the many-to-many relationship while designing tables. How would you do it?

0 Answers  

---

What is BLOCK statements in SQL?

0 Answers   HCL,

---

Can you pass expressions to stored procedure parameters?

0 Answers  

---

Why use identity in sql server?

0 Answers  

---

What does the INSTEAD OF trigger do?

3 Answers  

---

What is the difference between resultset and resultsetmetadata?

0 Answers  

---

can we have a nested transaction? : Sql server database administration

0 Answers  

---

What happens if null values are involved in datetime operations?

0 Answers  

---

What is the difference between DTS and SSIS?

3 Answers   Allianz,

---

What do you mean by table and field in sql?

0 Answers  

---

Hi all, I need query help for below senorio, could you please help me. TableName = City CITYID ContinuationID CITYNAME 1 1 SAN 1 2 DIEGO 2 1 SAN 2 2 FRANCISCO 3 1 CHICAGO 4 1 NEW 4 2 YORK 4 3 CITY Could you please help me to write a generalized SQL that returns results as given below in the Query result CITYID NAME1 NAME2 NAME3 NAME4 NAME5 1 SAN DIEGO 2 SAN FRANCISCO 3 CHICAGO 4 NEW YORK CITY

5 Answers   TCS,

---