Answer Posted / ranjay

Truncate / When use Truncate after that insert new record
into the table row started from 1 but
Delete / When delete record in a table after that insert
new record row id started from after the deleted row
For e g, I m create a table Employee and insert 5 record
row number set identity true and increment by 1
After that, I m delete last record I e row number is 5
after delete I m insert new record in a table then row id
started from 6 not 5 but when truncate table row id start
from 1

Can multiple columns be used in sql group by clause in ms sql server?

1059

---

What is a trace frag? Where do we use it?

1108

---

Do you know what are various aggregate functions that are available?

1134

---

What is merge replication?

1113

---

What is bcp? When does it used?

986

---

What is named query? : sql server analysis services, ssas

972

---

What is b tree index?

921

---

How to disable a login name in ms sql server?

1140

---

What is a recursive stored procedure in sql server?

1184

---

what method you can use to reduce the overhead of Reporting Services data sources?

258

---

Why transaction is important?

983

---

Which sql server table is used to hold the stored procedure script?

954

---

How to execute function in stored procedure sql server?

1164

---

What is stretch database in sql server?

1074

---

What is the use of floor function in sql server?

1092

---