Answer Posted / vnreddy

create table sampletbl(id int,name varchar(100))

insert into sampletbl values(1,'aa')
insert into sampletbl values(1,'aa')
insert into sampletbl values(1,'aa')
insert into sampletbl values(2,'bb')
insert into sampletbl values(2,'bb')

with cte as(
select ROW_NUMBER() over (partition by id order by id) as r_no,* from sampletbl)
delete from cte where r_no>1

select * from sampletbl

What is the downside of using udf?

1041

---

You are creating an application where users are asked their gender in the gender combo box you have three options: ‘male’ , ‘female’ and ‘i choose not to disclose’ these options are stored in the table as 1, 0 or null which datatype should you use?

944

---

What is checkpoint in sql server?

1056

---

Explain something about security and SQL Azure?

110

---

What are unicode character string data types in ms sql server?

1137

---

Mention the different types of replication in sql server.

955

---

What are .mdf files?

882

---

What is a db view?

853

---

What is difference between equi join and natural join?

963

---

What are click through reports?

138

---

What are distinctive joins find as a part of sql?

905

---

 Explain what is sql override for a source taLle in a mapping?

942

---

Explain DBCC?

907

---

What area unit the various kinds of info compression introduced in sql server 2008?

1034

---

What are drillthrough reports?

141

---