How to find duplicate records in a table

SELECT
<list of all columns>
FROM
tablename
GROUP BY
<list of all columns>
HAVING
Count(*) > 1

Mouse missing. What can I do ?

   Don't worry friends . Here is an alternative.



In a situation where your mouse is spoilt, not available or maybe you want to simply impress your friends, you can use your keyboard as a mouse.it is a very simple method and you can acces...s your keyboard like a mouse.

To activate this just press : Alt+Left shift key+num lock
now you can access your keyboard as a mouse.

navigation keys for keyboard



5-select
2-move down
8-move up
4-move left
6-move right
for double click,just press the plus symbol(+)
for right click,just press the minus symbol (-)

to deactivate just press same key (i.e., Alt+Left shift key+num lock)

Thats all on how you can use your keyboard as a mouse at any time.
Courtesy: SA POST

How to Use NULL in SQL server Query ?

Dear Friends,  If a column has the value NULL , if you want to use Null in your query , then use the word IS instead of =.  


Let us explain how to use in query


Select * from table1 where month=Jan


Select * from table1 where month IS NULL

Welcome

The Place for all your Technology Issues