what is the difference between truncate and drop statements? : Sql dba

0 Answers  

---

What is mutating trigger?How to avoid it??

3 Answers   Tech Mahindra,

---

What are the advantages of VIEW?

5 Answers  

---

i have a column which may contain this kind of value: 123*67_80,12*8889_5,34*8_874 ,12*7_7 (can contain space before a comma, and this string length can be anything) now i want to split this value into two column like: column1: 123*67,12*8889,34*8,12*7 column2: 80,5,874,7 use function for this

0 Answers  

---

Write a query to find the employees from EMP table those who have joined in Monday. (there is a column as hiredate which is a date column i.e values are like 03-DEC-81)

5 Answers  

---

---

Which constraints we can use while creating database in sql?

0 Answers  

---

What is the difference between a query and a report?

0 Answers  

---

How many sql statements are used?

0 Answers  

---

What is clustered and non-clustered indexes?

4 Answers   Microsoft,

---

if table named a is there and 4 records are there then how to swap (1 and 3) and (2 and 4) records at a time

1 Answers  

---

What is the difference between a primary key and a clustered index?

0 Answers  

---

Is natural join same as inner join?

0 Answers  

---