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

Why it is recommended to avoid referencing a floating point column in the where clause?

1010

---

what are user defined datatypes? : Sql server database administration

1014

---

How to get a list of all tables with "sys.tables" view in ms sql server?

1081

---

What do we have to check in database testing?

1056

---

How to connect of datebase with sql express.?

1143

---

What is star, snowflake and star flake schema? : sql server analysis services, ssas

1225

---

What is the difference between Clustered and Non-Clustered Index?

1101

---

What do you mean by recursive stored procedure?

987

---

What is difference statement and preparedstatement?

1031

---

How to install sql server 2005 express edition?

1166

---

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

1088

---

how to take backup bcp out for a column in table in sql server?

2142

---

What does it mean to normalize a database and why would you do it?

1022

---

What is a partition function in sql server?

1215

---

How would you go about developing a ssrs report?

174

---