Differencr Between DELETE and TRUNCATE?

3 Answers   ADP,

---

How can I create a plain-text flat file from SQL Server as input to another application?

2 Answers  

---

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  

---

How do you load large data to the SQL server database?

2 Answers  

---

What is data integrity? Explain constraints?

1 Answers   Thinksoft,

---

---

What are the benefits of filtered indexes?

0 Answers  

---

How you can change the database name in SQL SERVER?

0 Answers  

---

What are the different types of subquery?

0 Answers  

---

wat is mean by normalization?......programing defination i need...(i know basic defination)

4 Answers   Wipro,

---

When would you use an insert into .. Select option versus an insert into .. Values option? Give an example of each?

0 Answers  

---

What guidelines should be followed to help minimize deadlocks?

0 Answers  

---

Let’s say the table in the database is named as TBL_Register. The fields in this table include: 1. User_Name, 2. User_Telephone, 3. Register_Date The field Register_Date stores the current date and time of the registration. Write the SQL statement that inserts the data into the table.

2 Answers   Techno Solutions,

---