Why I can not enter 0.001 second in date and time literals in ms sql server?

0 Answers  

---

Write the SQL query to drop, truncate and delete table.

0 Answers   HPCL, Hughes Systique Corporation, Ittiam Systems,

---

What is the difference between the following two sql statements select count(*) from <tablename> select count(col_name) from <tablename>

5 Answers   247Customer,

---

How network traffic be reduced by using the stored procedure?

0 Answers   Accenture,

---

How to insert a new row into a table with "insert into" statements in ms sql server?

0 Answers  

---

---

How to delete particular value in the column of a table.Is it possible or not?if possible give it as in query.

8 Answers   Intelenet,

---

When columns are added to existing tables, what do they initially contain?

0 Answers  

---

Difference between report and query parameter. Why do we need different type of parameter?

0 Answers  

---

Please give me queries for the following 1. To get the count of duplicate records. 2. A query to delete the duplicate records.

3 Answers   247Customer,

---

Create Index myIndex On myTable(myColumn) What type of Index will get created after executing the above statement

3 Answers  

---

Which is the subset of SQL commands used to manipulate Oracle Database structures, including tables?

2 Answers  

---

How can I track the changes or identify the latest insert-update-delete from a table?

0 Answers  

---