What is the difference between sql server 2000 object owner and sql server 2005 schema? : sql server database administration

0 Answers  

---

What is enhanced database mirroring in sql server 2008?

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,

---

1. SELECT SUM(sal) as “Gross Salary” from EMPLOYEES; 2. SELECT MAX(sal) as “Highest Salary” from EMPLOYEES; ouput should be in table format

2 Answers  

---

What are out-of-range errors with date and time literals?

0 Answers  

---

How do you clear a log file?

0 Answers  

---

What are the advantages of sql stored procedure?

0 Answers  

---

What is the user of Primary key?

0 Answers  

---

In the primary key have a multiple field or not?

8 Answers   TCS,

---

Explain full-text indexing?

0 Answers  

---

How self join is different from outer join?

0 Answers   Blue Star,

---

Wht is SQL Injection Attack ?

3 Answers  

---