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

SQL stops working in every 15 days displaying message that database log file is full. Log file size is 3.95 GB. It is happening after shrinking the database also. What is solution to overcome this problem. Please help me as it's urgent.

5 Answers  

---

Can the query output be sorted by multiple columns in ms sql server?

0 Answers  

---

Can XML be used to access data?

2 Answers  

---

What is a table called, if it has neither cluster nor non-cluster index? What is it used for?

0 Answers  

---

What is normalization according to you and explain its different levels?

0 Answers  

---

Hello all, I have data like :- year amt 2004 10 2005 20 2006 30 Now i want output as:- 2004 2005 2006 10 30 60 but i have to use here group by on year.So, i need a single query within that i can find.

3 Answers  

---

Explain primary key?

0 Answers  

---

Can truncate be rolled back?

0 Answers  

---

Is a primary key unique?

0 Answers  

---

Tell me about builtinadministrator?

0 Answers  

---

What is a fill factor?

0 Answers  

---

Can another user execute your local temporary stored procedures?

0 Answers  

---