Answer Posted / saurabh tyagi

select id ,partcode from prt where id in
(

select case when row_number() over (order by partcode ) %
5 = 0
then row_number() over (order by
partcode)
else 0 end
from prt
)

Give main differences between "Truncate" and "Delete".

578

---

How to verify the port number of the sql server?

553

---

my name is sejal I have cleared the sbi clerk exam. I am BCA graduate My favorite subject RDBMS Relational database management system. so please send me rRDBMS related interview questions

1534

---

What is the largest component inside a field?

532

---

How do you drop an index?

500

---

---

How can I tell if sql server is 32 or 64 bit?

501

---

How to check what was the last restore transaction LSN in Log shipping or Mirroring? when we don't have a Monitor or witness server.

3370

---

How to use copy and concatenate commands in SQL?

599

---

What is dirty page?

564

---

What do you understand by triggers?

522

---

what data regions are and what are the different data regions?

101

---

What is function of CUBE ?

607

---

What are the 10 characteristics of data quality?

527

---

Explain nested stored procedure. Syntax and an example for create nested stored procedure?

530

---

Explain the purpose of indexes?

544

---