How to find nth maximum salary in sql server (using function)

select nth minimum salary,nth maximum salary  from table ins sql server 2008  with using sql function use test /create table EmpSalary…………………………….. create  table EmpSalary (SrNo int identity(1,1),EmpName nvarchar(50),Salary int) insert into EmpSalary values('Dinesh Singh',8000) insert into EmpSalary values('Roshan Sharma',14000) insert into EmpSalary values('Rohi Tiwari',15000) insert into EmpSalary values('Ramesh...

Read More

How to use autocompleteextender Ajax Control example with textbox in asp.net

How to use autocompleteextender  Ajax Control example with textbox in asp.net // For  Sql Server 2008 …………………………….. create database test use test create table StateName(SrNo int identity(1,1),StateCode nvarchar(50) primary key,StateName nvarchar(50) unique) insert into StateName values('Mahar11','Maharashtra') insert into StateName values('Madhy11','Madhya Pradesh') insert into StateName values('Manip11','Manipur') insert into...

Read More

How to Upload data of DataGridView in Microsoft Excel

How to Upload data of DataGridView in Microsoft Excel create database test use test create table StudentDetails(Name nvarchar(50),FatherName nvarchar(50), MobileNo nvarchar(50)) insert into StudentDetails values('Anurag Sir','Mr Mudgal','08802200402') insert into StudentDetails values('Kush Tiwari','Jai Prakash Tiwari','9451119029') First we take a Windows Form after it we add add reference Microsoft  Excel 12.0 object...

Read More