Answer Posted / mohan krishna

declare @querry nvarchar(500)
declare @row varchar(10)
set @row = '5'

set @querry ='
select top 1 a.* from
(select * from vdpmaster..usermaster
where usr_id not in
(select top '
set @querry = @querry + @row + ' usr_id from
vdpmaster..usermaster)
)a'
print @querry
EXEC sp_executesql @querry

as a general practice, it is recommended to have dbo be the owner of all database objects however, in your database you find number of tables owned by a user other than dbo, how could you fix this? : Sql server administration

1019

---

How to delete duplicate rows in sql server?

1156

---

How many types of triggers in sql server?

1094

---

Is sql server difficult to learn?

968

---

What is the difference between clustered and a non-clustered index?

1079

---

What is the partitioning method?

1068

---

Explain hostprotectionattribute in sql server 2005?

1075

---

Explain filestream storage of sql server 2008?

1080

---

What programming language would you use to create embedded functions in ssrs?

191

---

Is the order of columns in the set clause important in ms sql server?

1014

---

Can you please differentiate between a primary key and a unique key?

1051

---

What is merge join?

1240

---

How is a full-text index updated?

1003

---

Define outer join?

1048

---

Explain the microsoft sql server delete command? : SQL Server Architecture

1150

---