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 do I create a stored procedure in dbml?

687

---

Write a sql query to sort on different column name according to the parameters passed in the function?

695

---

Why it is recommended to avoid referencing a floating point column in the where clause?

700

---

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

707

---

Is natural join and equi join same?

707

---

---

What are extended events in sql server?

670

---

What is subquery explain with example?

796

---

What functions can a view be used to performed?

794

---

What is unique key constraint?

806

---

What are the types of indexes?

768

---

What is the use of group by clause?

708

---

explain what are the steps you will take, if you are tasked with securing an sql server? : Sql server database administration

833

---

How to connect to a sql server using odbc_connect()?

835

---

What is resource governor in sql server?

721

---

What is transact-sql language?

755

---