Answer Posted / suraj

Though it's not so clear on what type of SQL query.
If we want to see in what order does the SELECT query
executes; it'l like this.

SELECT .........
FROM ..........
WHERE ..........
GROUP BY ...........
HAVING ............

How do I find sql server instance name?

960

---

How many clustered indexes can be created on a table? I create a separate index on each column of a table. what are the advantages and disadvantages of this approach?

1111

---

What is an identity column in insert statements?

1023

---

If I delete a template from the list in sql studio, will it be deleted from the hard disk? : sql server management studio

985

---

What are truncate options available in sql server? : sql server database administration

1031

---

Explain insert into select statement?

955

---

what changed between the previous version of sql server and the current version? : Sql server database administration

1008

---

Why transaction is important?

975

---

What keyword you will use to get schema appended to the result set of a ‘for xml’ query?

1022

---

Explain the difference between primary keys and foreign keys?

1023

---

Hi, I Created 3 Tables Person(PersID[prkey],Name,Email,Password), Project(ProjName,ProjID[prkey],ProjLeader,ProjManager) & ProjectInvolvement(EntryDate,ProjID[frkey],PersID[frkey],ProjDuration). For this how can i INSERT,UPDATE & DELETE Through PROCEDURE? Please Post the Answer for me. Desai.

1848

---

What action plan is preferred if sql server is not responding?

1104

---

Can sql servers linked to other servers?

1043

---

Is there any performance difference between if exists (select null from table) and if exists (select 1 from table)?

970

---

How to create an index on a view?

1069

---