What does it mean to normalize data?

0 Answers  

---

Differentiate between SQL and ORACLE joins and write their syntax.

0 Answers   Global Logic,

---

I am Having tables T1 and T2 both having same data how to check (or) compare the data in both table are same?

3 Answers  

---

What is the datatype returned by count(*)

22 Answers   247Customer, Asian CERC,

---

What is an indice?

0 Answers  

---

---

How to enter comments in transact-sql statements?

0 Answers  

---

Hi SQL gurus, i am working for an MNC... My team is having a problem in sql server. when user slects date prompts from jan 1st to april 30, it should display all months data like : jan aa feb bb mar cc but when it comes to april its taking data like : jan aa feb bb mar cc apr dd...and so on means its taking data again from jan to april which we dont want. we want the data only april month as we are getting jan, feb and mar... can any one write the code to relsove the issue please would be greatful if you can send to shiva_sans@yahoo.co.in and also please send your email also ...so that we will be in touch for any kind of queries ... Thanks a lot in Advance !!!

1 Answers  

---

What language is sql server written in?

0 Answers  

---

explain different types of jions with examples briefly?

1 Answers   Zensar,

---

Tell me what is a linked server?

0 Answers  

---

Difference between server.transfer and server.execute method?

2 Answers  

---

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,

---