Lets say due to N/W or Security issues client is not able to connect to server or vice versa. How do you troubleshoot?

1 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,

---

What happens when unicode strings concatenate with non-unicode strings?

0 Answers  

---

What is resultset concur_updatable?

0 Answers  

---

How to apply filtering criteria at group level with the having clause in ms sql server?

0 Answers  

---

Let us say master db itself has no backup. Now you have to rebuild the db so what kind of action do you take?

1 Answers  

---

What is trace flag in sql server?

0 Answers  

---

What is the guest user account in sql server? What login is it mapped to it? : sql server security

0 Answers  

---

What are the different types of normalization?

0 Answers  

---

What are the steps you can take to avoid “deadlocks”?

0 Answers  

---

How do I compare two values when one value(data type) is char and the other is an integer?

3 Answers  

---

SQL stops working in every 15 days displaying message that database log file is full. Log file size is 3.95 GB. It is happening after shrinking the database also. What is solution to overcome this problem. Please help me as it's urgent.

5 Answers  

---