Answer Posted / pradeepreddy

differential backup backups only changes made in the
database on to backup media since the last full backup

What is the difference between a primary key and a unique key? Are they the same?

1009

---

When do you think a developer should use sql server-based cursors?

976

---

Explain in brief about Microsoft SQL server?

1012

---

Define ACID properties in a Database?

1004

---

What do you mean by normalisation?

962

---

How many triggers are possible per table?

1038

---

What are the types of subscriptions in SQL Server replication?

962

---

What are exact numeric data types in ms sql server?

988

---

Explain what is log shipping?

1073

---

Benefits of Stored Procedures?

918

---

I have a table Events Events containing cardno,time,id,name--each id has a cardno my requirement is every day each employee swipe the card several times i want to calculate first and last time of each card the output should be name 1 2 6 7 in out in out holiday holiday xxx 09:30 06:30 09:40 06:45 where 1,2...... are dates for example january 1,2, etc. 6 and 7 are saturday and sunday how it is posssible

2180

---

Explain what are the events recorded in a transaction log?

936

---

What are the different types of replication are there in sql server 2000?

982

---

How to provide default values to function parameters?

1051

---

Explain about unique identifier data type in sql server?

857

---