Answer Posted / professor r.arjunarao

TimeStamp field to detect update collisions in order to
reduce the amount of data sent to the server

example
CREATE TABLE emp (empno int PRIMARY KEY, tax int, TS timestamp)
GO
INSERT INTO emp (empno, tax) VALUES (1, 0)
GO
INSERT INTO emp (empno, tax) VALUES (2, 0)
GO
select * from emp;

1 0 0x0000000000000FA1<---Unique values
2 0 0x0000000000000FA2<---Unique values

How to loop through result set objects using odbc_fetch_row()?

959

---

Define cross join in sql server joins?

1010

---

Explain how to send email from sql database?

1036

---

What do you mean by an execution plan?

1104

---

What is checkpoint in sql server?

1118

---

What happens if we shrink log file in sql server?

968

---

What are the encryption mechanisms in sql server?

1014

---

What is the optimal disk configuration for a database server and what raid configurations would you use if budget is not a constraint?

953

---

Can you create a logon trigger in sql server 2005 express edition?

1071

---

What is 1nf 2nf and 3nf?

881

---

In case you have filters in your report, when filters will be applied in cached report instance?

113

---

How to create an index on a view?

1054

---

What is an sql server agent?

1050

---

What are different types of schemas?

933

---

Which is the best place or learning center for MS SQL?????In Bangladesh?????

2062

---