this is right but i want to find out all fields whereas it gives only two field.

No, i m using SQL SERVER 2000

My dear,

below error is coming

Incorrect syntax near the keyword 'OVER' 🙂

there is Error on query analyzer by executing this query.:)

i have a table.

fields =

1) Id

2) name

3) EmailId

4) Age

5) Salary

now i want distinct recordsbased on name and EmailId then what should do me

Hi,

for creating a stored procedure for different tables you should do following:

create proc usp_name

(

@parameter1 bigint = null ,

@parameter2 bigint = null ,

@parameter3 bigint = null ,

@parameter4 ...

Thanx for giving answer but i have done it.

mention not, next time meet u.