What is row_number function?

0 Answers  

---

what is a schema in sql server 2005? Explain how to create a new schema in a database? : Sql server database administration

0 Answers  

---

What command is used to delete a table from the database in the sql server and how?

0 Answers  

---

what is a correlated sub-query? : Sql server database administration

0 Answers  

---

What is truncate table?

0 Answers  

---

---

what do you understand by change data capture?

0 Answers  

---

Explain about temporary stored procedure?

0 Answers  

---

i have table students with fields classname,studname select * from students classname studname 1 xxxxx 1 yyyy 1 zzzz 2 qqqq 2 tttt 3 dsds 3 www i want the output should be No of students in class 1 : 3 No of students in class 2 : 2 No of students in class 3 : 2

5 Answers   HCL, ZX,

---

Which system table contains information on constraints on all the tables created?

2 Answers  

---

How the authentication mode can be changed?

0 Answers  

---

Why Master database is required?

0 Answers   Abacus,

---

write the query for taking database restore in sql?

2 Answers  

---