Answer Posted / brindly

"IS A MECHANISM TO TRACK CHANGES IN TABLE.
IT UPDATE ITSELF WHEN THERE IS A UPDATION IN ROW CONTAING
TIMESTAMP COLUMN"

I accept above answer.
But whether the timestamp field updates itselt in a
incremental fashion.

Explain how would you store your query in an SSRS report or a Database server?

128

---

How to get the definition of a trigger back?

1002

---

You are creating an application where users are asked their gender in the gender combo box you have three options: ‘male’ , ‘female’ and ‘i choose not to disclose’ these options are stored in the table as 1, 0 or null which datatype should you use?

1010

---

What is the Main Difference between ACCESS and SQL SERVER?

1141

---

Explain the properties of a relational table?

1026

---

Can sql servers linked to other servers like oracle?

955

---

What are the disadvantages of primary key and foreign key in SQL?

1116

---

Characterize join and name diverse sorts of joins?

968

---

How to create a stored procedure with a statement block in ms sql server?

1070

---

code to create procedure for taking databse backup in sql server or i have the query for it but what it's query returns means i want to show on my jsp that the databse backup has been taken on the basis of that return value.does it returns 0 or 1.wat is the code for that

2221

---

Can you explain how long are locks retained within the repeatable_read and serializable isolation levels, during a read operation with row-level locking?

991

---

What is inner join in sql server joins?

1040

---

Explain what are partitioned views and distributed partitioned views?

943

---

Explain what is the function of sql server agent windows service?

996

---

Explain the functionalities that views support?

1121

---