last function used in MS Access to convert sql what function will use in sql

0 Answers   Cap Gemini,

---

Can you give me some DBCC command options?(Database consistency check) - DBCC CHECKDB - Ensures that tables in the db and the indexes are correctly linked.and DBCC CHECKALLOC - To check that all pages in a db are correctly allocated. DBCC SQLPERF - It gives report on current usage of transaction log in percentage. DBCC CHECKFILEGROUP - Checks all tables file group for any damage.

0 Answers   iSoft,

---

How to store pdf file in sql server?

1 Answers   CarrizalSoft Technologies, College School Exams Tests, TATA,

---

Why use identity in sql server?

0 Answers  

---

How would you retrieve Unique rows from table without using UNIQUE and DISTINCT keyword?

2 Answers   Genpact,

---

What is a with(nolock)?

0 Answers  

---

What are the authentication modes in sql server? How can it be changed?

0 Answers  

---

What are four major operators that can be used to combine conditions on a where clause?

0 Answers  

---

What are tasks?

3 Answers   Wipro,

---

Can we insert data into view sql server?

0 Answers  

---

What are key, name and value columns of an attribute? : sql server analysis services, ssas

0 Answers  

---

Find 2nd Highest salery in emp table Select* from emp where &n= select * count from emp where (salery >=emp.salery) Enter n value 2 These query is correct or not. Tell me any other methods.

6 Answers  

---