Answer / priyanka rani

By using Update statement. For example Update table_name set column_name='value' where column_name='your condition'
if required use where condition

Is a null value equal to anything? Can a space in a column be considered a null value? Why or why not?

0 Answers  

---

What is the native system stored procedure to execute a command against all databases?

0 Answers  

---

When does the auto update index statistics feature in sql server turn itself on?q) what specific conditions database should meet, before you can bulk copy data into it using bcp?

0 Answers  

---

What happens if you insert a duplicate key for the primary key column in ms sql server?

0 Answers  

---

What is onf in normalization form?

0 Answers  

---

---

What's the maximum size of a row?

4 Answers   IBM,

---

What is an identity column in insert statements?

0 Answers  

---

how to take backup bcp out for a column in table in sql server?

0 Answers  

---

What are the main sources of data?

0 Answers  

---

What do you understand by triggers and mention the different types of it?

0 Answers  

---

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?

0 Answers  

---

What is the maximum size of a row in sql server?

0 Answers  

---