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 are the results of running this script?

933

---

What do you understand by user-defined function in the sql server?

956

---

Mention the differences between substr and charindex in sql server.

1055

---

What is the query and subquery?

1079

---

What is single-user mode and what are the steps you should follow to start sql server in single-user mode?

976

---

What are the character string functions supported by sql server 2005?

1016

---

Tell me what are the essential components of sql server service broker?

942

---

What is temporal data type?

925

---

Mention what are the different types of ssrs reports?

152

---

What is explicit cursors?

1076

---

Where do we use trace frag?

1022

---

How do you delete duplicate records in sql server?

1063

---

Create and insert into temp table in sql server?

1036

---

Explain activity monitors

1082

---

What are different types of collation sensitivity?

989

---