Answer / Wazeer Fatma

"Catalog Views in SQL Server are system-level views that provide information about the database's metadata and internal structure. They can be used to gather details about objects, schemas, permissions, indexes, statistics, etc."

How can count the string ? for ex: If i have string like 'bhaskar' then i need like b:1 h:1 a:2 s:1 k:1 r:1 please give any idea on that

9 Answers   TCS,

---

What is transactional replication?

1 Answers  

---

What are date and time data types in ms sql server?

1 Answers  

---

Do you know what is user defined datatypes and when you should go for them?

1 Answers  

---

Why do we need normalization?

1 Answers  

---

write the query for taking database restore in sql?

2 Answers  

---

When you first load SQL SERVER you will startup with what all databases?

3 Answers   CompuSol,

---

What is a with(nolock)?

1 Answers  

---

How to delete existing triggers using "drop trigger"?

1 Answers  

---

How to implement one-to-one, one-to-many and many-to-many relationships while designing tables?

1 Answers  

---

how to copy only distinct data into another table which is not already exist in database?

2 Answers   Spectra,

---

i have 4 tables.. T1, T2, T3, T4.. these tables have the same structure and they store the information entered in different years.. T1 stored 2002, T2 stored 2003, T3 stored 2004 and T4 stored 2005.. i want to copy contents in T1 to T2, T2 to T3, T3 to T4 and T4 to T1.. how do i do that? Temp tables cannot be used..

4 Answers  

---