Answer / Lokesh

SQL Server Management Studio (SSMS) in 2008 introduced several new features, including: 1. IntelliSense for SQL scripts which provides real-time syntax checking and completions, 2. Query Editor's Object Explorer pane which allows for easier navigation of the database objects, 3. Database Diagrams which visually represent database schema, 4. Integration Services Package Explorer which simplifies package development and management.

Difference between Triggers and Stored Procedure

23 Answers   Claimat, HCL, Protech, Silgate,

---

What is the difference between TRUNCATE and DROP?

1 Answers  

---

What is PROJECTION Operation?

1 Answers   Infosys,

---

What do you mean by COLLATION?

4 Answers   ABC, BirlaSoft,

---

How optimize sql query with multiple joins in sql server?

1 Answers  

---

What is db stored procedure?

1 Answers  

---

What are sub-queries? Give example? In which case sub-queries are not feasible?

4 Answers   Infosys,

---

What is the difference between cube operator and rollup operator? : SQL Server Architecture

1 Answers  

---

what is victor class

0 Answers  

---

What value could be assigned to Varchar Type?

3 Answers  

---

How can we solve concurrency problems?

0 Answers  

---

Define inner join? Explain with an example?

1 Answers  

---