Answer / Sukh Beer Singh

In SQL Server, atomicity refers to the property of a database transaction ensuring that the entire transaction completes successfully or fails as a whole. This means that if one operation within the transaction fails, all prior operations are rolled back, ensuring data integrity.

What is the maximum length of an alert name?

1 Answers  

---

I have a table in which phno is one of the columns.i do have some values in tht phno column.i need to update phno column values with 0(zero) as prefix.give me a correct solution plz...

7 Answers   Value Labs,

---

What is indexed view?

1 Answers  

---

Write a SQL command to insert and update only a particular field?

1 Answers   ADITI,

---

How to get a list of columns using the "sys.columns" view in ms sql server?

1 Answers  

---

1.what is the difference between view and cursor? 2.If we do any change in view will it affect the database,similarly when we do changes in cursor will it affect the databse?with certain example?Thanks

5 Answers  

---

What happens when converting big values to numeric data types?

1 Answers  

---

Wht is SQL Injection Attack ?

3 Answers  

---

Tell me what is the difference between locking and multi-versioning?

1 Answers  

---

What is data compression?

1 Answers  

---

What is the difference between Stored Procedures and triggers?

1 Answers   HCL,

---

What is table constraint?

1 Answers  

---