Answer / Kaushal Kumar Singh

1. Update Statistics: This SQL Server command updates the statistics for a specific table, which helps the Query Optimizer to make more informed choices when executing queries.n2. Scope_Identity(): Returns the identity column value for the last inserted row within a scope (either the current session or a specified transaction).

What are different types of views?

1 Answers  

---

Define primary key?

1 Answers  

---

How to find 6th highest salary from Employee table ?

10 Answers  

---

How to return the top 5 rows from a select query in ms sql server?

1 Answers  

---

What is a view?

6 Answers  

---

How do I find the default sql server instance?

1 Answers  

---

How to create hyperlink from returned sql query ?

1 Answers   MCN Solutions,

---

What is an execution plan? When would you use it? How would you view the execution plan?

1 Answers  

---

please can anyone answer this query Table 1 has 2 columns: EmployeeId,Age Table 2 has 2 columns: EmployeeId, Region Write SQL to Find the region who has the oldest person

10 Answers  

---

How to list all tables in the database using odbc_tables()?

1 Answers  

---

Can anyone explain difference between Database, Data warehouse and Data mart with some example?````

4 Answers  

---

How to select nth record from a table?

13 Answers   DELL, Microsoft, Ramco,

---