Add Serial No/Identity Column in Select Statement SQL Script in run time

Table Name : EmployeeInfo
We have to Select EmpName, Address, and Extra Serial column then


select e.EmpName, e.Address,id_col=count(*)
from EmployeeInfo e,EmployeeInfo b
where (e.EmpName+e.Address)<=(b.EmpName+b.Address)
group by e.EmpName, e.Address
order by id_col

or

select EmpName, Address, id_col=IDENTITY(int,1,1)
into #tmpEmp
from EmployeeInfo

select * from #tmpEmp

IIS 7 in Windows server 2008

IIS 7 IP Address change stopped website

For that problem we  have to change IP Address from listen of windows server 2008.

Click Start, click Run, type cmd, and then click OK.

for show listed ip write in command line> netsh http show iplisten

for add ip in list write in command line> netsh http add iplisten xxx.xxx.x.x 


for delete listed ip write in command line> netsh http delete iplisten xxx.xxx.x.x 


Ref: http://support.microsoft.com/kb/954874

Dynamically number rows in a SELECT Transact-SQL statement

Select sno=count(*),a.employee_name
from empmaster a,empmaster b
where a.employee_name >= b.employee_name
group by a.employee_name
order by sno

sno Employee_name
--- -----------------
1 Shidkers
2 Rana
3 Admin
4 AKRAMOL
5 ASAD
6 BABUL
7 FARIDUL ISLAM
8 JAHANGIR
9 JAHID HASAN
10 LITON SHEIKH
11 MAHFUZ



Ref: http://support.microsoft.com/kb/186133